custompony Posted January 7, 2007 Share Posted January 7, 2007 I received an order at 6:44pm and then by 9:54pm (when I tried to enter both as a customer and as an admin) I received this error: 1226 - User 'custompo_p_os1' has exceeded the 'max_questions' resource (current value: 50000) select value from sessions where sesskey = 'a651f3807e2e1dfb39a2b107c9a1ce7b' and expiry > '1168142264' [TEP STOP] What does this mean? How do I fix it? Link to comment Share on other sites More sharing options...
jpweber Posted January 7, 2007 Share Posted January 7, 2007 I received an order at 6:44pm and then by 9:54pm (when I tried to enter both as a customer and as an admin) I received this error: 1226 - User 'custompo_p_os1' has exceeded the 'max_questions' resource (current value: 50000) select value from sessions where sesskey = 'a651f3807e2e1dfb39a2b107c9a1ce7b' and expiry > '1168142264' [TEP STOP] What does this mean? How do I fix it? Shared hosting requires that the web hosting company keep their users from taking up too many resources at the expense of other users. One way to do this is to limit the number of mysql queries that can be in progress at any given time. This error message means that you've exceeded your allocation for the next several minutes. When you see this in Admin, your customers will see it too on the catalog side. Talk to your host about it. A couple of tips: 1) Make sure that your configure.php files have persistent connections set to off. This way, each time the php script finishes executing, the connection will be terminated (supposed to, anyway). 2) page cache contribution. page optimization thread in tips & tricks. turn off category counts in the osC config in your admin tool. Jason Simple 1-2-3 Intructions on how to get, install and configure SSL The Google Sandbox explained Simple to follow instructions on how to change the look of your OSC How To Make A Horrible OSC Website my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ... Link to comment Share on other sites More sharing options...
custompony Posted January 7, 2007 Author Share Posted January 7, 2007 Shared hosting requires that the web hosting company keep their users from taking up too many resources at the expense of other users. One way to do this is to limit the number of mysql queries that can be in progress at any given time. This error message means that you've exceeded your allocation for the next several minutes. When you see this in Admin, your customers will see it too on the catalog side. Talk to your host about it. A couple of tips: 1) Make sure that your configure.php files have persistent connections set to off. This way, each time the php script finishes executing, the connection will be terminated (supposed to, anyway). 2) page cache contribution. page optimization thread in tips & tricks. turn off category counts in the osC config in your admin tool. Thanks Jason! It was still down this morning so I contacted my host and they were able to fix it. 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.