Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro
Author Message
zerokooll
Worker
Worker


Joined: Feb 01, 2006
Posts: 129

PostPosted: Wed Apr 26, 2006 7:20 am Reply with quote

ERROR! The exact error message that your MySQL server reported is User 'latin' has exceeded the 'max_updates' resource (current value: 20000).

That is the error message i get and i dont knwo what to do there...

_________________
Owner of Only registered users can see links on this board! Get registered or login! The best LaTiN site on the net! 
View user's profile Send private message
Guardian2003
Site Admin


Joined: Aug 28, 2003
Posts: 6793
Location: Ha Noi, Viet Nam

PostPosted: Wed Apr 26, 2006 8:34 am Reply with quote

If you could tell us what you were doing at the time, that might give us a much needed clue as to what the error is linked to Smile
 
View user's profile Send private message Send e-mail
evaders99
Former Moderator in Good Standing


Joined: Apr 30, 2004
Posts: 3221

PostPosted: Wed Apr 26, 2006 10:35 am Reply with quote

Unfortunately that means your host has caped the about of SQL statements you can do.
There is nothing to do but wait until it is reset... (I believe it is usually by the hour)

Given that phpNuke is a database intensive script, you really should consider getting a better host with no such restrictions

_________________
- Only registered users can see links on this board! Get registered or login! -

Need help? Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
fkelly
Former Moderator in Good Standing


Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Wed Apr 26, 2006 2:34 pm Reply with quote

My host caps the number of queries at 50000. Ipowerweb. It will probably drive me to Raven eventually (not that I need driving) but ... in the interim there are a couple of steps you can take.

First, if your host is like mine they may or may not get around to resetting the user in an hour. I've found it's hit or miss. But you can just go into your host admin function, (these instructions are for Ipowerweb but may work similarly for others), pick database setup and pick the user that you have connected to your database in the config.php file. Then edit that user and reset it. I've found that this resets the statistics and the user can get back into action right away.

There is also a solution to essentially create additional users and spread the workload out over them, thus alleviating the problem. It's in this thread and I've had good luck with it:

Only registered users can see links on this board! Get registered or login!
 
View user's profile Send private message Visit poster's website
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Wed Apr 26, 2006 5:35 pm Reply with quote

The 50k limit has brought me more customers than any other single factor. I appreciate all the other hosts that cap Smile
 
View user's profile Send private message
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's RavenNuke(tm) v2.02.02 Distro

View next topic
View previous 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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©