No announcement yet.

db error on step 12

  • Filter
  • Time
  • Show
Clear All
new posts

  • db error on step 12

    it was updating the attachents and I got generic db error, also on 13, so I skipped both and went to 14 and everything else went fine. I don't understand, I ran the vb3 table check and it was all fine. however when I goto make a new post I get:

    Database error in vBulletin 3.0.3:

    Invalid SQL:
    SELECT COUNT(*) AS count
    FROM attachment
    WHERE posthash = '616f8e63b6686d34a29844c33ea91fb7'
    AND userid = 6259

    mysql error: Unknown column 'posthash' in 'where clause'

    mysql error number: 1054

    Date: Tuesday 14th of December 2004 06:08:50 PM
    Username: greg bernhardt
    IP Address:
    btw, I emptied my attachments table, so maybe I can just add the field?

  • #2
    You can't just skip steps because of 'generic' errors. Assuming thais is the only thing missing, try running theses queries to add this field and the appropriate index:

    ALTER TABLE attachment ADD posthash CHAR(32) NOT NULL DEFAULT '';

    ALTER TABLE attachment ADD INDEX (posthash, userid);
    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.


    • #3
      worked! thanks steve!


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