Error 1146 | Table Does Not Exist Problems

[topianno]

First off, my forum is down. I am running version 4.0.4.

The error messages I am receiving are Error Number 1146, stating that the table doesn't exist. I've noticed this message comes up for several tables.

Does anyone know how to resolve this? I need to get this forum back up ASAP.

Below is an example of one of the error messages...

Database error in vBulletin 4.0.4:

Invalid SQL:

SELECT *
FROM session
WHERE userid = 0
AND host = '87.118.135.65'
AND idhash = 'c0906fc6d5e4cf4cf8500a487876e945'
LIMIT 1;

MySQL Error : Table 'drkurifo_forum1.session' doesn't exist
Error Number : 1146
Request Date : Wednesday, January 18th 2012 @ 10:10:19 AM
Error Date : Wednesday, January 18th 2012 @ 10:10:19 AM
Script : http://forum.lapbandsurgery.com/forum.php
Referrer :
IP Address : 87.118.135.65
Username :
Classname : vB_Database
MySQL Version :

[kh99]

Have you made any changes to the site? If you've edited your config.php file you probably want to check and make sure it still has valid database info (although you are obviously connecting to *some* database).

If it's just the session table missing, you could recreate it using myphpadmin or whatever other program you use to access your database. If you have a copy of the vb source you can look in install/mysql-schema.php to see the command used to create it (I'd look myself but I don't have source for that version and I don't know if it's changed).

If there are tables missing other than session then you'd probably have to restore a backup.

[Lynne]

Did you touch your config.php file recently? Maybe you have the wrong table prefix in there.