Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br />
SELECT
IF(p.quantity > 0, 1, 0) AS availability,
COUNT(*) AS total
FROM `oc_product` p
LEFT JOIN `oc_product_description` pd ON (p.product_id = pd.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE
p.status = '1'
AND p.date_available <= NOW()
AND p2s.store_id = '0'
AND pd.language_id = '1'
AND ( pd.tag LIKE '%pipe%')
GROUP BY
CASE
WHEN p.quantity > 0 THEN 1
ELSE 0
END
in /chroot/home/DPdevelop/drillingparts.com/html/system/library/db/mysqli.php:40
Stack trace:
#0 /chroot/home/DPdevelop/drillingparts.com/storage/modification/system/library/db.php(74): DB\MySQLi->query('\n\t\t\tSELECT \n\t\t\t...')
#1 /chroot/home/DPdevelop/drillingparts.com/html/system/library/journal3/opencart/model.php(48): DB->query('\n\t\t\tSELECT \n\t\t\t...')
#2 /chroot/home/DPdevelop/drillingparts.com/html/catalog/model/journal3/filter.php(11 in /chroot/home/DPdevelop/drillingparts.com/html/system/library/db/mysqli.php on line 40
Fatal error: Uncaught Exception: Error: MySQL server has gone away<br />Error No: 2006<br />REPLACE INTO `oc_session` SET session_id = 'a7ea4c17f21a168377caa04960', `data` = '{\"language\":\"en-gb\",\"currency\":\"USD\",\"rd\":\"https:\\/\\/drillingparts.com\\/product-search.html?page=71&tag=pipe\",\"jrv\":[\"31804\",\"86525\",\"21492\",\"36203\",\"35773\",\"31994\",\"37708\",\"37784\",\"68642\",\"37682\",\"15378\",\"26000\",\"37716\",\"6012\",\"34804\",\"27070\",\"32214\",\"69243\",\"16865\"],\"openModal\":false,\"show_popup_count\":2}', expire = '2025-09-09 04:39:04' in /chroot/home/DPdevelop/drillingparts.com/html/system/library/db/mysqli.php:40
Stack trace:
#0 /chroot/home/DPdevelop/drillingparts.com/storage/modification/system/library/db.php(74): DB\MySQLi->query('REPLACE INTO `o...')
#1 /chroot/home/DPdevelop/drillingparts.com/html/system/library/session/db.php(32): DB->query('REPLACE INTO `o...')
#2 /chroot/home/DPdevelop/drillingparts.com/html/system/library/session.php(81): Session\DB->write('a7ea4c17f21a168...', in /chroot/home/DPdevelop/drillingparts.com/html/system/library/db/mysqli.php on line 40