Suite database error ## Unknown column 'article.htmlstate' in 'field list' ##
 

Code:
Database error in vBulletin 4.0.3:

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 cms_node AS node
INNER JOIN cms_article AS article ON article.contentid = node.contentid
INNER JOIN cms_nodeinfo AS info ON info.nodeid = node.nodeid
LEFT JOIN user AS user ON user.userid = node.userid
LEFT JOIN thread AS thread ON thread.threadid = info.associatedthreadid

WHERE node.nodeid = 116;

MySQL Error : Unknown column 'article.htmlstate' in 'field list'
Error Number : 1054
Request Date : Wednesday, April 28th 2010 @ 02:33:44 PM
Error Date : Wednesday, April 28th 2010 @ 02:33:44 PM
Script : /vbi/content.php
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.87-community
Hi Temel.

That means that your upgrade didn't run properly as 'article.htmlstate' is created during the upgrade.

Can you re-run the /install/upgrade.php file and walk through the steps again and see if you get this error after that.

Best regards,


Trevor Hannant
vBulletin Support Staff


but l re-run the install/upgrade.php and again error.