CMS Getting Database Error On CMS ONLY! PLEASE HELP!
 

<div>For some reason, My Vbulletin 4.0 CMS systems are reporting database error, while the "Forum" and "Blog" areas work fine. Below is the database error I am getting:

<div class="bbcode_container"> Quote:
<div class="bbcode_quote printable"> Database error in vBulletin 4.0.1:

Invalid SQL:
SELECT parent.category AS parentcat, cat.categoryid, cat.category,
cat.catleft, cat.catright, info.title AS node, parentnode.nodeid, count(nodecat.nodeid) as qty
FROM cms_node AS node
INNER JOIN cms_node AS parentnode ON node.nodeleft BETWEEN parentnode.nodeleft AND parentnode.noderight
INNER JOIN cms_nodeinfo AS info ON info.nodeid = parentnode.nodeid
INNER JOIN cms_category AS parent on parent.parentnode = parentnode.nodeid
INNER JOIN cms_category AS cat ON cat.catleft BETWEEN parent.catleft AND parent.catright
LEFT JOIN cms_nodecategory AS nodecat ON nodecat.categoryid = cat.categoryid
WHERE node.nodeid = 1 AND ( (node.permissionsfrom IN (1,7)) OR (node.userid =1) OR (node.permissionsfrom IN (1,4,5,6,7,8) AND node.setpublish = 1 AND node.publishdate