Welcome to Geeklog Saturday, September 26 2020 @ 02:44 pm EDT

Geeklog Forums

Site Shutdown - SQL or Comment Spam?


tluskie

Anonymous
confused
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

Is this from being slammed with comment spam? I says I exceeded the max questions.

What should I do? HELP!
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
Location:Stuttgart, Germany
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

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
 Quote

tluskie

Anonymous
Thanks Dirk. I contacted my host. All they had to do was reset the limit, and now it is all better.

Thanks!
 Quote

All times are EDT. The time is now 02:44 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content