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.
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.
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
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".