and i have error as well
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 < 1293732849 AND child.contenttypeid <> ) THEN 1 ELSE 0 END) AS publish_count
FROM cms_node AS node
LEFT JOIN cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
LEFT JOIN 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 cms_node AS node
LEFT JOIN cm' at line 3
Error Number : 1064
Request Date : Thursday, December 30th 2010 @ 12:14:09 PM
Error Date : Thursday, December 30th 2010 @ 12:14:09 PM
Script :
http://www.colorssky.com/vb/member.php?3-Jenan
Referrer :
http://www.colorssky.com/vb/forum.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.91-community-log