Support

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

Resolved How Do i resolve this error "Illegal mix of collations" when installing Easy Profile

  1. graficoctane
    graficoctane
  2. General
  3. Tuesday, November 25 2014, 03:09 AM
After Installing, i get this error "Illegal mix of collations". I am using the free version of Easy profile and my Joomla version is 3.3.6. Please help me to resolve this as I was this close to purchasing the pro version. I have attached a screenshot.
Attachments (1)
Screen Shot 2014-11-24 at 9.06.34 PM.png Screen Shot 2014-11-24 at 9.06.34 PM.png
  1. SQL ERROR
Responses (19)
admin
admin Accepted Answer
Admin
Hi,
such an error indicates that 2 of your database tables have different collations (encoding).
Such errors may have their root cause in bad hosting configurations or other reasons.
These improper database collations show up as errors in SQL JOIN statements between the 2 tables.
The solution is to use phpmyadmin to manually alter the collation of one table to match that of the other.

In your case both tables (and columns of both tables) should have the utf8_general_ci collation.
  1. more than a month ago
  2. General
  3. # 1
juancameneses
juancameneses Accepted Answer
Content Protected
References
  1. http://conlaorejaroja.com/index.php
  1. more than a month ago
  2. General
  3. # 2
admin
admin Accepted Answer
Admin
Hi,
I think in your case both tables (and columns of both tables) should have the utf8_unicode_ci collation.
  1. more than a month ago
  2. General
  3. # 3
juancameneses
juancameneses Accepted Answer
Could you help me please to resolver this problem, step by step?

Thx
  1. more than a month ago
  2. General
  3. # 4
admin
admin Accepted Answer
Admin
I can not explain it step by step because each provider has its console for database management.

You can use PhpMyAdmin?
  1. more than a month ago
  2. General
  3. # 5
juancameneses
juancameneses Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 6
admin
admin Accepted Answer
Admin
Hi,
Follow these steps:
- Select your DB in left column
- Now you will see all table of db
- Click on table #__jsn_users
- Go to operations
- Change collation of table
  1. more than a month ago
  2. General
  3. # 7
juancameneses
juancameneses Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 8
admin
admin Accepted Answer
Admin
can you please post me your site details? you can use the form below the reply in "site details" tab. Please include also phpmyadmin details in "Optional Information".
  1. more than a month ago
  2. General
  3. # 9
juancameneses
juancameneses Accepted Answer
Here details,

Thanks!.
  1. more than a month ago
  2. General
  3. # 10
juancameneses
juancameneses Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 11
admin
admin Accepted Answer
Admin
I found this error
Session is invalid. Please login to phpMyAdmin from control panel. (#0021)

your Phpmyadmin works only after login from Control Panel
  1. more than a month ago
  2. General
  3. # 12
juancameneses
juancameneses Accepted Answer
so, what we can make?
  1. more than a month ago
  2. General
  3. # 13
admin
admin Accepted Answer
Admin
You can send me Cpanel access and re-send me Joomla backend access
  1. more than a month ago
  2. General
  3. # 14
juancameneses
juancameneses Accepted Answer
Details here.
  1. more than a month ago
  2. General
  3. # 15
admin
admin Accepted Answer
Admin
try now :)
  1. more than a month ago
  2. General
  3. # 16
juancameneses
juancameneses Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 17
admin
admin Accepted Answer
Admin
Hi,
we have changed also the columns, try now
  1. more than a month ago
  2. General
  3. # 18
juancameneses
juancameneses Accepted Answer
Content Protected
  1. more than a month ago
  2. General
  3. # 19
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Sorry, the discussion is currently locked. You will not be able to post a reply at the moment.

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.