There has been a critical error processing your request
SQL Error: MySQL server has gone away\nError No: 2006\nSQL: SELECT DISTINCT *,
pd.name AS name,
pd.blurb AS blurb,
m.name AS manufacturer,
ss.name AS stock_status,
stock_checkout,
lcd.unit as length_class_name, ( SELECT FLOOR(AVG(r.rating))
FROM abaf_reviews r
WHERE p.product_id = r.product_id AND status = 1
GROUP BY r.product_id
) AS rating , COALESCE( ( SELECT CASE WHEN p2sp.price_prefix='%' THEN p.price - (p2sp.price * (p.price/100))
ELSE p2sp.price END as special_price
FROM abaf_product_specials p2sp
WHERE p2sp.product_id = p.product_id
AND p2sp.customer_group_id = '1'
AND ((p2sp.date_start = '0000-00-00' OR p2sp.date_start < NOW())
AND (p2sp.date_end = '0000-00-00' OR p2sp.date_end > NOW()))
ORDER BY p2sp.priority ASC, special_price ASC LIMIT 1
) , p.price) as final_price FROM abaf_products p
LEFT JOIN abaf_product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN abaf_products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN abaf_manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN abaf_stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1') LEFT JOIN abaf_length_class_descriptions lcd
ON (p.length_class_id = lcd.length_class_id
AND lcd.language_id = '1')
WHERE p.product_id = '258'
AND p2s.store_id = '0'
AND p.date_available <= NOW() AND p.status = '1'PHP call stack:
#0 /home/licotato/public_html/core/lib/db.php:119
#1 /home/licotato/public_html/core/engine/extensions.php:1160
#2 /home/licotato/public_html/core/engine/extensions.php:384
#3 /home/licotato/public_html/core/lib/db.php:85
#4 /home/licotato/public_html/storefront/model/catalog/product.php:51
#5 /home/licotato/public_html/storefront/controller/pages/product/product.php:56
#6 /home/licotato/public_html/core/engine/dispatcher.php:306
#7 /home/licotato/public_html/core/engine/dispatcher.php:341
#8 /home/licotato/public_html/core/engine/page.php:110
#9 /home/licotato/public_html/core/engine/router.php:204
#10 /home/licotato/public_html/core/engine/router.php:86
#11 /home/licotato/public_html/index.php:97
in /home/licotato/public_html/core/database/amysqli.php on line 142
pd.name AS name,
pd.blurb AS blurb,
m.name AS manufacturer,
ss.name AS stock_status,
stock_checkout,
lcd.unit as length_class_name, ( SELECT FLOOR(AVG(r.rating))
FROM abaf_reviews r
WHERE p.product_id = r.product_id AND status = 1
GROUP BY r.product_id
) AS rating , COALESCE( ( SELECT CASE WHEN p2sp.price_prefix='%' THEN p.price - (p2sp.price * (p.price/100))
ELSE p2sp.price END as special_price
FROM abaf_product_specials p2sp
WHERE p2sp.product_id = p.product_id
AND p2sp.customer_group_id = '1'
AND ((p2sp.date_start = '0000-00-00' OR p2sp.date_start < NOW())
AND (p2sp.date_end = '0000-00-00' OR p2sp.date_end > NOW()))
ORDER BY p2sp.priority ASC, special_price ASC LIMIT 1
) , p.price) as final_price FROM abaf_products p
LEFT JOIN abaf_product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN abaf_products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN abaf_manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN abaf_stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1') LEFT JOIN abaf_length_class_descriptions lcd
ON (p.length_class_id = lcd.length_class_id
AND lcd.language_id = '1')
WHERE p.product_id = '258'
AND p2s.store_id = '0'
AND p.date_available <= NOW() AND p.status = '1'PHP call stack:
#0 /home/licotato/public_html/core/lib/db.php:119
#1 /home/licotato/public_html/core/engine/extensions.php:1160
#2 /home/licotato/public_html/core/engine/extensions.php:384
#3 /home/licotato/public_html/core/lib/db.php:85
#4 /home/licotato/public_html/storefront/model/catalog/product.php:51
#5 /home/licotato/public_html/storefront/controller/pages/product/product.php:56
#6 /home/licotato/public_html/core/engine/dispatcher.php:306
#7 /home/licotato/public_html/core/engine/dispatcher.php:341
#8 /home/licotato/public_html/core/engine/page.php:110
#9 /home/licotato/public_html/core/engine/router.php:204
#10 /home/licotato/public_html/core/engine/router.php:86
#11 /home/licotato/public_html/index.php:97
in /home/licotato/public_html/core/database/amysqli.php on line 142