[Forum] Unknown column 'htmlstate' in 'field list'

[albrens]

Hey guys,

I've just got the error in our forum.

Database error in vBulletin 4.0.2:

Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, htmlstate, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
VALUES
(1, 1, '', 'admin', 1, 'test', 'Hello guys,', 0, 1, 1271008555, 'MyIP', 0, 90991);

MySQL Error : Unknown column 'htmlstate' in 'field list'
Error Number : 1054
Request Date : Sunday, April 11th 2010 @ 01:55:55 PM
Error Date : Sunday, April 11th 2010 @ 01:55:55 PM
Script : http://www.albrens.com/vb/newthread....ostthread&f=89
Referrer : http://www.albrens.com/vb/newthread....newthread&f=89
IP Address : MyIp
Username : admin
Classname : vB_Database
MySQL Version : 5.0.90-community

Is there any idea to fix it?

Thanks!

[Biker]

Did you attempt an upgrade to 4.03?

[Jhumon]

I think so.

[albrens]

Biker,

Yes I did, then I did restore backup database and files.

Thanks!

[chithanh]

I have same problem when I try to upgrade my site, any one please help

[Lynne]

That field is added when you upgrade to 4.0.3. The error in the first post is because the user is using 4.0.3 files with a 4.0.2 database. The upgrade script needs to be run.

[Ramsesx]

That field is added when you upgrade to 4.0.3. The error in the first post is because the user is using 4.0.3 files with a 4.0.2 database. The upgrade script needs to be run.

On this post he said that he did run the upgrade script Lynne.