Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offday
Today is our off day. We are taking some rest and will come back stronger tomorrow. Promise!
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00
Our current time: Monday 12:50 am
Add a reply View Replies (9)

Resolved Filter issue with filed values containing accentuated characters.

  1. superkooka
    superkooka
  2. Bug Report
  3. Saturday, January 30 2021, 10:25 AM
Good morning support team, i beg your help for an issue encountered on my website.
I use the Easy Profile Pro Module to display a
lawyers list with their specialities to choose from.
Unfortunately, some specialities does not return results in the filter page.
After further investigations, i think it has a link with accentuated letters.
For example, i have a user (lawyer) called Chantel FINE.
In the filed "Activités dominantges", the user has : Droit de la sécurité sociale, Droit des mineurs, Droit pénal général.
The value "Droit des mineurs" is correctly taken into account in the filtyer page, and the user is shown.
But for the two other values, that contains accentuated letters ("Droit de la sécurité sociale", and "droit pénal général";), the filter page does not show any results.
Can u please point me to the right direction to solve this issue ?
Thanks ,

Thomas.
Attachments (3)
Filer-ok.jpg Filer-ok.jpg
Filtering-KO.jpg Filtering-KO.jpg
Easy-Profile search page.jpg Easy-Profile search page.jpg
References
  1. https://www.avocat-95.fr/
  2. https://www.avocat-95.fr/index.php/recherche-avocat
Responses (9)
admin
admin Accepted Answer
Admin
Hi,
to avoid this issue we recommend to use the correct way to adds option to a select with a syntax like: 
droit_de_la_securite_sociale|Droit de la sécurité sociale

value|Text


With this the value stored and searched have the maximum compatibility with all charset.

Also with this method you are able to translate options: http://docs.easy-profile.com/index.php/article/translate-fields
  1. more than a month ago
  2. Bug Report
  3. # 1
superkooka
superkooka Accepted Answer
Pro
Thanks for the reply, do u have any workaround to provide ? I have hundreds of users on the website, i m afraid to enter all the infos again :x
  1. more than a month ago
  2. Bug Report
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
the fast way to fix this is to use an SQL Query. You can use some tool like phpMyAdmin (normally provided by all hosting providers) and launch a query like this:
UPDATE prefix_jsn_users SET activite_dominante="droit_de_la_securite_sociale" WHERE activite_dominante="Droit de la sécurité sociale"


You should do this for all values, so also for "Droit des mineurs" (become droit_des_mineurs) and "Droit pénal général" (become droit_penal_general)

If you is not confident with an SQL tools then I can do it for you with site details that you have already provided me
  1. more than a month ago
  2. Bug Report
  3. # 3
superkooka
superkooka Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 4
superkooka
superkooka Accepted Answer
Pro
I my database, all accentuated characters "é" are saved like this :

\u00e9
  1. more than a month ago
  2. Bug Report
  3. # 5
admin
admin Accepted Answer
Admin
Hi,
1) Yes, so something like this: 
droit_de_la_securite_sociale|Droit de la sécurité sociale

droit_des_mineurs|Droit des mineurs

droit_penal_general|Droit pénal général
Also with this if you need to change the text then you will not lose association between user data and value

2) Yes :)
  1. more than a month ago
  2. Bug Report
  3. # 6
superkooka
superkooka Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 7
superkooka
superkooka Accepted Answer
Pro
I may be dumb ^^ .
Mysql does'nt find any matching rows when running the query on my local installation.
I think there's an issue with character encoding from my side, or maybe spaces in fields values ... Please look at the attached screenshots :
  1. more than a month ago
  2. Bug Report
  3. # 8
superkooka
superkooka Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.