LPH submitted a new blog post:
vBulletin CMS Errors
vBulletin CMS Errors
Continue reading the Original Blog PostThe 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...