CMS Oh Dear!!! I did not backup before upgrading from 4.0.6 to 4.0.7 - and there's a prob
 

OK, completely my fault as I did not backup my database and my server went down during upgrade! upon rebooting I got an error on /finalupgrade.php?step=6.
That effects blogs, which I have disabled, so forced onto 7 then 8 which then says about install.php.

Site all ran fine, until I went to CP-[Settings]Options where I get:

Database error in vBulletin 4.0.7:

Invalid SQL:

SELECT setting.*, settinggroup.grouptitle
FROM VBDB_settinggroup AS settinggroup
LEFT JOIN VBDB_setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder 0
ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error : Table './HIDDEN/VBDB_settinggroup' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, October 5th 2010 @ 06:58:57 PM
Error Date : Tuesday, October 5th 2010 @ 06:58:57 PM
Script : http://HIDDEN/admincp/options.php?null=0
Referrer : http://HIDDEN/admincp/index.php?do=nav
IP Address : HIDDEN
Username : HIDDEN
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-3ubuntu5.4

I obviously can't use the advice here: http://www.vbulletin.com/forum/showt...=upgrade+crash

The plus side is that the actual database information is not vitally important as I have have very little content which is not hard coded (as in styles etc) Forum itself is basically empty.

I appreciate I'm and idiot, but can somebody help please?