Empty CMS-Page and mysql error in ACP

[CGhostGroup]

Hello, after updating my vB 3.8.4 to 4.2pl1 the cms and blog won't show.
The pages are only white (no content or sourcecode) and when I'm trying to edit CMS-Stuff inside the AdminCP I get mysql-errors (see below).

Anyone an idea how to get this working? (I importet the example-data while upgrade). Or maybe can I re-import CMS/Board content?


Navigationmanager:Datenbankfehler in vBulletin 4.2.0:

Invalid SQL:

SELECT node.nodeid, node.parentnode, node.url, node.permissionsfrom, node.setpublish, node.publishdate, node.noderight, nodeinfo.title
FROM vb3_cms_node AS node
INNER JOIN vb3_cms_nodeinfo AS nodeinfo ON (nodeinfo.nodeid = node.nodeid)
WHERE node.contenttypeid =
ORDER BY node.nodeleft ASC;

MySQL-Fehler : 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 'ORDER BY node.nodeleft ASC' at line 5
Fehler-Nr. : 1064
Fehler-Zeit : Monday, 18.06.2012 @ 15:30:22
Datum : Monday, 18.06.2012 @ 15:30:23
Skript : /board/admincp/navigation.php?do=edit&navid=8
Referrer : /board/admincp/navigation.php
Klassenname : vB_Database
MySQL-Version : 5.1.61-0+squeeze1


Content Admin:Datenbankfehler in vBulletin 4.2.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 < 1340026177 AND child.contenttypeid <> ) THEN 1 ELSE 0 END) AS publish_count
FROM vb3_cms_node AS node
LEFT JOIN vb3_cms_node AS child ON child.parentnode = node.nodeid AND child.new != 1
LEFT JOIN vb3_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
ORDER by node.nodeleft;;

MySQL-Fehler : 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 vb3_cms_node AS node
LEFT JOIN ' at line 3
Fehler-Nr. : 1064
Fehler-Zeit : Monday, 18.06.2012 @ 15:29:37
Datum : Monday, 18.06.2012 @ 15:29:38
Skript : /board/admincp/cms_content_admin.php?do=list
Referrer : /board/admincp/index.php?do=nav
Klassenname : vB_Database
MySQL-Version : 5.1.61-0+squeeze1


Thanks and Greetings

[kh99]

It looks like maybe a problem with your contenttype or package tables (or maybe they didn't get created at all?). But I'm not sure how you'd go about fixing that.

If you go to the product manager, do you have vBulletin CMS as a product (and is it enabled)?

[CGhostGroup]

If you go to the product manager, do you have vBulletin CMS as a product (and is it enabled)?

yea, the CMS and Blog-Product is enabled. :(