You are missing our premiere tool bar navigation system! Register and use it for FREE!

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 

Author: Evaders99PostPosted: Fri Oct 01, 2004 9:24 am    Post subject: Re: SQL Error 1226 User has exceeded the 'max_resoureces'

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.

Author: cakeproPostPosted: Fri Oct 01, 2004 1:48 pm    Post subject: Re: SQL Error 1226 User has exceeded the 'max_resoureces'

That was a completely unhelpful post. Rolling Eyes

Chatserv, where are you??

Author: desa80PostPosted: Tue Oct 05, 2004 11:01 am    Post subject: Re: SQL Error 1226 User has exceeded the 'max_resoureces'

why nobody can help?!

Author: Evaders99PostPosted: Tue Oct 05, 2004 5:50 pm    Post subject: Re: SQL Error 1226 User has exceeded the 'max_resoureces'

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

Author: desa80PostPosted: Wed Oct 06, 2004 10:19 am    Post subject: Re: SQL Error 1226 User has exceeded the 'max_resoureces'

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!

Author: djmorbiusPostPosted: Wed Oct 20, 2004 11:03 pm    Post subject: Re: SQL Error 1226 User has exceeded the 'max_resoureces'

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.

Author: lmneditorPostPosted: Fri Aug 24, 2007 7:20 am    Post subject: #1226 Error MySQL

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.



Nuke Cops -> Bug Reports

All times are GMT - 8 Hours

Page 1 of 1

Powered by phpBB © 2001,2002 phpBB Group
Readme First
- Readme First! -

Read and follow the rules, otherwise your posts will be closed
Modules
· Home
· FAQ
· Buy a Theme
· Advertising
· AvantGo
· Bookmarks
· Columbia
· Community
· Donations
· Downloads
· Feedback
· Forums
· PHP-Nuke HOWTO
· Private Messages
· Search
· Statistics
· Stories Archive
· Submit News
· Surveys
· Theme Gallery
· Top
· Topics
· Your Account
Who's Online
There are currently, 180 guest(s) and 0 member(s) that are online.

You are Anonymous user. You can register for free by clicking here
Nuke Cops :: View topic - SQL Error 1226 User has exceeded the 'max_resoureces' SQL Error 1226 User has exceeded the 'max_resoureces'

Nuke Cops -> Bug Reports

Author: cakepro PostPosted: Fri Oct 01, 2004 8:22 am    Post subject: SQL Error 1226 User has exceeded the 'max_resoureces'

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
Powered by TOGETHER TEAM srl ITALY http://www.togetherteam.it - DONDELEO E-COMMERCE http://www.DonDeLeo.com - TUTTISU E-COMMERCE http://www.tuttisu.it
Web site engine's code is Copyright © 2002 by PHP-Nuke. All Rights Reserved. PHP-Nuke is Free Software released under the GNU/GPL license.
Page Generation: 0.208 Seconds - 152 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
added by Evaders - DO NOT REMOVE
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::