Tuesday, 25 October 2016 10:44

[SOLVED] Database Collation Issue after Upgrading to Joomla 3.6.4

Written by 
[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:

  1. Backup site
  2. Sign into phpMyAdmin
  3. Browse to the database in question
  4. Click on the "operations" tab
  5. Under "Collation" - choose "utf8_general_ci" and click "Go"
  6. 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!

Read 1497 times Last modified on Tuesday, 25 October 2016 11:36

Leave a comment

Make sure you enter the (*) required information where indicated.
Basic HTML code is allowed.

Copyright © 2005-2018 Covington Creations, LLC | Legal