MySQL Error # 4 = User '' has exceeded

Regular Joined: Sep 10, 2007 Posts: 53

Ok, last week I was given a tip to install RN 2.10.01 from my local machine before loading out. The site is fine but when I tried to install my RN to my online site, the first 5 steps was successful but after installing the NukeSentinelâ„¢ IP2Country Data load i got this error

Quote:

MySQL Error # 4 = User 'myaccount' has exceeded the 'max_updates' resource (current value: 60000).

So how I can update my sentinel if I cant do it in my installsql?
I read in the forum of my host...hyperphp-byethost, they say we need to split..but its a pain taking task..Any suggestions you can give to me?

Thanks in advance
unwired

Posted: Sun Sep 16, 2007 9:26 am

From installSQL.php"Note: The NukeSentinel(tm) IP2Country Data load is over 50,000 records. Since some slower servers may time out, I have also divided installation into 6 parts, should single-step installation fail."
Did you tried step 6a - 6f to load IP2Country ?

Posted: Sun Sep 16, 2007 7:06 pm

I do not use the bulk step 6 process. Even though using the divided step 6a-6f still I got the error.... Sad

registered · Posted: Sun Sep 16, 2007 7:46 pm

It's a database limit set up by your host. You'll have to do it it in increments, waiting for the limit to expire before doing the next section. Generally hosts set this on a per hour basis.

Posted: Sun Sep 16, 2007 9:19 pm

I even tried to import my working DB from my local machine to my site using phpmyadmin, but still I got errors...i am sure that this Db is working 100%...

registered · Posted: Mon Sep 17, 2007 6:20 am

yes, it is not your db, but the restriction that your host has placed on the number of SQL calls within a set time limit.

if you already have all the IPtocountry data in your local copy, possibly ask your host within a ticket if they would be willing to at least do the initial db load for you.

The only other options that you have are:

1. Get a host which does not have this limit - might want to check out RavenWebHosting

2. Create multiple users within mySQL (from your cpanel) and load in chunks by user because most of the limits (that I have read in these forums) sound like they are by user.

Just a word of caution though. If your site is very active, you could still run into this same issue even after your site is up and running. Therefore, you might want to consider number 1. above anyways.

Posted: Mon Sep 17, 2007 11:33 am

If you search on max resources you will find some other hacks to get around this limitation. I used to have it on an Ipowerweb server before I moved to Ravens hosting.

As M. says you can set up multiple users. On Ipowerweb you could also go in and reset any user and thus not have to wait the hour for the limit to expire. I believe the process is documented in the other posts. There may be similar workarounds for other hosts that limit you.

Worker Joined: Oct 05, 2003 Posts: 107 Location: Illinois

You have a limit on your database user to a set amount for SELECT queries, per hour, per user. Once you have used up your quota, you will begin to receive those types of errors until the end of the hour, and your quota is reset.

There is a trick to bypassing this, altho since it is your local setup you can change the query limit in yout php.ini file.

If the query limit setting does not work then your only option is to try this:

To compensate for this limitation, you can set up 2 additional users (for a total of 3 users), and spread out your queries among them. This will give you a total of 216K SELECT queries. To set this up, you must complete 5 steps.

1). BACKUP YOUR DATABASE FIRST BEFORE ATTEMPTING THIS!!!

2) Go into your server control panel and to mysql admin area. Add users to your database until you have 3, making sure that each user has the exact same password.

3) Open your config.php file. Find this section of code:

$dbhost = "localhost";
$dbuname = "host_username";
$dbpass = "usernamepassword";
$dbname = "host_dbname";

4) Add the following lines of code immediately before this section of code. In the quotes of each of these lines add the new usernames that you added to your database, Like.

$db_user_array[] = "host_username1"; //enter 1st user name
$db_user_array[] = "host_username2"; //enter 2nd user name
$db_user_array[] = "host_username3"; //enter 3rd user name

5) Now change the $dbuname = "host_username"; line to this

$dbuname = $db_user_array[ rand( 0, ( sizeof($db_user_array) -1 ) ) ];

Now what this does is causes it to cycle through the different users and allows each of these users to reach the limit.

Hope that helps.

Posted: Mon Sep 17, 2007 7:58 pm

sir montego, i am just using there free hosting services, I will not spend much because I will just donate this site for my campus club.

@loki
Thanks for that tip bud, I will save it and try it soon... Smile

Thanks everyone..

Posted: Tue Sep 18, 2007 5:38 am

unwired wrote:

i am just using there free hosting services

Just remember that you do "get what you pay for"... Wink

Posted: Tue Sep 18, 2007 5:58 am

@montego...

Yeah...too bad!!

Involved Joined: Apr 05, 2006 Posts: 263

i had the same limit ,

the way i get round it (my hosts sugestion) is to upload FTP the IP2country (6a-6f) individualy to your web server and using cpanel > use import to databse >DB-name> and give it twenty minutes or 5 minutes. then do 6b-6f. i found this an easier way of doing it, but thats just me. but at least it stops the time outs.