There has been a critical error processing your request
SQL Error: Can't create/write to file '/tmp/#sql-temptable-203f68-c748f2-13e1fe.MAI' (Errcode: 28 "No space left on device")\nError No: 1\nSQL: SELECT DISTINCT SQL_CALC_FOUND_ROWS p.*,
COALESCE( ( SELECT CASE WHEN p2sp.price_prefix='%' THEN p.price - (p2sp.price * (p.price/100))
ELSE p2sp.price END as special_price
FROM aboa_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,
pd.name AS name,
pd.blurb,
m.name AS manufacturer,
ss.name AS stock,
( SELECT FLOOR(AVG(r.rating))
FROM aboa_reviews r
WHERE p.product_id = r.product_id AND status = 1
GROUP BY r.product_id
) AS rating ,
( SELECT COUNT(rw.review_id)
FROM aboa_reviews rw
WHERE p.product_id = rw.product_id AND rw.status = 1
GROUP BY rw.product_id
) AS review
FROM aboa_products p
LEFT JOIN aboa_product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN aboa_products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN aboa_manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN aboa_stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1')
LEFT JOIN aboa_products_to_categories p2c
ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW()
AND p2s.store_id = '0' AND m.manufacturer_id = '169' ORDER BY p.date_modified DESC LIMIT 980,20PHP call stack:
#0 /var/www/vhosts/acw.co.za/httpdocs/core/lib/db.php:138
#1 /var/www/vhosts/acw.co.za/httpdocs/core/engine/extensions.php:1175
#2 /var/www/vhosts/acw.co.za/httpdocs/core/engine/extensions.php:406
#3 /var/www/vhosts/acw.co.za/httpdocs/core/lib/db.php:104
#4 /var/www/vhosts/acw.co.za/httpdocs/storefront/model/catalog/product.php:498
#5 /var/www/vhosts/acw.co.za/httpdocs/storefront/controller/pages/product/manufacturer.php:144
#6 /var/www/vhosts/acw.co.za/httpdocs/core/engine/dispatcher.php:308
#7 /var/www/vhosts/acw.co.za/httpdocs/core/engine/dispatcher.php:343
#8 /var/www/vhosts/acw.co.za/httpdocs/core/engine/page.php:110
#9 /var/www/vhosts/acw.co.za/httpdocs/core/engine/router.php:204
#10 /var/www/vhosts/acw.co.za/httpdocs/core/engine/router.php:86
#11 /var/www/vhosts/acw.co.za/httpdocs/index.php:95
in /var/www/vhosts/acw.co.za/httpdocs/core/database/amysqli.php on line 179
COALESCE( ( SELECT CASE WHEN p2sp.price_prefix='%' THEN p.price - (p2sp.price * (p.price/100))
ELSE p2sp.price END as special_price
FROM aboa_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,
pd.name AS name,
pd.blurb,
m.name AS manufacturer,
ss.name AS stock,
( SELECT FLOOR(AVG(r.rating))
FROM aboa_reviews r
WHERE p.product_id = r.product_id AND status = 1
GROUP BY r.product_id
) AS rating ,
( SELECT COUNT(rw.review_id)
FROM aboa_reviews rw
WHERE p.product_id = rw.product_id AND rw.status = 1
GROUP BY rw.product_id
) AS review
FROM aboa_products p
LEFT JOIN aboa_product_descriptions pd
ON (p.product_id = pd.product_id
AND pd.language_id = '1')
LEFT JOIN aboa_products_to_stores p2s ON (p.product_id = p2s.product_id)
LEFT JOIN aboa_manufacturers m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN aboa_stock_statuses ss
ON (p.stock_status_id = ss.stock_status_id
AND ss.language_id = '1')
LEFT JOIN aboa_products_to_categories p2c
ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW()
AND p2s.store_id = '0' AND m.manufacturer_id = '169' ORDER BY p.date_modified DESC LIMIT 980,20PHP call stack:
#0 /var/www/vhosts/acw.co.za/httpdocs/core/lib/db.php:138
#1 /var/www/vhosts/acw.co.za/httpdocs/core/engine/extensions.php:1175
#2 /var/www/vhosts/acw.co.za/httpdocs/core/engine/extensions.php:406
#3 /var/www/vhosts/acw.co.za/httpdocs/core/lib/db.php:104
#4 /var/www/vhosts/acw.co.za/httpdocs/storefront/model/catalog/product.php:498
#5 /var/www/vhosts/acw.co.za/httpdocs/storefront/controller/pages/product/manufacturer.php:144
#6 /var/www/vhosts/acw.co.za/httpdocs/core/engine/dispatcher.php:308
#7 /var/www/vhosts/acw.co.za/httpdocs/core/engine/dispatcher.php:343
#8 /var/www/vhosts/acw.co.za/httpdocs/core/engine/page.php:110
#9 /var/www/vhosts/acw.co.za/httpdocs/core/engine/router.php:204
#10 /var/www/vhosts/acw.co.za/httpdocs/core/engine/router.php:86
#11 /var/www/vhosts/acw.co.za/httpdocs/index.php:95
in /var/www/vhosts/acw.co.za/httpdocs/core/database/amysqli.php on line 179