Fatal error: 'Error: MySQL server has gone away
Error No: 2006
SELECT DISTINCT p.product_id, p.price, p.quantity, p.sale, p.date_modified, pm.store_id, pd.name, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product p INNER JOIN oc_product_map pm ON pm.product_id = '3911' AND pm.store_type = 'C' AND pm.store_product_id = p.product_id AND p.status = '1' AND p.date_available <= NOW() LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) GROUP BY p.product_id'
in /home/lqvuxriizscc/public_html/system/library/db/mysqli.php:40
Stack trace:
#0 system/library/db.php(45): DB\MySQLi->query('SELECT DISTINCT...')
#1 catalog/model/extension/module/price_comparison_store.php(13): DB->query('SELECT DISTINCT...')
#2 /home/lqvuxriizscc/storage/modification/system/engine/loader.php(260): ModelExtensionModulePriceComparisonStore->getSaleProducts(3911)
#3 system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 catalog/controller/extension/module/price_comparison_store.php(136): Proxy->__call('getSaleProducts', Array)
#5 catalog/controller/extension/module/price_comparison_store.php(43): ControllerExtensionModulePriceComparisonStore->getStoresProducts(3911)
#6 /home/lqvuxriizscc/storage/modification/system/engine/action.php(79): ControllerExtensionModulePriceComparisonStore->index(Array)
#7 system/vendor/BurnEngine/library/Extension.php(338): Action->execute(Object(Registry), Array)
#8 system/vendor/BurnEngine/library/DataBag.php(38): TB_Extension->loadController('extension/modul...', Array)
#9 system/vendor/BurnEngine/widget/OpenCartWidget.php(99): TB_DataBag->__call('loadController', Array)
#10 system/vendor/BurnEngine/catalog/plugin/LayoutBuilderPlugin.php(280): Theme_OpenCartWidget->render()
#11 system/vendor/BurnEngine/catalog/plugin/LayoutBuilderPlugin.php(232): Theme_Catalog_LayoutBuilderPlugin->initAreas(Object(TB_ViewDataBag))
#12 system/vendor/BurnEngine/catalog/plugin/LayoutBuilderPlugin.php(103): Theme_Catalog_LayoutBuilderPlugin->buildAreaSettings(Array, Array)
#13 system/vendor/BurnEngine/library/ExtensionPluginBootstrap.php(113): Theme_Catalog_LayoutBuilderPlugin->execute(Object(TB_ViewDataBag), Object(Request))
#14 system/vendor/BurnEngine/library/ExtensionPlugin.php(65): TB_ExtensionPluginBootstrap->bootstrap('LayoutBuilder')
#15 system/vendor/BurnEngine/catalog/plugin/ProductPlugin.php(18): TB_ExtensionPlugin->bootstrap('layout_builder')
#16 system/vendor/BurnEngine/library/ExtensionPluginBootstrap.php(113): Theme_Catalog_ProductPlugin->execute(Object(TB_ViewDataBag), Object(Request))
#17 system/vendor/BurnEngine/library/ExtensionPluginBootstrap.php(147): TB_ExtensionPluginBootstrap->bootstrap('Product')
#18 system/vendor/BurnEngine/catalog/ThemeCatalogExtension.php(132): TB_ExtensionPluginBootstrap->bootstrapAll()
#19 system/vendor/BurnEngine/library/vendor/sfEventDispatcher.php(76): Theme_Catalog_Extension->afterRouting(Object(sfEvent))
#20 system/vendor/BurnEngine/library/CatalogDispatcher.php(116): sfEventDispatcher->notify(Object(sfEvent))
#21 system/vendor/BurnEngine/library/CatalogDispatcher.php(43): TB_CatalogDispatcher->doRouting(Object(sfEventDispatcher), Object(Request), Object(TB_ViewDataBag))
#22 system/vendor/BurnEngine/catalog/boot.php(71): TB_CatalogDispatcher->dispatch()
#23 catalog/controller/common/BurnEngine.php(87): TB_Boot::dispatchRequest(Object(TB_Engine))
#24 catalog/controller/common/BurnEngine.php(12): ControllerCommonBurnEngine->index()
#25 /home/lqvuxriizscc/storage/modification/system/engine/action.php(79): ControllerCommonBurnEngine->onGetEventsAfter('setting/event/g...', Array, Array)
#26 /home/lqvuxriizscc/storage/modification/system/engine/event.php(66): Action->execute(Object(Registry), Array)
#27 /home/lqvuxriizscc/storage/modification/system/engine/loader.php(267): Event->trigger('model/setting/e...', Array)
#28 system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#29 catalog/controller/startup/event.php(7): Proxy->__call('getEvents', Array)
#30 /home/lqvuxriizscc/storage/modification/system/engine/action.php(79): ControllerStartupEvent->index()
#31 /home/lqvuxriizscc/storage/modification/system/engine/router.php(71): Action->execute(Object(Registry))
#32 /home/lqvuxriizscc/storage/modification/system/engine/router.php(46): Router->execute(Object(Action))
#33 system/framework.php(168): Router->dispatch(Object(Action), Object(Action))
#34 system/startup.php(104): require_once('/home/lqvuxriiz...')
#35 index.php(19): start('catalog')
#36 {main}