If your site crashed due to this error:
Code: Select all
DB function failed with error number 1226
User 'your_user_name_here' has exceeded the 'max_questions' resource (current value: 50000) SQL=SELECT session_id FROM mos_session WHERE session_id=MD5('1aa637c8e7d13c9be419d455cd6db64c')
SQL =
SELECT session_id FROM mos_session WHERE session_id=MD5('1aa637c8e7d13c9be419d455cd6db64c')
- Go to your account's control panel (e.g., CPanel, DirectAdmin, vDeck, etc.). Access the MySQL feature and create 2-5 database users with the same password as your db user for Mambo/Joomla. Assign them to the database where your Mambo/Joomla site is.
Example:
DB name for Mambo/Joomla - myjoomla_cms
DB user for Mambo/Joomla - myjoomla_user
Create additional users for the database:
2nd DB user for Mambo/Joomla - myjoomla_user1
3rd DB user for Mambo/Joomla - myjoomla_user2
Don't forget to give them the same database privileges as your first Joomla DB user. - Then download your configuration.php from the server and open it in any HTML/PHP editor to modify it.
Look for this line:
Code: Select all
$mosConfig_user = 'myjoomla_user';
Code: Select all
$mosConfig_users = array("myjoomla_user", "myjoomla_user1", "myjoomla_user2");
$mosConfig_user = $mosConfig_users[array_rand($mosConfig_users)];
- Explanation: The first line defines the users that can access your database. The second line randomly selects a user from the list on the first line.
Save the changes and re-upload the file to your server.