[Forum] Upgrade from 4.02 to 4.03 Problem - 1 step

[chithanh]

I already shutdown my site, I upload new files to my server. Then I run http://www.mysite.com/install/upgrade.php . Then I got this error message. I try many times but it does not work.

Database error in vBulletin 4.0.2:
Invalid SQL:
SELECT node.nodeid, node.showrating, node.setpublish,
node.contenttypeid, node.contentid, node.url, node.parentnode, node.styleid, node.userid, node.nodeleft, node.noderight,
node.layoutid, node.publishdate, node.publicpreview, node.issection, node.permissionsfrom, node.showtitle, node.showuser, node.showpreviewonly,
node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.showall, node.editshowchildren,
node.shownav, node.hidden, node.nosearch, node.comments_enabled,
info.description, info.html_title, info.title, info.viewcount, info.creationdate, info.workflowdate, info.associatedthreadid,
info.workflowstatus, info.workflowcheckedout, info.viewcount, info.workflowlevelid, info.keywords, info.ratingnum, info.ratingtotal, info.rating,
user.username, article.pagetext, article.threadid, article.blogid,
article.posttitle, article.postauthor, thread.replycount, article.poststarter,
article.previewtext, article.previewimage, article.imagewidth, article.imageheight, article.previewvideo,
article.postid, article.blogpostid, article.post_started, article.post_posted, article.htmlstate
FROM vb_cms_node AS node
INNER JOIN vb_cms_article AS article ON article.contentid = node.contentid
INNER JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid
LEFT JOIN vb_user AS user ON user.userid = node.userid
LEFT JOIN vb_thread AS thread ON thread.threadid = info.associatedthreadid
WHERE node.nodeid = 3602;
MySQL Error : Unknown column 'article.htmlstate' in 'field list'
Error Number : 1054
Request Date : Monday, April 12th 2010 @ 06:42:42 AM
Error Date : Monday, April 12th 2010 @ 06:42:42 AM
Script : http://www.xxx.com/
Referrer :
IP Address : xxxxx
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.89-community

I am using vbulletin software for more than 10 years. This is first time I got error message when I try to upgrade. Something wrong with your software, please check.
Please tell me how to upgrade to new version

[Lynne]

Put in a support ticket with the necessary information to your database/site and let us take a look at this.

[SlickFx]

is there any more info on this issue, it is identical to what i am experiencing when i uploaded files and tried to upgrade

[Trevor Hannant]

In phpMyAdmin, run the following query and this will add the column in there:

ALTER TABLE *PREFIX*cms_article ADD htmlstate enum('off', 'on', 'on_nl2br') NOT NULL DEFAULT 'on_nl2br'

If you're database uses a prefix, replace *PREFIX* with this otherwise remove that before running this.