Today, all of a sudden, my site shut down with an SQL error. I didnt even work on it at all today. It said to check the error log, so I did. There are multiple entries like this:
_BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:03:47 2006 - Block template for the footer of _msg_block is: blockfooter.thtml
Fri May 12 16:05:25 2006 - 1226: User 'jtluskco_comment' has exceeded the 'max_questions' resource (current value: 50000). SQL in question: SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
Fri May 12 16:05:25 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:05:25 2006 - Block template for the header of _msg_block is: blockheader.thtml
Fri May 12 16:05:25 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:05:25 2006 - Block template for the footer of _msg_block is: blockfooter.thtml
Fri May 12 16:05:30 2006 - 1226: User 'jtluskco_comment' has exceeded the 'max_questions' resource (current value: 50000). SQL in question: SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
Fri May 12 16:05:30 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:05:30 2006 - Block template for the header of _msg_block is: blockheader.thtml
Fri May 12 16:05:30 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:05:30 2006 - Block template for the footer of _msg_block is: blockfooter.thtml
Fri May 12 16:05:45 2006 - 1226: User 'jtluskco_comment' has exceeded the 'max_questions' resource (current value: 50000). SQL in question: SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
Fri May 12 16:05:45 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:05:45 2006 - Block template for the header of _msg_block is: blockheader.thtml
Fri May 12 16:05:45 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:05:45 2006 - Block template for the footer of _msg_block is: blockfooter.thtml
Fri May 12 16:05:58 2006 - 1226: User 'jtluskco_comment' has exceeded the 'max_questions' resource (current value: 50000). SQL in question: SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
Fri May 12 16:05:58 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:05:58 2006 - Block template for the header of _msg_block is: blockheader.thtml
Fri May 12 16:05:58 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:05:58 2006 - Block template for the footer of _msg_block is: blockfooter.thtml
Fri May 12 16:07:18 2006 - 1226: User 'jtluskco_comment' has exceeded the 'max_questions' resource (current value: 50000). SQL in question: SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
Fri May 12 16:07:18 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:07:18 2006 - Block template for the header of _msg_block is: blockheader.thtml
Fri May 12 16:07:18 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:07:18 2006 - Block template for the footer of _msg_block is: blockfooter.thtml
Fri May 12 16:08:06 2006 - 1226: User 'jtluskco_comment' has exceeded the 'max_questions' resource (current value: 50000). SQL in question: SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
Fri May 12 16:08:06 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:08:06 2006 - Block template for the header of _msg_block is: blockheader.thtml
Fri May 12 16:08:06 2006 - _BLOCK_TEMPLATE[_msg_block] =
Fri May 12 16:08:06 2006 - Block template for the footer of _msg_block is: blockfooter.thtml
My site is
jtlusk.com[*1]
Is this from being slammed with comment spam? I says I exceeded the max questions.
What should I do? HELP!
[QUOTE BY= tluskie] Fri May 12 16:05:25 2006 - 1226: User 'jtluskco_comment' has exceeded the 'max_questions' resource (current value: 50000). SQL in question: SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1[/QUOTE]
This is from a restriction of the number of requests per a certain timeframe that your hosting service imposes on you - but you probably know that. The message indicates you have traffic on your site - each visitor causes a couple of SQL requests, so the more visitors, the more SQL requests.
As for the cause of the traffic, I can only speculate. It could be spam, it could be something else (search engine bots sometimes cause a lot of traffic, too). Check your webserver logs and Geeklog's spamx.log for more information.
What can you do? Ask your hosting service to raise that limit or find a hosting service that doesn't impose such a limit in the first place ...
bye, Dirk
Thanks Dirk. I contacted my host. All they had to do was reset the limit, and now it is all better.
Thanks!