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

NukeCops  
•  Home •  Downloads •  Gallery •  Your Account •  Forums • 
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' [ ]
 Forum FAQ  •  Search  •   •  Memberlist  •  Usergroups   •  Register  •  Profile •    •  Log in to check your private messages  •  Log in

 
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
Author Message
cakepro
Corporal
Corporal


Joined: Apr 11, 2003
Posts: 55


PostPosted: Fri Oct 01, 2004 8:22 am Reply with quoteBack to top

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
Find all posts by cakeproView user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Fri Oct 01, 2004 9:24 am Reply with quoteBack to top

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.

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
cakepro
Corporal
Corporal


Joined: Apr 11, 2003
Posts: 55


PostPosted: Fri Oct 01, 2004 1:48 pm Reply with quoteBack to top

That was a completely unhelpful post. Rolling Eyes

Chatserv, where are you??
Find all posts by cakeproView user's profileSend private message
desa80
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 23


PostPosted: Tue Oct 05, 2004 11:01 am Reply with quoteBack to top

why nobody can help?!
Find all posts by desa80View user's profileSend private message
Evaders99
Site Admin
Site Admin


Joined: Aug 17, 2003
Posts: 12482


PostPosted: Tue Oct 05, 2004 5:50 pm Reply with quoteBack to top

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

_________________
Helping those that help themselves
Read FIRST or DIE!

"Fighting is terrible, but not as terrible as losing the will to fight."
Star Wars Rebellion Network - Need Help? Evaders Squadron Coding
Find all posts by Evaders99View user's profileSend private messageVisit poster's websiteAIM Address
desa80
Nuke Soldier
Nuke Soldier


Joined: Oct 17, 2003
Posts: 23


PostPosted: Wed Oct 06, 2004 10:19 am Reply with quoteBack to top

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!
Find all posts by desa80View user's profileSend private message
djmorbius
Nuke Cadet
Nuke Cadet


Joined: Oct 21, 2004
Posts: 1


PostPosted: Wed Oct 20, 2004 11:03 pm Reply with quoteBack to top

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.
Find all posts by djmorbiusView user's profileSend private message
lmneditor
Nuke Cadet
Nuke Cadet


Joined: Aug 24, 2007
Posts: 1


PostPosted: Fri Aug 24, 2007 7:20 am Reply with quoteBack to top

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.
Find all posts by lmneditorView user's profileSend private message
Display posts from previous:      
Post new topic  Reply to topicprinter-friendly view
View previous topic Log in to check your private messages View next topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2005 phpBB Group

Ported by Nuke Cops © 2003 www.nukecops.com
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::
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.230 Seconds - 146 pages served in past 5 minutes. Nuke Cops Founded by Paul Laudanski (Zhen-Xjell)
:: FI Theme :: PHP-Nuke theme by coldblooded (www.nukemods.com) ::