3

I have enable Configurable Swatches, but I encounter a problem it shows me a page (There has been an error processing your request) Exception printing is disabled by default for security reasons.

Error log record number: 164106845

Here's what my file contains :

a:5:{i:0;s:269:"SQLSTATE[HY000]: General error: 2006 MySQL server has gone away, query was: SELECT `main_table`.* FROM `design_change` AS `main_table` WHERE (store_id = :store_id) AND (date_from <= :required_date or date_from IS NULL) AND (date_to >= :required_date or date_to IS NULL)";i:1;s:2618:"#0 /home/hairqualkn/www/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/hairqualkn/www/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/hairqualkn/www/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/hairqualkn/www/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `main_ta...', Array)
#4 /home/hairqualkn/www/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `main_ta...', Array)
#5 /home/hairqualkn/www/lib/Zend/Db/Adapter/Abstract.php(756): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/hairqualkn/www/app/code/core/Mage/Core/Model/Resource/Design.php(179): Zend_Db_Adapter_Abstract->fetchRow(Object(Varien_Db_Select), Array)
#7 /home/hairqualkn/www/app/code/core/Mage/Core/Model/Design.php(62): Mage_Core_Model_Resource_Design->loadChange('1', NULL)
#8 /home/hairqualkn/www/app/code/core/Mage/Core/Model/App/Area.php(162): Mage_Core_Model_Design->loadChange('1')
#9 /home/hairqualkn/www/app/code/core/Mage/Core/Model/App/Area.php(124): Mage_Core_Model_App_Area->_initDesign()
#10 /home/hairqualkn/www/app/code/core/Mage/Core/Model/App/Area.php(92): Mage_Core_Model_App_Area->_loadPart('design')
#11 /home/hairqualkn/www/app/code/core/Mage/Core/Model/App.php(774): Mage_Core_Model_App_Area->load()
#12 /home/hairqualkn/www/app/code/core/Mage/Core/Controller/Varien/Action.php(512): Mage_Core_Model_App->loadArea('frontend')
#13 /home/hairqualkn/www/app/code/core/Mage/Core/Controller/Front/Action.php(64): Mage_Core_Controller_Varien_Action->preDispatch()
#14 /home/hairqualkn/www/app/code/core/Mage/Core/Controller/Varien/Action.php(407): Mage_Core_Controller_Front_Action->preDispatch()
#15 /home/hairqualkn/www/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('view')
#16 /home/hairqualkn/www/app/code/community/ArtsOnIT/OfflineMaintenance/Controller/Router/Standard.php(46): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#17 /home/hairqualkn/www/app/code/core/Mage/Core/Controller/Varien/Front.php(172): ArtsOnIT_OfflineMaintenance_Controller_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#18 /home/hairqualkn/www/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#19 /home/hairqualkn/www/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#20 /home/hairqualkn/www/index.php(87): Mage::run('', 'store')
#21 {main}";s:3:"url";s:14:"/peruvien.html";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:2:"fr";}
Improve this question
1
  • your issue fixed? and how to fixed this one?
    – Ravikumar Patel
    Commented Jun 20, 2017 at 11:18

1 Answer 1

Reset to default
1

Try this: https://stackoverflow.com/questions/7942154/mysql-error-2006-mysql-server-has-gone-away

Most of the time Mysql goes away because of the low default setting for max_allowed_packet. Worth giving it a try.

Improve this answer
2
  • Thanks for your reply how to increase?
    – webevolution
    Commented Jun 1, 2015 at 23:37
  • 1
    Travelest thou to the fine StackOverflow link provided and there thou shalt find thine answer.
    – Fiasco Labs
    Commented Jan 26, 2016 at 4:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.