Can not execute database query.
Details:
Error code: HY000
Error info: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYfd=2431' (OS errno 28 - No space left on device)
Query:
SELECT DISTINCT p.*,
IF(p.url_custom="", p.url_default,p.url_custom) AS product_url,
c.name AS cat_name,
IF(c.url_custom="",c.url_default,c.url_custom) AS cat_url,
manufacturer_name
FROM products AS p
INNER JOIN catalog AS c ON p.cid=c.cid AND c.is_visible="Yes"
LEFT JOIN manufacturers AS m ON p.manufacturer_id = m.manufacturer_id AND m.is_visible=1
WHERE p.is_visible="Yes" AND p.product_id <> "gift_certificate" AND
(
-- No stock control, pull the data
p.inventory_control = "No"
OR
-- Has any stock at all and stock must be >= of min_order if inventory_rule is set to Hide
((p.stock > 0 AND p.inventory_rule <> "Hide") OR (p.stock > 0 AND p.stock >= p.min_order AND p.inventory_rule = "Hide"))
OR
-- Has Display Out Of Stock rule
p.inventory_rule = "OutOfStock"
OR
(p.inventory_control = "AttrRuleInc" AND p.stock >= 0)
)
AND p.manufacturer_id=6 AND p.is_stealth = 0
ORDER BY p.added DESC, p.title LIMIT 648, 18