К-19.1 Комод

+7 (4012) 40-04-04

Задать вопрос

Пн–Вс 10:00–19:00

Exception: Query error 42S22: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'shop_groups.sorting1' in 'order clause'. Query: SELECT `shop_groups`.* FROM `shop_groups` LEFT OUTER JOIN `shop_group_properties` ON `shop_groups`.`shop_id` = `shop_group_properties`.`shop_id` LEFT OUTER JOIN `property_value_ints` ON `shop_groups`.`shortcut_id` = `property_value_ints`.`entity_id` AND `shop_group_properties`.`property_id` = `property_value_ints`.`property_id` WHERE `shop_groups`.`shop_id` = '1' AND `shop_group_properties`.`property_id` = 218 AND `property_value_ints`.`value` = 1 AND `shop_groups`.`deleted` = 0 GROUP BY `shop_groups`.`id` HAVING COUNT(DISTINCT `shop_group_properties`.`property_id`) = 1 ORDER BY `shop_groups`.`sorting1` ASC
modules/core/database/pdo.php:604 Core_Exception->__construct
modules/core/querybuilder/statement.php:80 Core_DataBase_Pdo->query
modules/core/orm.php:518 Core_QueryBuilder_Statement->execute
modules/core/entity.php:531 Core_ORM->findAll
templates/template1/template.htm:318 Core_Entity->findAll
modules/template/model.php:103 include
modules/core/page.php:166 Template_Model->execute
modules/core/command/controller/default.php:583 Core_Page->execute
modules/core/router/route.php:195 Core_Command_Controller_Default->showAction
index.php:240 Core_Router_Route->execute