CRM Руководитель - Форум

В глобальном поиске возникает ошибка при вводе числового значения в строку поиска

Database Error: 1305 - FUNCTION a0167896_crm.REGEXP_REPLACE does not exist
Query: select id, name as title,'ipages' as entities_id from app_ext_ipages where is_menu=0 and (find_in_set(0,users_groups) or find_in_set(1,assigned_to)) and (name like '%105%' or description like '%105%') UNION select e.id, e.field_292 as title, (31) as entities_id from app_entity_31 e where (e.id='105' or (e.field_291 like '%105%') or (e.field_292 like '%105%') or REGEXP_REPLACE(e.field_293, '[^0-9]','') like '%105%' or REGEXP_REPLACE(e.field_294, '[^0-9]','') like '%105%' or (e.field_295 like '%105%') or (e.field_296 like '%105%') or (e.field_297 like '%105%')) UNION select e.id, e.field_274 as title, (30) as entities_id from app_entity_30 e where (e.id='105' or (e.field_274 like '%105%') or (e.field_280 like '%105%') or (e.field_281 like '%105%') or (e.field_347 like '%105%') or (e.field_360 like '%105%') or (e.field_387 like '%105%') or (e.field_432 like '%105%') or (e.field_449 like '%105%') or (e.field_453 like '%105%'))
Page: /index.php?module=global_search/search&action=listing&token=HSptT3nWwD
#0 includes/functions/database.php(99): mysqli_query(Object(mysqli), 'select id, name...')
#1 includes/classes/split_page.php(59): db_query('select id, name...')
#2 modules/global_search/actions/search.php(189): split_page->__construct('select id, name...', 'search_result', 'query_num_rows', '10')
#3 index.php(31): require('/home/a0167896/...')
#4 {main}

Обновите Вашу БД до последней версии. Функция REGEXP_REPLACE доступна в mysql 8.0+ и mariadb 10.0.5+

Спасибо! После обновления до 8.0 глобальный поиск работает корректно.