CMS Error since upgrade just now

[Microlight]

Database error in vBulletin 4.0.0:

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
Request Date  : Wednesday, January 13th 2010 @ 11:12:50 PM
Error Date    : Wednesday, January 13th 2010 @ 11:12:50 PM
Script        : http://www.microlightforum.com/content.php
Referrer      : http://www.microlightforum.com/showthread.php?1780-Introduction-Video-To-Microlighting-The-Forum
IP Address    : 90.201.91.71
Username      : VinceG
Classname     : vB_Database
MySQL Version : 5.0.87-community

Please help my CMS is now broken.

[captnpineapple]

Upgrade to 4.0.1, that should fix the issue. If not then optimize/repair tables.

[Microlight]

It was the upgrade to 4.0.1 that broke it in the first place. Please someone help my board is down... down... down...

[Trevor Hannant]

Have added details to this bug:

http://www.vbulletin.com/forum/proje...?issueid=35160

In the meantime, can you restore your 4.0.0 database and continue with this? It may be useful if a Developer can access a test installation on your site to trace this through?

[Microlight]

Hi Trevor.

I didn't backup the database before the upgrade because I backed it up last Friday. However, since then I've had a host of new members so don't want to loose them. I have changed my index.php file to go straight to the forum, which is working fine. It is simply the CMS that is not working. I have raised a Ticket with support number 987837 and will give them access to everything on that ticket.

[FF|Skyrider]

Always a good idea to backup before every single update.