No announcement yet.

Step 13 error 1054

  • Filter
  • Time
  • Show
Clear All
new posts

  • Step 13 error 1054

    Here's the error:
    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


    • #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.


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