The last two nights have been an adventure in patience. vBulletin 4.0.1 was installed on a server and was almost working. The CMS stories were not showing and so I decided to remove the CMS tables from the database and import in tables from a working CMS.

Unfortunately, the following error is shown in a browser.

Database error in vBulletin 4.0.1:

Invalid SQL:
SELECT node.nodeid , (node.nodeleft = 1) AS isroot, node.contenttypeid, node.contentid, node.url, node.parentnode,
(CASE WHEN node.contenttypeid = 17 THEN node.styleid ELSE parent.styleid end ) AS styleid, node.userid,
(CASE WHEN node.contenttypeid = 17 THEN node.layoutid ELSE parent.layoutid end ) AS layoutid,
node.publishdate, node.setpublish, node.issection, node.permissionsfrom, node.nodeleft, node.noderight,
node.userid, node.showtitle, node.showuser, node.showpreviewonly, node.lastupdated, node.showall, node.showrating,
node.showupdated, node.showviewcount, node.showpublishdate, node.settingsforboth, node.includechildren, node.editshowchildren,
parent.permissionsfrom as parentpermissions, node.publicpreview, node.comments_enabled, node.shownav,
node.hidden, node.nosearch

FROM cms_node AS node
LEFT JOIN cms_node AS parent ON parent.nodeid = node.parentnode

WHERE node.nodeid = 1;

MySQL Error : Unknown column 'node.shownav' in 'field list'
Error Number : 1054

The database table node definitely does not have shownav and trying to manually add it doesn't solve the problem.

I next tried to export an xml through a working vbulletin and import the CMS. This time, several errors were present until I saved permissions. Once permissions were saved, though - the error above showed up in the browser.

Apparently someone else is having similar problems.

Drats.