No announcement yet.

db error on step 12

  • Filter
  • Time
  • Show
Clear All
new posts

  • dethfire
    worked! thanks steve!

    Leave a comment:

  • Steve Machol
    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);

    Leave a comment:

  • dethfire
    started a topic db error on step 12

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.