Announcement

Collapse
No announcement yet.

db error on step 12

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

  • dethfire
    replied
    worked! thanks steve!

    Leave a comment:


  • Steve Machol
    replied
    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
    Script: http://www.sportscardforum.com/newthread.php
    Referer: http://www.sportscardforum.com/newth...newthread&f=94
    Username: greg bernhardt
    IP Address: 68.77.246.240
    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.
Working...
X