Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 09-07-2005, 02:22 PM
bi11i's Avatar
bi11i bi11i is offline
 
Join Date: Aug 2004
Location: Portland, OR
Posts: 134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 1146 Error After Plugins Installation

I upgraded to v3.5.0rc2 about a week ago and things appear to be running just fine. Last night I got this error:
Code:
Database error in vBulletin :
Invalid SQL:
 
SELECT title, data
FROM datastore
 
WHERE title IN ('','options','bitfields','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','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 
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...[
Reply With Quote
  #2  
Old 09-07-2005, 02:37 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I would guess it is the Top X stats.
Reply With Quote
  #3  
Old 09-07-2005, 02:40 PM
bi11i's Avatar
bi11i bi11i is offline
 
Join Date: Aug 2004
Location: Portland, OR
Posts: 134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by MarcoH64
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'.
Reply With Quote
  #4  
Old 09-07-2005, 02:43 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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).
Reply With Quote
  #5  
Old 09-07-2005, 02:47 PM
bi11i's Avatar
bi11i bi11i is offline
 
Join Date: Aug 2004
Location: Portland, OR
Posts: 134
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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....
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:58 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03971 seconds
  • Memory Usage 2,190KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete