Can someone explain what this means? When I enable CMS I get this error. When running upgrade it went through the installing CMS fine and it does show in the ACP with content.
Database error in vBulletin 4.0.0:
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, node.userid,
(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.showrating,
node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled
FROM v_cms_node AS node
LEFT JOIN v_cms_node AS parent ON parent.nodeid = node.parentnode
WHERE node.nodeid = 1;
MySQL Error : Unknown column 'node.showrating' in 'field list'
Error Number : 1054
Request Date : Wednesday, December 23rd 2009 @ 12:39:42 PM
Error Date : Wednesday, December 23rd 2009 @ 12:39:42 PM
Script : http://www.mydomain.com/forums/content.php
Referrer : http://www.nydomain.com/forums/forum.php
IP Address : 76.25.209.116
Username : Chris
Classname : vB_Database
MySQL Version : 5.0.81-community
Database error in vBulletin 4.0.0:
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, node.userid,
(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.showrating,
node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled
FROM v_cms_node AS node
LEFT JOIN v_cms_node AS parent ON parent.nodeid = node.parentnode
WHERE node.nodeid = 1;
MySQL Error : Unknown column 'node.showrating' in 'field list'
Error Number : 1054
Request Date : Wednesday, December 23rd 2009 @ 12:39:42 PM
Error Date : Wednesday, December 23rd 2009 @ 12:39:42 PM
Script : http://www.mydomain.com/forums/content.php
Referrer : http://www.nydomain.com/forums/forum.php
IP Address : 76.25.209.116
Username : Chris
Classname : vB_Database
MySQL Version : 5.0.81-community
Comment