Log in

View Full Version : MySQL Error : Table 'extre9_vbulletin.forum' doesn't exist


InTeNsE-HuMoR
11-08-2006, 10:33 PM
Hi,
Can someone explain to me what I need to do to solve this problem:

Database error in vBulletin 3.6.1:

Invalid SQL:
SELECT * FROM forum WHERE forumid='42';

MySQL Error : Table 'extre9_vbulletin.forum' doesn't exist
Error Number : 1146
Date : Wednesday, November 8th 2006 @ 04:28:05 PM
Script : -----------------------------------
Referrer : ----------------------------------
IP Address : -------------
Username : -------------
Classname : vb_database

I have alot of problems recently when I tried to install VbAdvanced on my forum. First the template looked screwed up then after un-installing vbadvanced followed by the template things got worse the more I tried to fix it. Everything on my forum now seems to work apart from this one error. Can anyone on here tell me what it means and show me how to fix it, please?

r007
11-09-2006, 11:46 AM
Hey InTeNsE-HuMoR -

The error is saying it can't find the 'forum' table in the 'extre9_vbulletin' database.
If you use something like phpmyadmin, does it list that table?

InTeNsE-HuMoR
11-09-2006, 06:14 PM
Yeah, it is definetly there. At least from what I can see (i'm a newbie) but I have backed up the database and am wondering if I should just use phpmyadmin to restore the backup and then just change the defualt template and apply the edits for each modification over again (I have installed a new template since when the last backup was created).

r007
11-10-2006, 11:44 AM
The two other things you can try before you restore your backup is going to your vBulletin Options and disabling the Plugin/Hook System... Maybe there is a rogue plugin that's screwing something up.

The other thing you can try is reuploading all the vBulletin files and see if that does anything.

Quarterbore
11-10-2006, 03:49 PM
Do you have a prfix on the table itself?

For example:

'extre9_vbulletin.vb_forum'

If so, you need that too! Is a custom hack generating this? If so, you need to remember to code in the prefix...

But I am just guessing with the limited info you shared! If it is the prefix, I bet you forgot to add it to the vBA config file!

InTeNsE-HuMoR
11-13-2006, 06:40 PM
Well after just having the same error 5 minutes ago (I did a clean install to fix the last problem) I was about to post here from some further help when I read your replies and started disabling plugins. The plugin that was causing the problem was "Age Lock v2 Beta" Everything seems to be working fine now. :D

NaughtyStud
02-03-2007, 01:01 PM
The two other things you can try before you restore your backup is going to your vBulletin Options and disabling the Plugin/Hook System... Maybe there is a rogue plugin that's screwing something up.

I had been trying to help a friend of mine with his board and couldn't figure out what to do.That's exactly what it was..now the search begins for the bad plugin.:confused: Thank you so much r007. :D