SQLSTATE[42000] [1203] User foiindus_liveusr already has more than 'max_user_connections' active connections
Trace:
#0 /home3/foiindus/public_html/true/lib/Zend/Db/Adapter/Pdo/Mysql.php(111): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /home3/foiindus/public_html/true/lib/Varien/Db/Adapter/Pdo/Mysql.php(396): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /home3/foiindus/public_html/true/lib/Zend/Db/Adapter/Abstract.php(460): Varien_Db_Adapter_Pdo_Mysql->_connect()
#3 /home3/foiindus/public_html/true/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SET NAMES utf8', Array)
#4 /home3/foiindus/public_html/true/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SET NAMES utf8', Array)
#5 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Resource.php(179): Varien_Db_Adapter_Pdo_Mysql->query('SET NAMES utf8')
#6 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Resource.php(110): Mage_Core_Model_Resource->_newConnection('pdo_mysql', Array)
#7 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(320): Mage_Core_Model_Resource->getConnection('core_write')
#8 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(350): Mage_Core_Model_Resource_Db_Abstract->_getConnection('write')
#9 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(335): Mage_Core_Model_Resource_Db_Abstract->_getWriteAdapter()
#10 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(360): Mage_Core_Model_Resource_Db_Abstract->_getReadAdapter()
#11 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Resource/Db/Collection/Abstract.php(134): Mage_Core_Model_Resource_Db_Abstract->getReadConnection()
#12 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Config.php(1354): Mage_Core_Model_Resource_Db_Collection_Abstract->__construct(Object(Mage_Core_Model_Resource_Website))
#13 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Config.php(1386): Mage_Core_Model_Config->getModelInstance('core_resource/w...', Object(Mage_Core_Model_Resource_Website))
#14 /home3/foiindus/public_html/true/app/Mage.php(491): Mage_Core_Model_Config->getResourceModelInstance('core/website_co...', Object(Mage_Core_Model_Resource_Website))
#15 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Abstract.php(208): Mage::getResourceModel('core/website_co...', Object(Mage_Core_Model_Resource_Website))
#16 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/Abstract.php(213): Mage_Core_Model_Abstract->getResourceCollection()
#17 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/App.php(619): Mage_Core_Model_Abstract->getCollection()
#18 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/App.php(477): Mage_Core_Model_App->_initStores()
#19 /home3/foiindus/public_html/true/app/code/core/Mage/Core/Model/App.php(360): Mage_Core_Model_App->_initCurrentStore('', 'store')
#20 /home3/foiindus/public_html/true/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#21 /home3/foiindus/public_html/true/index.php(85): Mage::run('', 'store')
#22 {main}
please share quick solutions
Hello @john_mike,
In your php ini file you can increase MAX_USER_CONNECTIONS and MAX_CONNECTIONS
Or you can try to use this SQL command:
GRANT ALL * TO 'root'@'localhost' WITH MAX_USER_CONNECTIONS 1000;
--
If issue is solved, Click "Kudos" & "Accept as Solution"
Hello @john_mike,
Have you merge js and css on store? Please revert back and check it. If it's works then merge it.
--
If it helps to you resolve issue then Click "Kudos" & "Accept as Solution"
we restore our whole website to an old backup