Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10-03-2007, 10:46 PM
PinkDaisy's Avatar
PinkDaisy PinkDaisy is offline
 
Join Date: Sep 2006
Posts: 274
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Database Errors

Quote:
Nick Smith: Hi Jennifer. My name is Nick Smith. How are you today?
jennifer: Hi Nick. I have spoken with support several times now with the same issue.
jennifer: after a few hours of activity on my site, it seems to give a database error that reads:
jennifer: Database error in vBulletin : Invalid SQL: SELECT * FROM datastore WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products','pluginlist','cron','profilefield',' adv_modules','adv_portal_cale','adv_portal_home',' adv_portal_opts','adv_portal_page','adv_portal_tps t','attachmentcache','bbcodecache','birthdaycache' ,'eventcache','iconcache','maxloggedin','rankphp', 'smiliecache','userstats'); MySQL Error : User 'belliesb_forums' has exceeded the 'max_questions' resource (current value: 50000) Error Number : 1226
jennifer: I have done all that is asked of me from the support, and they advised me to delete all database users and that has not seemed to help. I was advised this would cause the issue to stop, but it has not.
Nick Smith: Okay.
Nick Smith: Can you please hold while I review your account?
jennifer: the only way i can do this to get the error to go away is to log into my vdeck and update the database users -- but with being at work all day, its not possible for me to do this, which means my site is un-usable during that whole time.
Nick Smith: Thank you for your patience.
Nick Smith: Can you please provide the URL where you are receiving error?
jennifer: the error is now fixed. But this happens ALL day everyday when I have activity.. I have just copied and pasted to you the error i get in the email.
Nick Smith: Okay.
Nick Smith: If you get ant such issues, please go to the database admin and add a test user to the database.
Nick Smith: It will fix the issue.
jennifer: but they told me to delete all extra ones i had.
jennifer: I had that done and then they told me to delete them ??
Nick Smith: You can delete the test user once your Web site start working.
Nick Smith: Is there anything else I can assist you with today?
Nick Smith: Thanks for chatting with us. If you have any further questions, please don't hesitate to contact us. We are available 24x7.
Chat session has been terminated by the site operator.

This convo tells what all problem I am having. Any ideas??
Reply With Quote
 


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 02:38 PM.


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.03354 seconds
  • Memory Usage 2,282KB
  • 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
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)showthread_list
  • (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_threadedmode.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_threaded
  • showthread_threaded_construct_link
  • 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