Ошибка глобального поиска
Добавлено: 08 янв 2020, 18:48
Доброго дня, ошибка мускуля :
Database Error: 1054 - Unknown column 'e.field_214' in 'field list'
Query: select e.id,e.field_312 as title, (30) as entities_id from app_entity_30 e where (e.field_312 like '%канаф%') or (e.field_318 like '%канаф%') UNION select e.id,e.field_214 as title, (27) as entities_id from app_entity_27 e where (e.field_291 like '%канаф%') or (e.field_294 like '%канаф%') or (e.field_295 like '%канаф%') UNION select e.id,e.field_202 as title, (25) as entities_id from app_entity_25 e where (e.field_226 like '%канаф%') or (e.field_245 like '%канаф%') or (e.field_250 like '%канаф%') or (e.field_270 like '%канаф%') UNION select e.id,e.field_211 as title, (26) as entities_id from app_entity_26 e where (e.field_211 like '%канаф%') or rukovoditel_regex_replace('[^0-9]','',e.field_246) like '%%' or rukovoditel_regex_replace('[^0-9]','',e.field_247) like '%%'
Page: /index.php?module=global_search/search&action=listing
Database Error: 1054 - Unknown column 'e.field_214' in 'field list'
Query: select e.id,e.field_312 as title, (30) as entities_id from app_entity_30 e where (e.field_312 like '%канаф%') or (e.field_318 like '%канаф%') UNION select e.id,e.field_214 as title, (27) as entities_id from app_entity_27 e where (e.field_291 like '%канаф%') or (e.field_294 like '%канаф%') or (e.field_295 like '%канаф%') UNION select e.id,e.field_202 as title, (25) as entities_id from app_entity_25 e where (e.field_226 like '%канаф%') or (e.field_245 like '%канаф%') or (e.field_250 like '%канаф%') or (e.field_270 like '%канаф%') UNION select e.id,e.field_211 as title, (26) as entities_id from app_entity_26 e where (e.field_211 like '%канаф%') or rukovoditel_regex_replace('[^0-9]','',e.field_246) like '%%' or rukovoditel_regex_replace('[^0-9]','',e.field_247) like '%%'
Page: /index.php?module=global_search/search&action=listing