big problem Bad QA3: exceeded the 'max_questions' resource

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

I have big problem before 2 days my site began to show this error message "Bad QA3:User 'mydomaincom' has exceeded the 'max_questions' resource (current value: 90000)" and no content from my php nuke 6.5. When i go to phpmyadmin at first it doesn't allow me to do anything because it is showing the same error but i optimize the db and it works, but after some time the same thing happen ERROR. I don't know from where the hell 90 000 mysql quires will come from. Do you have any suggestion? Please help!

ps. I have sentinel 2.0/1 installed but no banned ip, i just don't know where this quires come from, and before some months i hade protector installed but i removed it because it didn't allow my FriendFinder to work, is it possible something like this to happen?

Please help!
Bad QA3:User 'mydomaincom' has exceeded the 'max_questions' resource (current value: 90000)

Sergeant Joined: Aug 26, 2004 Posts: 75

Let's say your website generates 200+ queries on each page visit.

450 page visits and you get locked out

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

Quote:

Let's say your website generates 200+ queries on each page visit.

450 page visits and you get locked out

you mean thats normal, I have about 1700 visitors a day, and before this never happened to my site and the number of the visitors was the same, do you have any suggestion please![/quote]

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

I optimized my db so the site run ok for a while and I turned the debuggin mode on and this messages showed:
at the top: "SQL query: select bposition from nuke_blocks where active='1' ORDER BY bposition ASC"

at the top of left blocks: "SQL query: select bid, bkey, title, content, url, blockfile, view from nuke_blocks where bposition='l' AND active='1' ORDER BY weight ASC"

at top of right blocks: "SQL query: select bid, bkey, title, content, url, blockfile, view from nuke_blocks where bposition='r' AND active='1' ORDER BY weight ASC"

at the top of center blocks(above the friendfinder random members block):
"SQL query: SELECT COUNT(id) AS total FROM nuke_user_profile1 where photo='1' and approved='1'
SQL query: SELECT ffusername, photopath FROM nuke_user_profile1 where photo='1' and approved='1' LIMIT 643, 5
SQL query: SELECT user_id from nuke_users where username='lida'
SQL query: SELECT user_id from nuke_users where username='zdraveca'
SQL query: SELECT user_id from nuke_users where username='nikki38'
SQL query: SELECT user_id from nuke_users where username='diadora78'
SQL query: SELECT user_id from nuke_users where username='georgi_fil'"

at the bottom of center blocks:
"SQL query: select bid, bkey, title, content, url, blockfile, view from nuke_blocks where bposition='c' AND active='1' ORDER BY weight ASC"

I use PROXIMA theme is it possible the theme to be some reason?
help please!

Sergeant Joined: Aug 26, 2004 Posts: 75

I doubt that are all queries the system runs so you probably use 2 database connections.

Check if this file works for you:
http://cvs.sourceforge.net/viewcvs.py/phpnuke65-cpg/cpg82b/html/includes/sql_layer.php?rev=1.1&view=markup

Must be uploaded to: includes/sql_layer.php

Nuke Soldier Joined: Nov 16, 2003 Posts: 10

Well i had this problem with ipowerweb... activated permanent connections and still had this problem... so i found a solution.

Im not a good coder but i discovered that if i created another account that directed to the same database then that account will start with 0 queries.

With that on mind i modified the includes/sql_layer.php so that if it encounters any database acces error it would instantly changed the user accesing the database.

this is the code : (sorry but its not well depured, i know many changes wil help making it better Wink

)

Code:

Ok now you need to modify your config.php so that it will load the user stored in cfg/config2.php

Code:

require_once("cfg/config2.php"); // include the file config2.php so that the username can be changed.

$dbhost = "localhost";
$dbpass = "username";
$dbname = "databasename";
$prefix = "nuke";
$user_prefix = "nuke";
$dbtype = "MySQL";
$sitekey = "SddddddddddddddddddddddddddddddddddddddddddddddfDS+e9";
$gfx_chk = 7;
$subscription_url = "";

Note that we deleted the "$dbuname" variable

now you will have to create a directory called "cfg" in root.
and inside that directory you will have to put the following files:

config2.php
incrementa2.php
incrementa3.php
incrementa4.php
incrementa5.php
incrementa6.php
incrementa7.php

NO incrementa1 is not missing... its config2... when the user in config2 reaches 50000queries then it will be renamed to incrementa1.php... and then incrementa2.php will be renamed to config2.php

each of the past files will contain the following code.

Code:

<?php
$dbuname = "database user";
?>

Remember to create diferent users for the same database (7) and put a diferent user in each file... keep the password the same in all users so it will be easier to change them.

It worked for me..
Stills needs lots of work... hope it works for you.