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


Ошибка в SQL запросе: SELECT p.id FROM `mg_product` as p LEFT JOIN `mg_product_variant` pv ON p.`id` = pv.`product_id` JOIN `mg_product_user_property` as pup56 ON (pup56.product_id = p.id AND ((pup56.property_id = '56') AND (LCASE(concat("|",pup56.value,"|")) REGEXP LCASE("[[.vertical-line.]]EDENY(#.*#)?[[.vertical-line.]]"))))WHERE p.activity = 1 AND ABS(IFNULL( pv.`count` , 0 ) ) + ABS( p.`count` ) >0 AND p.cat_id IN (44,79,672,78,603,515,574,80,685,464,601,45,103,670,81,669,516,575,83,619,465,600,47,104,673,105,517,576,84,605,466,602,46,522,577,675,85,521,578,674,524,526,579,527,580,528,581,529,582,525,583,532,584,530,585,531,586,43) or FIND_IN_SET(43,p.`inside_cat`)
Regex error 'POSIX collating elements are not supported at offset 1'


/home/oleggkr/web/akba-line.ru/public_html/mg-core/lib/filter.php (line 605)


/home/oleggkr/web/akba-line.ru/public_html/mg-core/models/catalog.php (line 1025)


/home/oleggkr/web/akba-line.ru/public_html/mg-core/models/catalog.php (line 84)


/home/oleggkr/web/akba-line.ru/public_html/mg-core/controllers/catalog.php (line 109)


/home/oleggkr/web/akba-line.ru/public_html/mg-core/lib/moguta.php(35) : eval()'d code(1) : eval()'d code(49) : eval()'d code (line 11)


/home/oleggkr/web/akba-line.ru/public_html/mg-core/lib/moguta.php(35) : eval()'d code(1) : eval()'d code (line 49)


/home/oleggkr/web/akba-line.ru/public_html/mg-core/lib/moguta.php(35) : eval()'d code (line 1)


/home/oleggkr/web/akba-line.ru/public_html/mg-core/lib/moguta.php (line 35)


/home/oleggkr/web/akba-line.ru/public_html/mg-core/mg-start.php (line 50)


/home/oleggkr/web/akba-line.ru/public_html/index.php (line 78)