Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 03 Oct 2007, 23:46
PinkDaisy's Avatar
PinkDaisy PinkDaisy is offline
 
Join Date: Sep 2006
Question Database Errors

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','forumcache','usergroupcache','style cache','languagecache','products','pluginlist','cron','profilefield','adv_module s','adv_portal_cale','adv_portal_home','adv_portal_opts','adv_portal_page','adv_ portal_tpst','attachmentcache','bbcodecache','birthdaycache','eventcache','iconc ache','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
  #2  
Old 04 Oct 2007, 03:17
Eikinskjaldi's Avatar
Eikinskjaldi Eikinskjaldi is offline
 
Join Date: Feb 2006
Location: Hell, never looked better
Shared hosts set a limit to howmany database queries each of their clients can have in an hour.

You are exceeding this limit.

You have three solutions
1) Convince your host to up the allowed number
2) have a look at your code and see if some add-on is making alot of database calls
3) find another host.
Reply With Quote
  #3  
Old 04 Oct 2007, 11:35
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Lol, i would be...uhhhh....a little bit angry if i had such a support chat.

MySQL Error : User 'belliesb_forums' has exceeded the 'max_questions' resource (current value: 50000)
As also mentioned above, this is the problem. Your host is limiting the maximum number of queries/hour. The best solution would be for them to raise this value.

Seeing that you are allowed to create more MySQL users, there is however also a workaround for this in case the host does not want to help.

PS Who is your host?
__________________
Marco van Herwaarden
Ex vBulletin.org Coordinator
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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


New To Site? Need Help?

All times are GMT. The time now is 16:12.

Layout Options | Width: Wide Color: