Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br />SELECT p.product_id, p.price, p.tax_class_id, v2_ps.price AS special FROM oc_product p LEFT JOIN (
SELECT product_id, CAST(SUBSTRING_INDEX(GROUP_CONCAT(price ORDER BY priority ASC, price ASC), ',', 1) AS DECIMAL(15,4)) AS price
FROM `oc_product_special`
WHERE product_id IN (1287272,1250858,1269574,1250757,1354546,1287237,1449003,1477303,1448961,1250764,1411204,1449007,1250815,1250824,1287186,1250845,1250755,1250892,1287246,1269541,1287175,1351028,1351005,1250787,1411199,1415482,1411171,1250802,1250821,1250863,1250765,1269564,1269553,1415493,1287189,1250872,1269548,1448911,1415473,1351046,1287183,1411200,1449040,1411169,1449061,1350996,1415472,1350974,1486949,1346344,1415509,1449015,1448835,1250856,1287188,1287288,1411208,1385638,1287291,1448736,1284396,1287184,1250816,1269572,1166706,1471270,1287215,1452309,1351044,1250895,1416697,1416700,1250794,1448799,1213327,1415504,1350985,1250865,1411185,1287185,1483615,1449077,1449063,1139069,1483628,1486925,1468346,1385631,1250823,1445808,1350933,1431623,1411168,1269503,1449066,1415479,1411203,1250893,1157143,1251053,1415520,1406764,1416699,1415467,1250879,1483669,1449058,1416701,1269507,1415517,1448872,1486955,1250770,1415505,1449071,1213262,1250871,1452293,1157149,1449087,1415514,1434772,1452288,1250819,1250846,1351045,1470929,1438786,1486893,1287254,1449030,1445874,1270616,1250854,1287187,1471272,1411166,1444494,1250859,1354500,1213461,1416707,1250827,1438743,1449054,1471273,1415529,1315799,1415530,1415518,1471275,1449059,1213193,1415489,1351008,1416696,1472173,1415499,1452299,1250762,1346369,1415471,1213478,1415468,1452305,1406831,1406813,1415507,1452282,1287194,1213486,1452283,1287206,1468335,1438800,1452308,1445856,1449060,1392728,1411167,1250786,1411176,1411177,1411178,1449038,1449097,1415506,1287232,1139115,1350972,1284386,1287191,1354512,1411173,1287171,1434769,1250885,1406810,1354532,1287201,1179973,1431644,1431638,1416679,1250896,1392718,1287294,1406756,1250782,1411179,1287230,1250890,1411198,1287235,1354504,1411197,1406748,1415481,1250746,1406802,1411192,1250857,1272809,1406791,1406837,1415474,1415508,1415525,1415480,1287241,1250844,1250784,1287240,1287173,1287297,1406798,1350988,1250751,1287248,1392731,1350989,1287251,1287210,1287176,1287179,1287198,1287224,1287209,1287257,1287283)
AND customer_group_id = '1'
AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
GROUP BY product_id
) v2_ps ON v2_ps.product_id = p.product_id
LEFT JOIN (
SELECT product_id, CAST(SUBSTRING_INDEX(GROUP_CONCAT(price ORDER BY priority ASC, price ASC), ',', 1) AS DECIMAL(15,4)) AS price
FROM `oc_product_discount`
WHERE product_id IN (1287272,1250858,1269574,1250757,1354546,1287237,1449003,1477303,1448961,1250764,1411204,1449007,1250815,1250824,1287186,1250845,1250755,1250892,1287246,1269541,1287175,1351028,1351005,1250787,1411199,1415482,1411171,1250802,1250821,1250863,1250765,1269564,1269553,1415493,1287189,1250872,1269548,1448911,1415473,1351046,1287183,1411200,1449040,1411169,1449061,1350996,1415472,1350974,1486949,1346344,1415509,1449015,1448835,1250856,1287188,1287288,1411208,1385638,1287291,1448736,1284396,1287184,1250816,1269572,1166706,1471270,1287215,1452309,1351044,1250895,1416697,1416700,1250794,1448799,1213327,1415504,1350985,1250865,1411185,1287185,1483615,1449077,1449063,1139069,1483628,1486925,1468346,1385631,1250823,1445808,1350933,1431623,1411168,1269503,1449066,1415479,1411203,1250893,1157143,1251053,1415520,1406764,1416699,1415467,1250879,1483669,1449058,1416701,1269507,1415517,1448872,1486955,1250770,1415505,1449071,1213262,1250871,1452293,1157149,1449087,1415514,1434772,1452288,1250819,1250846,1351045,1470929,1438786,1486893,1287254,1449030,1445874,1270616,1250854,1287187,1471272,1411166,1444494,1250859,1354500,1213461,1416707,1250827,1438743,1449054,1471273,1415529,1315799,1415530,1415518,1471275,1449059,1213193,1415489,1351008,1416696,1472173,1415499,1452299,1250762,1346369,1415471,1213478,1415468,1452305,1406831,1406813,1415507,1452282,1287194,1213486,1452283,1287206,1468335,1438800,1452308,1445856,1449060,1392728,1411167,1250786,1411176,1411177,1411178,1449038,1449097,1415506,1287232,1139115,1350972,1284386,1287191,1354512,1411173,1287171,1434769,1250885,1406810,1354532,1287201,1179973,1431644,1431638,1416679,1250896,1392718,1287294,1406756,1250782,1411179,1287230,1250890,1411198,1287235,1354504,1411197,1406748,1415481,1250746,1406802,1411192,1250857,1272809,1406791,1406837,1415474,1415508,1415525,1415480,1287241,1250844,1250784,1287240,1287173,1287297,1406798,1350988,1250751,1287248,1392731,1350989,1287251,1287210,1287176,1287179,1287198,1287224,1287209,1287257,1287283)
AND customer_group_id = '1'
AND quantity = '1'
AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
GROUP BY product_id
) v2_pd ON v2_pd.product_id = p.product_id WHERE p.product_id IN (1287272,1250858,1269574,1250757,1354546,1287237,1449003,1477303,1448961,1250764,1411204,1449007,1250815,1250824,1287186,1250845,1250755,1250892,1287246,1269541,1287175,1351028,1351005,1250787,1411199,1415482,1411171,1250802,1250821,1250863,1250765,1269564,1269553,1415493,1287189,1250872,1269548,1448911,1415473,1351046,1287183,1411200,1449040,1411169,1449061,1350996,1415472,1350974,1486949,1346344,1415509,1449015,1448835,1250856,1287188,1287288,1411208,1385638,1287291,1448736,1284396,1287184,1250816,1269572,1166706,1471270,1287215,1452309,1351044,1250895,1416697,1416700,1250794,1448799,1213327,1415504,1350985,1250865,1411185,1287185,1483615,1449077,1449063,1139069,1483628,1486925,1468346,1385631,1250823,1445808,1350933,1431623,1411168,1269503,1449066,1415479,1411203,1250893,1157143,1251053,1415520,1406764,1416699,1415467,1250879,1483669,1449058,1416701,1269507,1415517,1448872,1486955,1250770,1415505,1449071,1213262,1250871,1452293,1157149,1449087,1415514,1434772,1452288,1250819,1250846,1351045,1470929,1438786,1486893,1287254,1449030,1445874,1270616,1250854,1287187,1471272,1411166,1444494,1250859,1354500,1213461,1416707,1250827,1438743,1449054,1471273,1415529,1315799,1415530,1415518,1471275,1449059,1213193,1415489,1351008,1416696,1472173,1415499,1452299,1250762,1346369,1415471,1213478,1415468,1452305,1406831,1406813,1415507,1452282,1287194,1213486,1452283,1287206,1468335,1438800,1452308,1445856,1449060,1392728,1411167,1250786,1411176,1411177,1411178,1449038,1449097,1415506,1287232,1139115,1350972,1284386,1287191,1354512,1411173,1287171,1434769,1250885,1406810,1354532,1287201,1179973,1431644,1431638,1416679,1250896,1392718,1287294,1406756,1250782,1411179,1287230,1250890,1411198,1287235,1354504,1411197,1406748,1415481,1250746,1406802,1411192,1250857,1272809,1406791,1406837,1415474,1415508,1415525,1415480,1287241,1250844,1250784,1287240,1287173,1287297,1406798,1350988,1250751,1287248,1392731,1350989,1287251,1287210,1287176,1287179,1287198,1287224,1287209,1287257,1287283) AND (CASE
WHEN v2_ps.price IS NOT NULL THEN v2_ps.price
WHEN v2_pd.price IS NOT NULL THEN v2_pd.price
ELSE p.price
END) > 0 ORDER BY (CASE
WHEN v2_ps.price IS NOT NULL THEN v2_ps.price
WHEN v2_pd.price IS NOT NULL THEN v2_pd.price
ELSE p.price
END) ASC, p.product_id ASC LIMIT 1 in /home/gbstage.enabler360.com/public_html/system/library/db/mysqli.php:60
Stack trace:
#0 /home/gbstage.enabler360.com/public_html/system/library/db.php(45): DB\MySQLi->query()
#1 /home/gbstage.enabler360.com/public_html/catalog/model/dyncategory/supportingFunctions.php(3496): DB->query()
#2 /home/gbstage.enabler360.com/public_html/catalog/controller/dyncategory/dyncategory_index_inc.php(707): ModelDynCategorySupportingFunctions->getV2ListingStartingPriceDisplay()
#3 /home/gbstage.enabler360.com/public_html/catalog/controller/dyncategory/dyncategory_v4_index_inc.php(30): include('...')
#4 /home/gbstage.enabler360.com/public_html/catalog/controller/dyncategory/dyncategory_v4.php(4): include('...')
#5 /home/gbstage.enabler360.com/public_html/system/engine/action.php(79): ControllerDyncategoryDyncategoryV4->index()
#6 /home/gbstage.enabler360.com/public_html/catalog/controller/startup/router.php(27): Action->execute()
#7 /home/gbstage.enabler360.com/public_html/system/engine/action.php(79): ControllerStartupRouter->index()
#8 /home/gbstage.enabler360.com/public_html/system/engine/router.php(67): Action->execute()
#9 /home/gbstage.enabler360.com/public_html/system/engine/router.php(56): Router->execute()
#10 /home/gbstage.enabler360.com/public_html/system/framework.php(201): Router->dispatch()
#11 /home/gbstage.enabler360.com/public_html/system/startup.php(106): require_once('...')
#12 /home/gbstage.enabler360.com/public_html/index.php(48): start()
#13 {main}
thrown in /home/gbstage.enabler360.com/public_html/system/library/db/mysqli.php on line 60