thessrtech Posted November 7, 2005 Share Posted November 7, 2005 1226 - User 'addictiv_p_os2' has exceeded the 'max_questions' resource (current value: 50000) delete from whos_online where time_last_click < '1131366525' [TEP STOP] ???? Link to comment Share on other sites More sharing options...
kgt Posted November 7, 2005 Share Posted November 7, 2005 Your host has set a limit to the number of queries your site can perform in one hour. This is why you may see this error intermittently, or you might never see it again. It's not an OSCommerce error, though there are steps you can take to reduce the number of queries you're running against the database. You will need to contact your host and see what they offer as a solution. They may increase your max_query number, or they may give you a second user name, or they may ask for more money. Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
KaiAnimation Posted November 13, 2005 Share Posted November 13, 2005 I caused this "delete from whos_online where time_last_click" problem myself. I used a link checking program to check for bad links on my website. It ended up following over 18000 links, which I wasn't expecting. This ended up resulting in the "delete from whos_online where time_last_click" error. I found the necessary reset code to use in mySQL database on this forum posted by Ajeh at this link: http://www.oscommerce.com/forums/index.php?showtopic=57891 This is something I did't know how to fix. Ajeh's code really helped. The code got me up and running. The first time I had a "you've accessed your database too many times" type error. I called the support desk at my web host. The tech told me it was a problem on my side, having to do with the php files. The problem wasn't fixed. I called back again and got another guy and he fixed it/reset it right away. I guess my point here is, the support desk is made up of people who know what they're doing and people who don't. Danny If I'm giving advice, it is based on what path I would take to fix your problem. My path may be wrong. Link to comment Share on other sites More sharing options...
esearing Posted December 20, 2005 Share Posted December 20, 2005 I'm running into the same problem with my host. I finally got one of them to tell me what they were doing... They were resetting the mySQL database password and changing it back. Seems to close any hanging connections. The error indicates an hourly problem and should fix itself but doesn't if there are still open connections. So somewhere in the PHP there is a DB connect that is not closing after the query. Has anyone found it? Link to comment Share on other sites More sharing options...
kgt Posted December 20, 2005 Share Posted December 20, 2005 In includes/configure.php and admin/includes/configure.php, make sure USE_PCONNECT is set to false. define('USE_PCONNECT', 'false'); // use persistent connections? http://us2.php.net/manual/en/features.pers...connections.php Contributions Discount Coupon Codes Donations Link to comment Share on other sites More sharing options...
esearing Posted December 22, 2005 Share Posted December 22, 2005 In includes/configure.php and admin/includes/configure.php, make sure USE_PCONNECT is set to false. define('USE_PCONNECT', 'false'); // use persistent connections? http://us2.php.net/manual/en/features.pers...connections.php Checked those. Both set to False. I did find the same IP address in my "whos online" table and found 1 google bot 79 times. I'm betting this is the real culprit. I added a robots.txt file with disallow: storepath to the root. This should block all bots. Hope this helps someone else. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.