HELP! MYSQL problem

[Predator]

My site was working with OsCmmerce this afternoon, now all my customers get this:



1226 - User 'teamert' has exceeded the 'max_questions' resource (current value: 36000)

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

[TEP STOP]


What do I do??????

[alphadesk]

Predator1226 - User 'teamert' has exceeded the 'max_questions' resource (current value: 36000)You exceeded the mysql limits. You can have 3 mysql users and rotate them in theory adding a little code to your configure.php

This should give you the max limits allowed here.

// define our database connection
define('DB_SERVER', 'mysqlserver.powweb.com'); // eg, localhost - should not be empty for productive servers

//thanks halfabee
$auser = array( 'user1','user2','user3' ); //change the bold to your user name all with same passord
$user = $auser[ rand(0,2) ];

define('DB_SERVER_USERNAME', '$user');
define('DB_SERVER_PASSWORD', 'password');
define('DB_DATABASE', 'DB_name');
define('USE_PCONNECT', 'false'); // use persisstent connections?
define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

[tbonekkt]

Sounds like you've exceeded your MySQL limits...

[Predator]

Thanks, I'll pop the code in and hope for the best :) Seems to have cleared for now, but not looking forward to another.