Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 09:04 am EDT

Geeklog Forums

Bad Behavior and the dreaded SQL Error.


Status: offline

Don

Forum User
Full Member
Registered: 06/09/04
Posts: 153
My site has been getting random SQL Errors for a couple of months, in which the number of SQL queries per hour limit (50K) is exceeded, which causes GL to shut down. I've been referring to the error log in my hosting account admin to look for the error, and was never able to find anything.

Tonight I took a look in the 'logs' directory on the server and noticed this error, over and over and over again:



Wed Apr 26 07:56:34 2006 - 1226: User '*****' has exceeded the 'max_questions' resource (current value: 50000). SQL in question: CREATE TABLE IF NOT EXISTS `gl_bad_behavior_log` (
`id` int(11) NOT NULL auto_increment,
`ip` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`request_method` text NOT NULL,
`http_host` text,
`request_uri` text NOT NULL,
`server_protocol` text NOT NULL,
`http_referer` text,
`http_user_agent` text,
`http_headers` text NOT NULL,
`request_entity` text NOT NULL,
`denied_reason` text NOT NULL,
`http_response` int(3) NOT NULL,
PRIMARY KEY (`id`) );


It looks as though every time Bad Behavior kicks in, it tries to add a table to the GL database which is obviously already there.

Or maybe I'm reading it wrong. I'm not sure.

Is there any way to sidestep this error in Bad Behavior? I'd love to be able to stop my site from randomly shutting down.

Any help, as always, will be appreciated.

- D
 Quote

All times are EDT. The time is now 09:04 am.

  • 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