Announcement

Collapse
No announcement yet.

DB Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • DB Error

    Hello, lately I am getting this error at least once a day
    Database error in vBulletin 3.6.5:

    Invalid SQL:

    SELECT *
    FROM session
    WHERE sessionhash = '177cf1578b8172cd99fb6ea1f536ab72'
    AND lastactivity > 1174559857
    AND idhash = '9a561f92a35524d9501ffb8a6682769e';

    MySQL Error : User 'shadowsp_admin' has exceeded the 'max_questions' resource (current value: 50000)
    Error Number : 1226
    Date : Thursday, March 22nd 2007 @ 03:52:37 AM
    Script : http://soforp.com/vb/search.php?do=getdaily
    Referrer :
    IP Address : 64.12.116.201
    Username :
    Classname : vb_database
    My site is relatively small, and my host showed me a "quick fix" just by going to my control panel and updating the database. There has to be a way to keep this from happening again, what would you recommend I do for a permanent fix? I'm thinking it may be time to just change hosts!

  • #2
    Ask your host to increase the value for : max_questions

    Comment


    • #3
      Thanks floris. Typically, what is the standard value for this field?

      Comment


      • #4
        It varies from host to host. You will need to contact your host about this.

        Comment


        • #5
          I asked my host to increase it, and this is what they wrote back. Does this make sense? If so, how would I do this?
          The reason you are receiving the error is due to the 'max_questions' setting which is set to 50,000 per user per hour. This setting is there to ensure that the mysql database cannot be accessed too much by one user and overload the system. The connections will reset every hour and is kept by user. My suggestion to alleviate this issue is to break up your queries between multiple users which would distribute the 50,000 connection queries to multiple users.

          Comment


          • #6
            Unfortunately you have one of the bad hosts. You will continue to have problems as long as you remain with them.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Looks like all I can do is change then lol. Thanks Steve.

              Comment


              • #8
                Just out of curiosity.
                I just ran into this problem myself and Cant Acsses the Admin panel, get db error same on Index page.

                Is this somthing that will corect itself or is it somthing i need to do ?

                And yes i understand i need to lock out for a new host,.

                Comment


                • #9
                  If it's the same error then everything we posted applies to you too.
                  Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
                  Change CKEditor Colors to Match Style (for 4.1.4 and above)

                  Steve Machol Photography


                  Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


                  Comment

                  Loading...
                  Working...
                  X