Database error in vBulletin 4.0.0 Beta 5:
Invalid SQL:
SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
(CASE WHEN node.contenttypeid = 17 THEN node.styleid ELSE parent.styleid end ) AS styleid, nuserid,
(CASE WHEN node.contenttypeid = 17 THEN node.layoutid ELSE parent.layoutid end ) AS layoutid,
node.publishdate, node.setpublish, node.issection, node.permissionsfrom, node.nodeleft, node.noderight,
node.userid, node.showtitle, node.showuser, node.showpreviewonly, node.lastupdated, node.showall,
node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled , info.description, info.title, info.html_title, info.viewcount, info.creationdate, info.workflowdate, info.keywords,
info.workflowstatus, info.workflowcheckedout, info.workflowlevelid, info.associatedthreadid, info.creationdate,
info.ratingnum, info.ratingtotal, info.rating,
user.username, thread.replycount, sectionorder.displayorder
FROM cms_node AS node
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
LEFT JOIN cms_sectionorder AS sectionorder ON sectionorder.sectionid = node.parentnode
AND sectionorder.nodeid = node.nodeid
LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode
WHERE node.nodeid = 1;
MySQL Error : Unknown column 'info.ratingnum' in 'field list'
Error Number : 1054
Request Date : Saturday, December 5th 2009 @ 07:15:16 PM
Error Date : Saturday, December 5th 2009 @ 07:15:16 PM
Script : O_a
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.81-community-log