Prob been said but profiles dont work and I get
---------------
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 < 1293729944 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 v' at line 3
Error Number : 1064
Request Date : Thursday, December 30th 2010 @ 11:25:44 AM
Error Date : Thursday, December 30th 2010 @ 11:25:44 AM
Script :
http://www.britmovie.net/britforum/m...on=getinfo&u=1
Referrer :
http://www.britmovie.net/britforum/xperience.php
IP Address : 86.29.56.215
Username : Britmovie
Classname : vB_Database
MySQL Version : 5.1.52
==============================