[Bouncer222]

Getting error, using latest vb suite.

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 < 1294433638 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  : Friday, January 7th 2011 @ 02:53:58 PM
Error Date    : Friday, January 7th 2011 @ 02:53:58 PM
Script        : http://www.fragtoss.com/member.php?action=getinfo&u=77
Referrer      : http://www.fragtoss.com/forum.php
IP Address    : 96.250.230.245
Username      : Bouncer
Classname     : vB_Database
MySQL Version : 5.1.52