DB Errors.

[Hex_legend]

I had a db error which said forum.forumdatastore does not exist.. So I created the table and I am now getting:

PHP Code:

vBulletin datastore error caused by one or more of the following:

   1. You may have uploaded vBulletin 3.6 files without also running the vBulletin upgrade script. If you have not run the upgrade script, do so now.
   2. The datastore cache may have been corrupted. Run Rebuild Bitfields from tools.php, which you can upload from the do_not_upload folder of the vBulletin package.


Fatal error: vBulletin datastore cache incomplete or corrupt in [path]/includes/init.php on line 214 


I have uploaded tools.php and run the bitfields script and I am getting this db error:

PHP Code:

<!--
Database error in vBulletin :

Invalid SQL:
DELETE FROM forumsettinggroup WHERE volatile = 1 AND (product = 'vbulletin' OR product = '');

MySQL Error   : Table 'forum.forumsettinggroup' doesn't exist
Error Number  : 1146
Request Date  : Thursday, July 24th 2008 @ 11:25:56 PM
Error Date    : Thursday, July 24th 2008 @ 11:25:56 PM
Script        : http://www.newmodifications.com/forum/install/tools.php?do=xml&amp;type=settings
Referrer      : http://www.newmodifications.com/forum/install/tools.php?do=login
IP Address    : 84.67.36.58
Username      : 
Classname     : vB_Database_MySQLi
MySQL Version : 
--> 


I do not know anything about phpmyadmin and don't know how I can sort any of this out.. Can someone help me sort this?

--------------- Added [DATE]1216938727[/DATE] at [TIME]1216938727[/TIME] ---------------

Additional Info

I am running 3.7.2

[Lynne]

Did you run the upgrade script when you upgraded to 3.7.2?

[Hex_legend]

No, it was a fresh install.

For some reason, the site has come back up on its own now - I've not done anything.

Can anyone explain this?

It's not to do with a host as its vps and they don't work at this time of night

[Dismounted]

"forumsettinggroup" is not a default vBulletin table.

[Marco van Herwaarden]

It is if you use the table prefix "forum".

[Hex_legend]

Can anyone explain why it came back up on its own about 30 mins after the error?

Tools.php even caused errors...

[Lynne]

I have no idea. Have you tried asking your host if they were having problems around the time your forum was having problems?

[Hex_legend]

The server status showed fine. There was no lag or anything of that nature.
Like I said, I am on a vps, so I have access to everything that shows the running of the server

[Opserty]

It may have stemmed from this:

I had a db error which said forum.forumdatastore does not exist.. So I created the table and I am now getting:

This table just wouldn't "disappear" something must have happened to it. Creating tables manually isn't really advised, you are just solving the symptoms not the problem itself.

I haven't seen anything like this happening, maybe it was a faulty modification or something, we can't really tell.