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


Ошибка в 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 `mg_product` p LEFT JOIN `mg_category` c ON c.id = p.cat_id LEFT JOIN `mg_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 `mg_product_variant` AS pv GROUP BY pv.product_id ) AS temp ON p.id = temp.product_id WHERE p.id IN ('271642','293684','293654','243243','293274','255582','286723','257837','264260','275104','300499','204017','287260','294023','297761','268426','293492','239269','293683','294449','294435','288934','271688','232750','214527','294477','257911','293274','257837','242207','243243','214578','294917','242149','220570','214576','268457','221096','214757') LIMIT 0, 46
Got error 28 from storage engine


/var/www/profistroy.su/mg-core/lib/navigator.php (line 65)


/var/www/profistroy.su/mg-core/models/catalog.php (line 349)


/var/www/profistroy.su/mg-core/controllers/index.php (line 94)


/var/www/profistroy.su/mg-core/lib/moguta.php(0) : eval()'d code(1) : eval()'d code(49) : eval()'d code (line 11)


/var/www/profistroy.su/mg-core/lib/moguta.php(0) : eval()'d code(1) : eval()'d code (line 49)


/var/www/profistroy.su/mg-core/lib/moguta.php(0) : eval()'d code (line 1)


/var/www/profistroy.su/mg-core/lib/moguta.php (line 0)


/var/www/profistroy.su/mg-core/mg-start.php (line 0)


/var/www/profistroy.su/index.php (line 80)