Support

    You are here:  
  1. Home
  2. Support
  3. Checkbox value in SQL
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Offline
Support Offline
It's past support hour. 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: Friday 11:25 pm
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)
superkooka
superkooka Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 1
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. # 2
superkooka
superkooka Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 3
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. # 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
superkooka
superkooka Accepted Answer
Pro
Content Protected
  1. more than a month ago
  2. Bug Report
  3. # 6
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. # 7
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. # 8
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. # 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
Ask a Question
Official support hours:
Monday To Friday except Saturday and Sunday
From 09:30 To 17:00

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.

We use a few cookies

Our site uses non fat, delicious cookies which help us improve your user experience. You can read more about it in our Legal page.