Quota of SQL Statements

adaykin · Regular Joined: Sep 26, 2007 Posts: 60

Well now that I have gotten over MySQL error # 2 I have another one...Step 1, 2, 3, 4, and 5 all go ok, but when I try and load the IP2Country data I get an error saying:

MySQL Error # 4 = User 'xxx' has exceeded the 'max_questions' resource (current value: 50000)

I saw a workaround where you create an array of users, but has anyone successfully implemented this?

jakec · Posted: Tue Nov 06, 2007 2:48 pm

Are you trying to install the tables at once, or using the individual steps?

adaykin · Regular Joined: Sep 26, 2007 Posts: 60

I am able to do steps 1, 2, 3, 4, and 5. For step 6 I can get from 6a to 6d. After I try to load 6e I get the error message.

If I try and leave the page alone for a while and then come back I have to start at square 1.

montego · Posted: Sat Nov 10, 2007 2:20 pm

adaykin wrote:

If I try and leave the page alone for a while and then come back I have to start at square 1.

No, you should only have to pick up with the step that failed and subsequent ones...

adaykin · Regular Joined: Sep 26, 2007 Posts: 60

I changed the dbuname to an array, and now the loads are a lot faster, and the setup worked.