Warning: mysqli::query(): MySQL server has gone away in /home/vermontsales_b2b/www/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 172Warning: mysqli::query(): Error reading result set's header in /home/vermontsales_b2b/www/vqmod/vqcache/vq2-system_library_db_mysqli.php on line 172OPL-DB-ERR-002: An internal database error occurred. Please contact your administrator. Log time : 10-05-2026 08:27:34 :: Message[Error: MySQL server has gone away
Error No: 2006
. Error in: /home/vermontsales_b2b/www/system/library/journal3/opencart/model.php line 48
SELECT
MAX(c.category_id) category_id,
MAX(cd.name) value,
MAX(c.image) image,
COUNT(*) total
,c.category_id as `cat_id`
FROM `oc_category` c
LEFT JOIN `oc_category_description` cd ON (c.category_id = cd.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
LEFT JOIN `oc_product_to_category`p2c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_product` p ON (p.product_id = p2c.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
ifnull(p2s.status, p.status) = '1'
AND ifnull(p2s.date_available, p.date_available) <= NOW()
AND p2s.store_id = '0'
AND pd.language_id = '1'
AND cd.language_id = '1'
AND c2s.store_id = '0'
AND c.status = '1'
GROUP BY c.category_id
HAVING COUNT(*) > 0
ORDER BY c.sort_order, LCASE(cd.name) ASC
]