Ошибка в поиске
Добавлено: 03 май 2025, 18:07
Всем доброго дня. После обновления при поиске по номеру телефона выдает ошибку
Database Error: 1305 - FUNCTION u2235555_default.REGEXP_REPLACE does not exist
Query: select count(e.id) as total from app_entity_27 e where e.id>0 and ((e.field_228 REGEXP '\\b312\\b') or REGEXP_REPLACE(e.field_229, '[^0-9]','') like '%312%' or (e.field_232 REGEXP '\\b312\\b')) order by e.field_232 asc
Page: /index.php?module=items/listing
#0 includes/functions/database.php(99): mysqli_query(Object(mysqli), 'select count(e....')
#1 includes/classes/split_page.php(64): db_query('select count(e....')
#2 modules/items/actions/listing.php(213): split_page->__construct('select e.* fro...', 'entity_items_li...', 'select count(e....', '20')
#3 index.php(31): require('/var/www/u22355...')
#4 {main}
Подскажите пожалуйста как решить?
Database Error: 1305 - FUNCTION u2235555_default.REGEXP_REPLACE does not exist
Query: select count(e.id) as total from app_entity_27 e where e.id>0 and ((e.field_228 REGEXP '\\b312\\b') or REGEXP_REPLACE(e.field_229, '[^0-9]','') like '%312%' or (e.field_232 REGEXP '\\b312\\b')) order by e.field_232 asc
Page: /index.php?module=items/listing
#0 includes/functions/database.php(99): mysqli_query(Object(mysqli), 'select count(e....')
#1 includes/classes/split_page.php(64): db_query('select count(e....')
#2 modules/items/actions/listing.php(213): split_page->__construct('select e.* fro...', 'entity_items_li...', 'select count(e....', '20')
#3 index.php(31): require('/var/www/u22355...')
#4 {main}
Подскажите пожалуйста как решить?