Announcement

Collapse
No announcement yet.

Step 13 error 1054

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Step 13 error 1054

    Here's the error:
    Code:
     
     
    Invalid SQL: 
     
    SELECT post.attachmentid, post.postid, attachment.postid AS attachment_postid
     
    FROM post
     
    LEFT JOIN attachment ON (attachment.attachmentid = post.attachmentid)
     
    WHERE post.attachmentid <> 0
     
    ORDER BY post.attachmentid DESC
     
    LIMIT 0, 500
     
     
     
    mysql error: Unknown column 'post.attachmentid' in 'field list'
     
    mysql error number: 1054
    I checked the database, and there is no ATTACHMENTID field in the POST table. I havent skipped any steps, so can someone give me the values for this so I can create it manually?

  • #2
    Ok, I just checked the upgrade script and there is no ALTAR TABLE POST command prior to this, therefore POST.ATTACHMENTID wasn't created. I dunno what the deal is. ANy help would be appreciated

    Comment


    • #3
      Which upgraqde script were you running exactly? And which version were you upgrading from?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X