Error: MySQL server has gone away
Error No: 2006
SELECT
MAX(a.attribute_id) attribute_id,
MAX(ad.name) attribute_name,
MAX(pa.text) value,
COUNT(*) total
FROM `oc_product` p
LEFT JOIN `oc_product_attribute` pa ON (p.product_id = pa.product_id)
LEFT JOIN `oc_attribute` a ON (a.attribute_id = pa.attribute_id)
LEFT JOIN `oc_attribute_description` ad ON (ad.attribute_id = a.attribute_id)
LEFT JOIN oc_product_viewed pw ON (p.product_id = pw.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 = '4'
AND pa.language_id = '3'
AND ad.language_id = '3'
GROUP BY lower(pa.text), a.attribute_id
HAVING COUNT(*) > 0
: in /home/oc4.bhs.lv/public_html/system/library/db/mysqli.php on line 76
Fatal error: Uncaught Exception: Error: MySQL server has gone away<br/>Error No: 2006<br/>REPLACE INTO `oc_session` SET `session_id` = '84260243a4ead50d266151bf3e', `data` = '{\"currency\":\"EUR\",\"api_id\":\"journal3_newsletter_36518a1e29\",\"jrv\":[8442,27090,17668,24819,24821,24817,23898,19425,19477,2514,5248,13190,16957,25735,21868,\"27559\",\"20148\",\"17819\"],\"review_token\":\"1bc41f511b6dc5a37bcfcc4d4abc1757\"}', `expire` = '2025-08-06 09:21:24' in /home/oc4.bhs.lv/public_html/system/library/db/mysqli.php:76
Stack trace:
#0 /home/oc4.bhs.lv/public_html/vqmod/vqcache/vq2-system_library_db.php(59): Opencart\System\Library\DB\MySQLi->query()
#1 /home/oc4.bhs.lv/public_html/vqmod/vqcache/vq2-system_library_session_db.php(59): Opencart\System\Library\DB->query()
#2 /home/oc4.bhs.lv/public_html/vqmod/vqcache/vq2-system_library_session.php(97): Opencart\System\Library\Session\DB->write()
#3 [internal function]: Opencart\System\Library\Session->close()
#4 {main}
thrown in /home/oc4.bhs.lv/public_html/system/library/db/mysqli.php on line 76