Всего выполнено запросов: 11 шт. за 0.0106 сек. Закрыть


Ошибка в SQL запросе: SELECT DISTINCT p.id, CONCAT(c.parent_url,c.url) AS category_url, c.unit AS category_unit, p.unit AS product_unit, 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 FROM `gg_product` p LEFT JOIN `gg_category` c ON c.id = p.cat_id LEFT JOIN `gg_product_variant` pv ON p.id = pv.product_id LEFT JOIN ( SELECT pv.product_id, SUM(IF(pv.count <0, 1000000, pv.count)) AS varcount FROM `gg_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE p.id IN ('1','356','372','105','167','158','691','174') LIMIT 0, 8
Disk full (/tmp/#sql_4349_1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")


/home/users/f/f-vilkov/domains/ventorg.com/mg-core/lib/navigator.php (line 65)


/home/users/f/f-vilkov/domains/ventorg.com/mg-core/models/catalog.php (line 311)


/home/users/f/f-vilkov/domains/ventorg.com/mg-core/controllers/index.php (line 94)


/home/users/f/f-vilkov/domains/ventorg.com/mg-core/lib/moguta.php(0) : eval()'d code(1) : eval()'d code(49) : eval()'d code (line 11)


/home/users/f/f-vilkov/domains/ventorg.com/mg-core/lib/moguta.php(0) : eval()'d code(1) : eval()'d code (line 49)


/home/users/f/f-vilkov/domains/ventorg.com/mg-core/lib/moguta.php(0) : eval()'d code (line 1)


/home/users/f/f-vilkov/domains/ventorg.com/mg-core/lib/moguta.php (line 0)


/home/users/f/f-vilkov/domains/ventorg.com/mg-core/mg-start.php (line 0)


/home/users/f/f-vilkov/domains/ventorg.com/index.php (line 80)