SQL Error 1226 User has exceeded the 'max_resoureces'

Corporal Joined: Apr 11, 2003 Posts: 55

Help! I'm the administrator of my Nuke 6.5, phpBB 2.0.6 site and cannot post. I get the following error message:

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1226 User 'marshree_admin' has exceeded the 'max_questions' resource (current value: 50000)

How can I fix this?

Thanks!
Sherri

Site Admin Joined: Aug 17, 2003 Posts: 12482

Looks like you need to fix something in your MySQL configuration - 'max_questions'

I would say get a better host. phpNuke is still runs heavily on SQL queries, even with the speed tweaks available on the forums here.

Corporal Joined: Apr 11, 2003 Posts: 55

That was a completely unhelpful post. Rolling Eyes

Chatserv, where are you??

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

why nobody can help?!

Site Admin Joined: Aug 17, 2003 Posts: 12482

Well I tried. Can't please everyone... Smile

http://www.portedmods.com/ftopict-2582.html
Again seems like a server issue and not a coding issue, but as suggested, a possible solution with persistent connections:

http://nukecops.com/postp141561.html&highlight=persistent+database#141561

Nuke Soldier Joined: Oct 17, 2003 Posts: 23

I optimized my db so the site run ok and I turn 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!

Nuke Cadet Joined: Oct 21, 2004 Posts: 1

Howdy All,

I don't know if you have resolved this.
This happened to me on my SQL server... Partially because I decided that setting the max requests would be fun... Heh.

SO anyhow, so fix it, I restarted my SQL server and then set the max_* fields to 0

Hope that helps... If it doesn't... Then this was useless.

Nuke Cadet Joined: Aug 24, 2007 Posts: 1

While the posts on this thread are old, the problem isn't, so here's a solution to the "max_questions" failure. In your MySQL Admin section (vDECK, CP, etc), create one or two new users for MYSQL. As I use a PHP Class to make connections, I just wrote a quick piece of code to connect to a different user, depending on the day, like this:

$user=((date("j")%2)>0 ? "user1" : "user2");
$pw=((date("j")%2)>0 ? "pw1" : "pw2");

Which loads the connection

$mainconnect =@mysql_connect("localhost", $user, $pw) or die('Could not connect to the database because: '. mysql_error());

This spreads to number of questions per user over the two. If two users aren't enough, add more and spread it further, perhaps a different user each day of the week.