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 shp_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 shp_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 shp_products p
LEFT JOIN shp_product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN shp_products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN shp_manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN shp_stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1') LEFT JOIN shp_length_class_descriptions lcd
ON (p.length_class_id = lcd.length_class_id
AND lcd.language_id = '1')
WHERE p.product_id = '102'
AND p2s.store_id = '0'
AND p.date_available <= NOW() AND p.status = '1'PHP call stack:
#0 /var/www/html/tienda.albertolominchar.com/core/lib/db.php:138
#1 /var/www/html/tienda.albertolominchar.com/core/engine/extensions.php:1174
#2 /var/www/html/tienda.albertolominchar.com/core/engine/extensions.php:405
#3 /var/www/html/tienda.albertolominchar.com/core/lib/db.php:104
#4 /var/www/html/tienda.albertolominchar.com/storefront/model/catalog/product.php:36
#5 /var/www/html/tienda.albertolominchar.com/storefront/controller/pages/product/product.php:56
#6 /var/www/html/tienda.albertolominchar.com/core/engine/dispatcher.php:306
#7 /var/www/html/tienda.albertolominchar.com/core/engine/dispatcher.php:341
#8 /var/www/html/tienda.albertolominchar.com/core/engine/page.php:110
#9 /var/www/html/tienda.albertolominchar.com/core/engine/router.php:204
#10 /var/www/html/tienda.albertolominchar.com/core/engine/router.php:86
#11 /var/www/html/tienda.albertolominchar.com/index.php:81
in /var/www/html/tienda.albertolominchar.com/core/database/amysqli.php on line 186
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 shp_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 shp_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 shp_products p
LEFT JOIN shp_product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN shp_products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN shp_manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN shp_stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1') LEFT JOIN shp_length_class_descriptions lcd
ON (p.length_class_id = lcd.length_class_id
AND lcd.language_id = '1')
WHERE p.product_id = '102'
AND p2s.store_id = '0'
AND p.date_available <= NOW() AND p.status = '1'PHP call stack:
#0 /var/www/html/tienda.albertolominchar.com/core/lib/db.php:138
#1 /var/www/html/tienda.albertolominchar.com/core/engine/extensions.php:1174
#2 /var/www/html/tienda.albertolominchar.com/core/engine/extensions.php:405
#3 /var/www/html/tienda.albertolominchar.com/core/lib/db.php:104
#4 /var/www/html/tienda.albertolominchar.com/storefront/model/catalog/product.php:36
#5 /var/www/html/tienda.albertolominchar.com/storefront/controller/pages/product/product.php:56
#6 /var/www/html/tienda.albertolominchar.com/core/engine/dispatcher.php:306
#7 /var/www/html/tienda.albertolominchar.com/core/engine/dispatcher.php:341
#8 /var/www/html/tienda.albertolominchar.com/core/engine/page.php:110
#9 /var/www/html/tienda.albertolominchar.com/core/engine/router.php:204
#10 /var/www/html/tienda.albertolominchar.com/core/engine/router.php:86
#11 /var/www/html/tienda.albertolominchar.com/index.php:81
in /var/www/html/tienda.albertolominchar.com/core/database/amysqli.php on line 186