Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Big problem: "user exceeded the 'max_questions' resource"
Hi, I built a Textpattern powered blog for my friend at http://www.insideowl.com. It’s been running for months without problems, but today my friend went to the page – http://www.insideowl.com – to discover a whole mess of tag error messages related to “exceeded the ‘max_questions’ resource”. For example,
tag_error <txp:article form=“default” limit=“10” /> -> Textpattern Warning: User ‘insideow’ has exceeded the ‘max_questions’ resource (current value: 50000)
select count(*) from textpattern where 1 and Status = 4 and Posted <= now()and Section != ‘about’ and Section != ‘profile’ and Section != ‘owl’ and Section != ‘friends’ and Section != ‘orbit’ and Section != ‘contact’ and Section != ‘archive’ on line 84
I haven’t changed anything in the installation or upgraded to 4.0.5, this seemed to come out of nowhere. Is this a server problem, or a problem with the MySQL database somewhere?
Thanks for any suggestions!
Alex
Last edited by The Safety Inspector (2007-07-14 18:06:23)
Offline
Re: Big problem: "user exceeded the 'max_questions' resource"
In Preferences, is the production status site to live?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Big problem: "user exceeded the 'max_questions' resource"
I can’t even log into the Textpattern admin. Very strange. Error messages:
Warning: User ‘insideow’ has exceeded the ‘max_questions’ resource (current value: 50000) describe `textpattern` in /home/insideow/public_html/textpattern/lib/txplib_db.php on line 84
Warning: Cannot modify header information – headers already sent by (output started at /home/insideow/public_html/textpattern/lib/txplib_db.php:84) in /home/insideow/public_html/textpattern/lib/txplib_misc.php on line 1494
Warning: User ‘insideow’ has exceeded the ‘max_questions’ resource (current value: 50000) select user_html from txp_page where name=‘error_503’ in /home/insideow/public_html/textpattern/lib/txplib_db.php on line 84
Offline
Re: Big problem: "user exceeded the 'max_questions' resource"
If your webhost is iPowerweb, and I think it is, then the problem is that they limit the number of allowed database queries to 50.000 (per hour) and refuse to increase that limit. You’ll either have to reduce the number of queries in your website design, make the website less interesting (so you get less visitors), use a round-robin system that lets multiple DB users access the database (thus artificially increasing the query limit), use a caching hack (like asy_jpcache) or move to a different webhost.
Offline
#5 2007-07-15 22:56:52
- Mary
- Sock Enthusiast
- Registered: 2004-06-27
- Posts: 6,236
Re: Big problem: "user exceeded the 'max_questions' resource"
Offline