Log in

View Full Version : 1146 Error After Plugins Installation


bi11i
09-07-2005, 02:22 PM
I upgraded to v3.5.0rc2 about a week ago and things appear to be running just fine. Last night I got this error:Database error in vBulletin :
Invalid SQL:

SELECT title, data
FROM datastore

WHERE title IN ('','options','bitfields','forumcache','usergroupc ache','stylecache','languagecache','products','plu ginlist','cron');

MySQL Error : Table 'vb_opiophile_org.datastore' doesn't exist Error Number : 1146

Date : Wednesday, September 7th 2005 @ 03:50:57 AM
Script : http://forum.opiophile.org/login.php (http://forum.opiophile.org/login.php)
Referrer :
IP Address : 156.153.255.126
Username :
Classname : vB_Database_MySQLi
which is a little strange. I should note that last night I added a couple of plugins. I can disable these, and I'm fine with that, but I wondering if someone could give me some info to go on in tracking down what's causing the error above? The plugins I've installed are "Activity Modification", "Inferno Warning System", "AJAX Shoutbox", "Top X Stats". I only got one of these errors and have had multiple visitors to the forum since it appeared. I've not seen it again.

Any help would be greatly appreciated...[

Marco van Herwaarden
09-07-2005, 02:37 PM
I would guess it is the Top X stats.

bi11i
09-07-2005, 02:40 PM
I would guess it is the Top X stats.

really? you know that's the plugin I've had running for the longest amount of time (about a week without any probs.) If you think so, I'll disable it for a day or three and see what happens.

My first guess would've been the Activity stats; isn't it keeping track of login? I have no idea, my coding knowledge goes as far as clicking 'Import Plugin'.

Marco van Herwaarden
09-07-2005, 02:43 PM
Well from that list, this was the first one that came to my mind, it looked from your post that these where the ones you installed last night.

Best look if there is one that has a cronjob running at night. Otherwise you will have to disable them all, and slowly turning them on again until you get the error.

Ofcourse you can also go through all the code of these hacks (or read the support threads).

bi11i
09-07-2005, 02:47 PM
Thanks, I sifted through the whole board and all the support threads for my particular error before posting, I didn't see much.

Can't find a cronjob that would be causing it. My problem is not being able to reproduce it - if only I could figure out what triggers it...?

I'll disable the Top X stats tonight and then the Acitivity plugin tomorrow.

Thanks for your help - I'm open to any ideas....