Support

    You are here:  
  1. Home
  2. Support
  3. Translate language in radio box
Toggle Submenu
  1. Forums
  2. Recent
  3. Categories
  4. Tags
  5. Users
  6. Badges
Support is currently Online
Add a reply View Replies (5)

Resolved Illegal mix of collations

  1. idefix38
    idefix38
  2. General
  3. Tuesday, August 30 2016, 09:05 PM
I have an error when i call the folowing url:
http://www.mysite.com/component/jsn/Séraph

I specify that i have changed the collation of all tabled,columns and datatabase to utf8_unicode_ci
however i have this error :

General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE)
for operation '='

if i use the same url without accent it works.

How can i resolve this ?
Responses (5)
admin
admin Accepted Answer
Admin
Hi,
sorry I don't know, this is a SQL problem caused by the change of DB collation.
  1. more than a month ago
  2. General
  3. # 1
idefix38
idefix38 Accepted Answer
Pro
I have the same probleme before i changed the collation of all tables.

In fact, the error occurs when the username contains accents and i want to view the profil of this user.

any ideas to resolve this ?
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
I think the error come from a query that search ID from Username in file /components/com_jsn/router.php at line 142.

In this line there is a simple query to standard Joomla table (#__users), and in all environments it work, so I think this is a problem of your DB.

To check this we need to access to your DB with some tool like phpMyAdmin (you can use the form below the reply in "Site Details" tab).
  1. more than a month ago
  2. General
  3. # 3
idefix38
idefix38 Accepted Answer
Pro
Site details here
  1. more than a month ago
  2. General
  3. # 4
admin
admin Accepted Answer
Admin
After many tests, also by changing charset in my dev site we can't replicate this problem.
After some investigation I found that when you change column/table/db charset then you change only default charset if db server do not know value charset.

Seems that you have imported this table with a old charset not know by your server but compatible with utf8_general_ci and utf8_unicode_ci (maybe it is utf_general_ci).

To solve you can try to export #__users table, check charset in table declaration (CREATE TABLE.....) and reimport.
or Alternative: we can try to solve this problem by changing something in router php, but we need to have ftp access because we can't replicate this problem.
  1. more than a month ago
  2. General
  3. # 5
  • 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 Online
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.