I got this error. Can you help?
Code:
Database error in vBulletin 4.1.0:
Invalid SQL:
SELECT node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden, COUNT(child.nodeid) AS children,
SUM(CASE WHEN (child.setpublish > 0 AND child.publishdate < 1293840724 AND child.contenttypeid <> ) THEN 1 ELSE 0 END) AS publish_count
FROM vb_cms_node AS node
LEFT JOIN vb_cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
LEFT JOIN vb_cms_nodeinfo AS info ON info.nodeid = node.nodeid
WHERE (node.contenttypeid = )
GROUP BY node.nodeid, node.url, node.parentnode, node.nodeleft, node.noderight,
node.setpublish, node.publishdate, info.title, node.permissionsfrom, node.hidden HAVING COUNT(child.nodeid) > 0
ORDER by node.nodeleft;;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') THEN 1 ELSE 0 END) AS publish_count
FROM vb_cms_node AS node
LEFT JOIN' at line 3
Error Number : 1064
Request Date : Saturday, January 1st 2011 @ 07:12:04 AM
Error Date : Saturday, January 1st 2011 @ 07:12:04 AM
Script : http://www.xxx.com/forum/member.php?action=getinfo&u=844
Referrer : http://www.xxx.com/forum/xxx/2601-title-member.html
IP Address : xxx
Username : xxxx
Classname : vB_Database
MySQL Version : 5.0.91-community