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]

Originally Posted by kh99

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.