Неперехваченное исключение
Ошибка (databaseException): Expression #1 of ORDER BY clause is not in SELECT list, references column 'ee21_old.h.ord' which is not in SELECT list; this is incompatible with DISTINCT in query: SELECT DISTINCT SQL_CALC_FOUND_ROWS h.id as id, h.rel as pid
FROM cms3_hierarchy h, cms3_object_types t, cms3_permissions p, cms3_hierarchy_relations hr, cms3_objects o
LEFT JOIN cms3_object_content oc_512_lj ON oc_512_lj.obj_id=o.id AND oc_512_lj.field_id = '512'
WHERE o.type_id IN (25, 28, 45, 46, 50, 123, 127, 130, 131, 132, 133, 148, 150, 53, 54, 56, 57, 58, 59, 60, 61, 63, 64, 68, 69, 70, 71, 72, 77, 125, 146, 128, 137, 138, 157, 160, 162, 78, 124, 147, 126, 139, 154, 156, 163, 108, 134, 135, 136) AND t.id = o.type_id AND (oc_512_lj.int_val = '1') AND h.domain_id = '1' AND h.lang_id = '1' AND h.is_deleted = '0' AND h.is_active = '1' AND (p.rel_id = h.id AND p.level & 1 AND p.owner_id IN(13)) AND h.id = hr.child_id AND (hr.level < 1 AND hr.rel_id IS NULL) AND h.obj_id = o.id
ORDER BY h.ord ASC
Показать отладочную информацию
Поддержка пользователей UMI.CMS umi-cms.ru/support