Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 02:05 pm EST
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
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
11
12
Quote
All times are EST. The time is now 02:05 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