Problem when logging into the Gento backend

Asked

Viewed 153 times

0

I made a mirror copy of a website in Malta. The site runs cute on front-end, loads fast and all, but when I try to access the admin, besides taking a long time to the login (2.3 minutes), when I do the login, it returns this error:

SQLSTATE[HY000]: General error: 2006 MySQL server has gone away

Trace:
#0 /home/floraweb/public_html/lib/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/floraweb/public_html/lib/Zend/Db/Adapter/Abstract.php(468): Zend_Db_Statement->execute(Array)
#2 /home/floraweb/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `admin_u...', Array)
#3 /home/floraweb/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(333): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `admin_u...', Array)
#4 /home/floraweb/public_html/lib/Zend/Db/Adapter/Abstract.php(725): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#5 /home/floraweb/public_html/app/code/core/Mage/Core/Model/Mysql4/Abstract.php(352): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select))
#6 /home/floraweb/public_html/app/code/core/Mage/Admin/Model/Mysql4/User.php(141): Mage_Core_Model_Mysql4_Abstract->load(Object(Mage_Admin_Model_User), '1', NULL)
#7 /home/floraweb/public_html/app/code/core/Mage/Core/Model/Abstract.php(225): Mage_Admin_Model_Mysql4_User->load(Object(Mage_Admin_Model_User), '1', NULL)
#8 /home/floraweb/public_html/app/code/core/Mage/Admin/Model/User.php(281): Mage_Core_Model_Abstract->load('1')
#9 /home/floraweb/public_html/app/code/core/Mage/Admin/Model/Observer.php(48): Mage_Admin_Model_User->reload()
#10 /home/floraweb/public_html/app/code/core/Mage/Core/Model/App.php(1228): Mage_Admin_Model_Observer->actionPreDispatchAdmin(Object(Varien_Event_Observer))
#11 /home/floraweb/public_html/app/code/core/Mage/Core/Model/App.php(1209): Mage_Core_Model_App->_callObserverMethod(Object(Mage_Admin_Model_Observer), 'actionPreDispat...', Object(Varien_Event_Observer))
#12 /home/floraweb/public_html/app/Mage.php(416): Mage_Core_Model_App->dispatchEvent('controller_acti...', Array)
#13 /home/floraweb/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(497): Mage::dispatchEvent('controller_acti...', Array)
#14 /home/floraweb/public_html/app/code/core/Mage/Adminhtml/Controller/Action.php(152): Mage_Core_Controller_Varien_Action->preDispatch()
#15 /home/floraweb/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(407): Mage_Adminhtml_Controller_Action->preDispatch()
#16 /home/floraweb/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#17 /home/floraweb/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(177): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#18 /home/floraweb/public_html/app/code/core/Mage/Core/Model/App.php(304): Mage_Core_Controller_Varien_Front->dispatch()
#19 /home/floraweb/public_html/app/Mage.php(596): Mage_Core_Model_App->run(Array)
#20 /home/floraweb/public_html/index.php(83): Mage::run('', 'store')
#21 {main}

DNS is not configured because I am still developing, I am accessing through IP and have updated this information in the fields "web/Unsecure/base_url" and "web/Secure/base_url". The site was working pretty, even the panel admin was coming in. This problem appeared from one day to the next.

mysql magento

  • You are facing problems with your database. Either it is unstable or your application is consuming more resources than it can offer and your hosting provider is causing this error to get your attention. Also check your connection data in the/etc/local.xml app ...

  • 1

    Friend, first of all, thank you for answering. Yes, it’s a Mysql error, but I don’t think the problem is with the database, otherwise the front-end tbm would be giving Zica, the local.xml document is properly configured... I believe the problem is in the same resources, something is making the query last longer than the time allowed to access the backend.

2 answers

0

"Mysql server has Gone away" means that the SQL load time took longer than normal and was terminated, this error occurs when Pdo_mysql or mcrypt were not installed on your server that is running Mysql.

Review the minimum settings and recommended extensions to use Magento, make sure that such extensions are installed on your server:

PDO_MySQL
simplexml
mcrypt
hash
GD
DOM
iconv
curl
SOAP (PARA Webservices API)

After correcting such issues, remove the/var/cache and localdatabase folder from your database and refresh the page to try again.

0

I’ve encountered these problems in some stores, You should also check the amount of connections allowed (increase) in the bank along with the connection timeout (increase the waiting time).

Browser other questions tagged mysql magento

You are not signed in. Login or sign up in order to post.