Joomla 500 error Illegal mix of collations

Joomla 3.7 introduced the custom fields as part of the core. It was a great feature missing in previous releases. However you may experience some issues while upgrading your site and trying to use it.

If you face the "illegal mix of collations issue" and already tried to fix the collation in phpmyadmin or using AdminTools extension, you can try the solution below.

This error usually appears when trying to access the Content Fields or creating a new custom field in the Content manager. You will need access to phpmyadmin in order to perform the query.

The solution itself is simple and should be a straight forward process, however, don't forget to always backup your database and/or files to avoid any headaches, it's always better to be safe.

Once in phpmyadmin go to the SQL section and perform this query: 

ALTER TABLE #__languages MODIFY lang_code char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;

Replace #__ for your Joomla prefix for database tables and execute. You should see a green confirmation message.

Keep up with us to know more of Joomla news/fixes!

And remember, if you require expert professional support with your Joomla CMS, we are here to help.

Per second billing & hourly support packages available.
Call us toll-free (844) JOOMLA-5  or   Request a free estimate

Tags: 500 error,, collations issue, phpmyadmin, mysql