Unknown column 'lastthreadid' in 'field list' - what to do?

[FindSP.com]

I Just upgraded to version 3.0.3 and look what happened:

Database error in vBulletin 3.0.3:
Invalid SQL:
SELECT forum.forumid, lastpost, lastposter, lastthread, lastthreadid, lasticonid, threadcount, replycount
FROM forum AS forum

mysql error: Unknown column 'lastthreadid' in 'field list'

mysql error number: 1054

Date: Sunday 15th of August 2004 02:38:08 PM

[Steve Machol]

You didn't upload all the 3.0.3 files. Reupload them all (except install.php and the images). Make sure you upload these in ASCII and overwrite the ones on the server.

[FindSP.com]

Actually I did.... there seems to be some problem with the db... hmm - any query I should run or something? any ideas?

[Steve Machol]

That info doesn't jive with what you said in this post:

http://www.vbulletin.com/forum/showp...9&postcount=10

Either you have this field or you don't. Can you see it in the database?

[FindSP.com]

I don't know where to look I'm not a PHP buff - those when I run the query it says that it's already there and yet I still get this error whe I go to the front page, why is that?

[FindSP.com]

OK - I ran:

ALTER TABLE forum ADD lastthread varchar(250) NOT NULL;

and it fixed it.

Thanks