db error on step 12

[dethfire]

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?

[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);

[dethfire]

worked! thanks steve!