magento - SQLSTATE[HY000]: General error: 2006 MySQL server has gone away - What to do? -
here , don't know do....
there has been error processing request sqlstate[hy000]: general error: 2006 mysql server has gone away trace: #0 /home/autobadges/public_html/stangcenter.com/lib/zend/db/statement.php(300): zend_db_statement_pdo->_execute(array) #1 /home/autobadges/public_html/stangcenter.com/lib/zend/db/adapter/abstract.php(479): zend_db_statement->execute(array) #2 /home/autobadges/public_html/stangcenter.com/lib/zend/db/adapter/pdo/abstract.php(238): zend_db_adapter_abstract->query('select `main_ta...', array) #3 /home/autobadges/public_html/stangcenter.com/lib/varien/db/adapter/pdo/mysql.php(333): zend_db_adapter_pdo_abstract->query('select `main_ta...', array) #4 /home/autobadges/public_html/stangcenter.com/lib/zend/db/adapter/abstract.php(734): varien_db_adapter_pdo_mysql->query(object(varien_db_select), array) #5 /home/autobadges/public_html/stangcenter.com/lib/varien/data/collection/db.php(783): zend_db_adapter_abstract->fetchall(object(varien_db_select), array) #6 /home/autobadges/public_html/stangcenter.com/lib/varien/data/collection/db.php(696): varien_data_collection_db->_fetchall(object(varien_db_select)) #7 /home/autobadges/public_html/stangcenter.com/lib/varien/data/collection/db.php(617): varien_data_collection_db->getdata() #8 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/adminhtml/block/catalog/product/edit/tabs.php(57): varien_data_collection_db->load() #9 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/block/abstract.php(223): mage_adminhtml_block_catalog_product_edit_tabs->_preparelayout() #10 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/model/layout.php(430): mage_core_block_abstract->setlayout(object(mage_core_model_layout)) #11 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/model/layout.php(446): mage_core_model_layout->createblock('adminhtml/catal...', 'product_tabs') #12 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/model/layout.php(238): mage_core_model_layout->addblock('adminhtml/catal...', 'product_tabs') #13 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/model/layout.php(204): mage_core_model_layout->_generateblock(object(mage_core_model_layout_element), object(mage_core_model_layout_element)) #14 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/model/layout.php(209): mage_core_model_layout->generateblocks(object(mage_core_model_layout_element)) #15 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/controller/varien/action.php(343): mage_core_model_layout->generateblocks() #16 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/controller/varien/action.php(270): mage_core_controller_varien_action->generatelayoutblocks() #17 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/adminhtml/controller/action.php(263): mage_core_controller_varien_action->loadlayout(array, true, true) #18 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/adminhtml/controllers/catalog/productcontroller.php(246): mage_adminhtml_controller_action->loadlayout(array) #19 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/controller/varien/action.php(418): mage_adminhtml_catalog_productcontroller->editaction() #20 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/controller/varien/router/standard.php(253): mage_core_controller_varien_action->dispatch('edit') #21 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/controller/varien/front.php(176): mage_core_controller_varien_router_standard->match(object(mage_core_controller_request_http)) #22 /home/autobadges/public_html/stangcenter.com/app/code/core/mage/core/model/app.php(340): mage_core_controller_varien_front->dispatch() #23 /home/autobadges/public_html/stangcenter.com/app/mage.php(627): mage_core_model_app->run(array) #24 /home/autobadges/public_html/stangcenter.com/index.php(80): mage::run('', 'store') #25 {main}
write zend query in try block
and
catch exception
zend_db_statement_mysqli_exception (check 1 using 'mysql' or 'mysqli' or 'pdo') in exception catch code call {model}->getdefaultadapter()->closeconnection() , again call zend query have got.
this should solve problem.
note: below code reference , should not used (may have error in it).
try { $user = {model}->fetchrow(array('user_id = ?' => $senderid)); } catch(zend_db_statement_mysqli_exception $zenddbmysqliexc) { if(stristr($zenddbmysqliexc->getmessage(), 'mysql server has gone away')) { {model}->getdefaultadapter()->closeconnection(); $user = {model}->fetchrow(array('user_id = ?' => $senderid)); } } 
Comments
Post a Comment