Server Migration

Ask your questions here.
Post Reply
antber
Posts: 3
Joined: 02 Oct 2020, 02:53
Name: Antonio Bernardino
Location: Portugal, Lisboa

Server Migration

Post 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.

User avatar
support
Site Admin
Posts: 3656
Joined: 19 Oct 2014, 18:22
Name: Sergey Kharchishin
Location: Russia, Evpatoriya

Re: Server Migration

Post by support »

Go to phone field type and edit it.
mysql function rukovoditel_regex_replace will be created automatically.

antber
Posts: 3
Joined: 02 Oct 2020, 02:53
Name: Antonio Bernardino
Location: Portugal, Lisboa

Re: Server Migration

Post by antber »

Sergey very good works perfect, thanks.
I didn't say it was simple for you ;)

Thanks again.

Post Reply