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_to_category` p2c ON (p2c.product_id = p.product_id)
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 p2c.category_id = '63'
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/h 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 = '92bf5364e2272e9f3ad9b65be9', `data` = '{\"language\":\"en-gb\",\"currency\":\"USD\",\"rd\":\"https:\\/\\/drillingparts.com\\/air-and-hydraulics\\/parker-air-valves.html?page=85\",\"jrv\":[\"22971\",\"29832\",\"22985\",\"29844\"],\"openModal\":false,\"show_popup_count\":2}', expire = '2025-10-03 04:34:03' 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('92bf5364e2272e9...', Array)
#3 [internal function]: Session->close()
#4 {main}
thrown in /chroot/home/DPdevelop/drillingparts.com/html/system/library/db/mysqli.php on line 40