Page 1 of 1

Server Migration

Posted: 26 Nov 2020, 21:19
by antber
Hello Sergey sorry i need help with a error.

Some users have this error when do a search.

Database Error: 1305 - FUNCTION gcapspt_ruko572.rukovoditel_regex_replace does not exist
Query: select count(e.id) as total from app_entity_25 e left join app_global_lists_choices fc0 on fc0.id=e.field_289 where e.id>0 and ((e.field_213 like '%19498%') or (e.field_216 like '%19498%') or (e.field_218 like '%19498%') or (e.field_229 like '%19498%') or (e.field_256 like '%19498%') or (e.field_230 like '%19498%') or (e.field_231 like '%19498%') or (e.field_260 like '%19498%') or rukovoditel_regex_replace('[^0-9]','',e.field_235) like '%19498%' or (e.field_236 like '%19498%') or (e.field_257 like '%19498%') or (e.field_258 like '%19498%') or (e.field_259 like '%19498%') or (e.field_261 like '%19498%') or (e.field_263 like '%19498%') or (e.field_264 like '%19498%') or (e.field_265 like '%19498%') or (e.field_296 like '%19498%')) and (e.field_266 in (33) and e.field_289 in (3) and e.field_290 in (4) ) and ((select count(*) as total from app_entity_25_values cv where cv.items_id=e.id and cv.fields_id='219' and cv.value='20')>0 or e.created_by='20') order by fc0.sort_order asc, fc0.name asc
Page: /index.php?module=items/listing

I think it´s simple for you.
Thanks in advance.
Best regards.

If you need a Print Screens tell me.

Re: Server Migration

Posted: 26 Nov 2020, 21:32
by support
Go to phone field type and edit it.
mysql function rukovoditel_regex_replace will be created automatically.

Re: Server Migration

Posted: 26 Nov 2020, 21:41
by antber
Sergey very good works perfect, thanks.
I didn't say it was simple for you ;)

Thanks again.