Tuesday, 25 October 2016 15:44

[SOLVED] Database Collation Issue after Upgrading to Joomla 3.6.4

Written by Nate Covington

Be the first to comment!

[SOLVED] Database Collation Issue after Upgrading to Joomla 3.6.4

I just encountered an issue after upgrading a client's site to Joomla 3.6.4. I was presented with the following error message on both the front end and back end of the site:

Error displaying the error page: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN #__extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT id, home, template, s.params FROM #__template_styles as s LEFT JOIN #__extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1

My solution:

Backup site
Sign into phpMyAdmin
Browse to the database in question
Click on the "operations" tab
Under "Collation" - choose "utf8_general_ci" and click "Go"
Fixed!

Comments:This was noted on a site that was migrated from Joomla 1.5 to the current 3.x platform. For sites that were built with a clean installation of Joomla 3.x, the issue will likely not surface. It is also important to note that folks using Joomla 1.0, 1.5, or 2.5 sites do not NEED to upgrade to the latest version.

I've written previously about this (same concept applies with any Wordpress or Drupal site). Since it is open source software, you cannot be FORCED into doing anything! We personally still support older versions of Joomla. It's just the Joomla "core" developers that stop supporting old versions!

If you would like to hire us to maintain, update, or patch your Joomla site, contact us today!

Last modified on Friday, 22 April 2022 13:30

Published in Blog

Tagged under

More in this category: « Scam Alert: Domainservice "Domain Registration Service SEO Company" Security Issue? Joomla 3.6.4 /administrator panel background color changed »