ERROR! The exact error message that your MySQL server report

Worker Joined: Feb 01, 2006 Posts: 129

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...

Posted: Wed Apr 26, 2006 8:34 am

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

registered · Posted: Wed Apr 26, 2006 10:35 am

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

Posted: Wed Apr 26, 2006 2:34 pm

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!

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

The 50k limit has brought me more customers than any other single factor. I appreciate all the other hosts that cap Smile