Sandbox

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:

$mosConfig_user = 'myjoomla_user';

$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.

I HAVE FOUND THE SOURCE OF THIS PROBLEM.

When I disable Joomla Core SEF, everything works perfectly. PERFECTLY.

chanman wrote:EDIT!

problem was NOT solved by the above.


I HAVE FOUND THE SOURCE OF THIS PROBLEM.

When I disable Joomla Core SEF, everything works perfectly. PERFECTLY.

heltsonika wrote:

chanman wrote:EDIT!

problem was NOT solved by the above.


I HAVE FOUND THE SOURCE OF THIS PROBLEM.

When I disable Joomla Core SEF, everything works perfectly. PERFECTLY.

That doesn't work for me...

Does anyone know the cause of this problem yet?

lcdude wrote:To disable the CORE SEO login as admin to the backend. On the top menu all the way to the left choose "SITE". When it comes up SEO is on your far right click there to disable. You should also disable stats if your having this problem.

Do a Search for "error 1226" and follow the threads there are some good tips for solving this problem.

What I did was enable debug (Same pace UNDER SITE) and found I had WAY to many inquires to the data base and most of them were Artio SEF. I was advised to switch to OPENSEF which I did.

You should also trim down your site and get rid of any modules, Components, Mambots etc that your not using or could live witout. We had over 250 inquires and now are down to 63. We no longer get the "ERROR 1226".

Also check the JOOMLA Performance section of the forum for advice.



This was an difficult task for us and two well over a week to fix. Take your time and listen the ones who know...joomla.

Good Luck

maverick25 wrote:FOR SHARED ENVIRONMENTS ONLY

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')

and you are currently hosted on a shared environment (i.e., you are not allowed to edit configuration files for PHP and MySQL or your host provider doesn't want to increase the max_questions value), here is a quick fix:

• 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';

Comment out the line above and add these lines below it:

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.