Introduction
At some point back, one of my site customers kept in touch with me griping about his site being down. I immediately checked and discovered the site down with the accompanying blunder. It was a Joomla site.
DB function failed with 1226 error
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’)
After a watchful investigation, I couldn't find the root or the reason for the issue yet in the wake of doing a bit of an examination I discovered the answer for the issue. In the event that your Web Hosting Company gives access to setup records to PHP and Mysql then you can build the "max_questions" esteem. Anyhow in the event that you are on a shared hosting (like a great many people) and don't have admittance to those records, here is a brisk fix:
1. Go to your site's control panel (e.g., Cpanel, Directadmin, vdeck, and so forth.) and go to the Database Section
2. Make 2 to 5 database clients (any username) with the same secret key as your database client. Illustration:
- In the event that your unique DB name for Joomla is mysite_joomla also DB client for Joomla is mysite_user
- Include the accompanying Users
- Username1: mysite_user1 Password: secret word
- Username2: mysite_user2 Password: secret word
- Username3: mysite_user3 Password: secret word
3. Presently Assign them to the database where your Joomla site is. Case:
- Dole out mysite_user1 to mysite_joomla and afterward mysite_user2 et cetera
4. Remember to provide for them the same database benefits as your first Joomla DB client (hero1).
5. Presently download your configuration.php from your web server utilizing any FTP customer programming (like Filezilla) and open it in any HTML/PHP proofreader to alter it.
6. Seek the accompanying Line of Code in the document
$mosconfig_user = 'mysite_user';
7. Remark out the line by including/ before it and include the accompanying lines beneath it:
$mosconfig_users = array("mysite_user", "mysite_user1″, "mysite_user2″);
$mosconfig_user = $mosconfig_users[array_rand($mosconfig_users)];
8. Presently Save the progressions and transfer the record once more to your server.
Your site ought to be up and running!! On the off chance that you confront any issue settling this error, leave a remark underneath and I will be glad to offer assista.