Ошибка в SQL запросе:
SELECT DISTINCT p.id, CONCAT(c.parent_url,c.url) AS category_url,
c.unit AS category_unit, p.unit AS product_unit,
c.weight_unit AS category_weightUnit, p.weight_unit AS product_weightUnit,
p.url AS product_url, p.*, pv.product_id AS variant_exist, rate,
(p.price_course + p.price_course * (IFNULL(rate,0))) AS `price_course`,
IF(p.count <0, 1000000,
IF(varcount,
IF(p.count 0, -10, p.cat_id) AS cat_id,p.price_course AS `price_course_sort`
FROM `fa_product` p
LEFT JOIN `fa_category` c
ON c.id = p.cat_id
LEFT JOIN `fa_product_variant` pv
ON p.id = pv.product_id
LEFT JOIN (
SELECT pv.product_id, SUM(IF(pv.count <0, 1000000, round(pv.count,2))) AS varcount
FROM `fa_product_variant` AS pv
GROUP BY pv.product_id
) AS temp ON p.id = temp.product_id
WHERE ( ((p.price_course + p.price_course * (IFNULL(rate,0))) BETWEEN '0' AND '55385000')OR ((pv.price_course + pv.price_course * (IFNULL(rate,0))) BETWEEN '0' AND '55385000') ) AND ( 1=1 or FIND_IN_SET(0,p.`inside_cat`) ) AND p.id IN (232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357) AND p.`activity` = 1 GROUP BY p.id HAVING(SUM(IFNULL(ABS(pv.count), 0) + ABS(p.count)) > 0) ORDER BY `price_course_sort` asc LIMIT 20, 20
Disk full (/tmp/#sql-temptable-262-82b32-b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")/home/generatory/gc-ets.ru/www/mg-core/lib/navigator.php (line 73)
/home/generatory/gc-ets.ru/www/mg-core/models/catalog.php (line 418)
/home/generatory/gc-ets.ru/www/mg-core/models/catalog.php (line 103)
/home/generatory/gc-ets.ru/www/mg-core/controllers/catalog.php (line 171)
/home/generatory/gc-ets.ru/www/mg-core/lib/moguta.php (line 0)
/home/generatory/gc-ets.ru/www/mg-core/mg-start.php (line 0)
/home/generatory/gc-ets.ru/www/index.php (line 97)