7 replies to this topic

[wildvettes]

I have Ipage and I am now regularly getting this error while working on my site and I'm guessing with my limited number of visits this is going to get completely and totally out of control with a live site and actual customers.

Any thoughts?

1226 - User 'wildvettes' has exceeded the 'max_questions' resource (current value: 75000)

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]


Should I switch hosts? Is it my website causing the problem? What steps should I take to switch hosts? What hosts does everyone use?

[wildvettes]

Ok, so I'm hoping I figured it out.

When I installed Mindsparx admin panel I must have just copied over because it deleted some of my addon files.

Long story short the Auto-Backup setup file was deleted, but the actual process itself and the code changes were still active. Basically it appears as though it was backing up my entire database constantly creating hundreds and hundreds of database backups.

Hopefully the problem will be rectified now.


*correction thousands and thousands*

Edited by wildvettes, 10 April 2011 - 09:16 PM.

[wildvettes]

Fixed

Edited by wildvettes, 10 April 2011 - 09:22 PM.

[blr044]

wildvettes, on 10 April 2011 - 09:19 PM, said:

Fixed

Would like to know what steps you took to eliminate the issue.  Because I get the same error and iPage told me after I exceed the limit, I have to wait one hour before I am able to access my site again.  It is a very big pain in the ---!  So if there is a fix, I would appreciate hearing about it, so that I will have not to look for another host.

Thanks.

[wildvettes]

blr044, on 10 April 2011 - 10:23 PM, said:

Would like to know what steps you took to eliminate the issue.  Because I get the same error and iPage told me after I exceed the limit, I have to wait one hour before I am able to access my site again.  It is a very big pain in the ---!  So if there is a fix, I would appreciate hearing about it, so that I will have not to look for another host.

Thanks.

My auto_backup_setup.php file was missing from my /admin/.

This allowed my auto_backup_db.php in my /admin/includes to run non-stop which was causing the query problems.

If you have this add-on I would check it is functioning properly first, if not you have something on your site caught in a check sql loop. I doubt your site could be busy enough to have thousands of customers an hour, but that is also a possibility.

[wildvettes]

And NOPE getting the error again. I give up.

What is even better was the fact that I have been away from my PC for the last 45 mins. So who exactly was doing the sql queries?

Edited by wildvettes, 11 April 2011 - 12:13 AM.

[wildvettes]

Is it possible this could be caused by a search engine, hacker, etc...?

Otherwise I can't possible understand how I could be hitting 75,000 an hour. Unless something is going on with my host. I have all of the recommended security enhancements installed...is it possible the site has been hacked?

Nothing seems to be weird other than this message.

[wildvettes]

Got an IP ban about 5 minutes after the most recent shut down, getting the message about every hour or so...this is the first IP ban though.