Support

  1. superkooka
  2. Bug Report
  3. Saturday, January 30 2021, 10:25 AM
  4.  Subscribe via email
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)
References
  1. https://www.avocat-95.fr/
  2. https://www.avocat-95.fr/index.php/recherche-avocat
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 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 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 Accepted Answer
Pro
I have some knowledge with phpmyadmin, i'll try. My last question is, to avoid any mistake :
1) In easyprofile admin component, i have to edit my options select field with the right syntax you provided before :
value|Text
2) for Each value, i ran a mysql command like this one :
UPDATE prefix_jsn_users SET activite_dominante="correct_value" WHERE activite_dominante="invalid value"
This should update all my users, right ?

Thanks for support
  1. more than a month ago
  2. Bug Report
  3. # 4
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 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 Accepted Answer
Pro
Thank you very much :) I'll try this asap and report the result back to you in case of success.
  1. more than a month ago
  2. Bug Report
  3. # 7
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 :
Attachments (2)
  1. more than a month ago
  2. Bug Report
  3. # 8
superkooka Accepted Answer
Pro
Ok, found a workaround with my issue.For those who may encounter this issue.
I exported the table in xml format.
Then dropped completely the prefix_jsn_users table
Edited the xml file with notepad++, and batched replaced the strings with the accentuated issues.
Imported back the xml table in phpmyadmin.
All working right now.
Thanks for support, regards, Thomas.
  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.

Request Support

Support is currently Offline

Support Availability

Working days: Monday to Friday. The support staff is not available on weekends; in the most of cases tickets will not be answered during that time.

Reply time: Depending on the complexity of your support issue it's usually between a few minutes and 24 hours for paid members and about one week for free members. When we expect longer delays we will notify you.

Guidelines

Before you post: read the documentation and search the forums for an answer to your question.

When you post: include Site Details if you request a support (you can use the form below the reply in Site Details tab).

Auto Solved Question: If after a week the author of the post does not reply to a request by moderator, the question will be marked as resolved.

Language: only English

Search Users

Easy Profile® is not affiliated with or endorsed by Open Source Matters or the Joomla Project. Joomla is Free Software released under the GNU/GPL License.