Please help with this error.

Sergeant Joined: Jun 26, 2003 Posts: 87

I am in touch with my host, as Raven knows, but I need some nuke stuff to back up my arguement. What does this error mean:

phpBB : Critical Error

Error doing DB query userdata row fetch : session_pagestar

DEBUG MODE

SQL Error : 1226 User 'gamersro_blith' has exceeded the 'max_questions' resource (current value: 10000)

Thanks!

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

I have submitted this to the MySQL discussion list as there is little information at MySQL. It appears that this is a well known error at IPowerWeb. A search at google has shown that other users are complaining about it too. Hopefully it's a setting that they can just change. It appears that the setting ER_USER_LIMIT_REACHED is the setting name. You might try asking them to put this value in their php.ini file in the [MySQL] section to see if that helps, or even in the mysql configuration file - this is just a suggestion to try!

mysql.ER_USER_LIMIT_REACHED = 100000

Sergeant Joined: Jun 26, 2003 Posts: 87

Thanks Raven. I have contacted them with this information. I hope it gets some results. What did you search under? The actual error message?

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

I think I searched under both the error number and the message. Also, the techies that monitor the discussion group have had nothing to say about this. Really strange ....

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Nikolai Chuvakhin <nc@iname.com> wrote:

This is a fairly new feature, available since MySQL 4.0.2.
Your host can change it by running a GRANT query (note that
these limits can be granted only via a global GRANT, that is,
a GRANT ON *.*):

GRANT USAGE
ON *.*
TO user IDENTIFIED BY 'password'
WITH MAX_QUERIES_PER_HOUR N1
MAX_UPDATES_PER_HOUR N2
MAX_CONNECTIONS_PER_HOUR N3;

If no limits are needed, N1, N2, and N3 should be set to zero.

Note that this query will grant the user usage of all databases,
so a REVOKE query may be needed consequently.

The alternative us to directly change the values of these three
fields:

max_questions
max_updates
max_connections

in mysql.user table and then FLUSH PRIVILEGES.

Cheers,
NC

From the comp.lang.php discussion board in response to my query. Now we know how it is set!

Sergeant Joined: Jun 26, 2003 Posts: 87

Very nice to know Raven! At this moment the have only upped my queries by 5000 for fear of my little site using up all the resources. So I believe your assumption that they are overselling resources is very correct. How anyone could run a business site on their servers is beyond me. I guess that is what dedicated severs are for, eh?