Log in

View Full Version : MySQL Error : Table 'ao_forums.guest' doesn't exist


MetalMilitia
08-08-2008, 06:53 AM
Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT * FROM guest FORCE INDEX (lastactive) WHERE lastactive > 1218171600;

MySQL Error : Table 'XX_forums.guest' doesn't exist
Error Number : 1146
Request Date : Friday, August 8th 2008 @ 03:51:42 AM
Error Date : Friday, August 8th 2008 @ 03:51:43 AM
Script : XXX
Referrer :
IP Address : XXX
Username : XXX
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

Happened after the mysql / php update I guess? How can i repair that part of the table?

Marco van Herwaarden
08-08-2008, 07:12 AM
There is nothing to repair if the table is missing.

This is however not a default vBulletin table. Please remove the modification that is using this table or contact the author for a solution.

MetalMilitia
08-08-2008, 07:13 AM
I dont understand.

What is exactly missing then?

Marco van Herwaarden
08-08-2008, 07:23 AM
MySQL Error : Table 'XX_forums.guest' doesn't exist

Opserty
08-08-2008, 09:44 AM
You problem is caused by a modification which is requesting a table that doesn't exsist. You need to find out which modification (enable/disable products one by one in the AdminCP) and remove it in order to fix your problem.