Tuesday, 25 October 2016 15:44

[SOLVED] Database Collation Issue after Upgrading to Joomla 3.6.4

[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!

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 »
Subscribe with Email
Comments (0)
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Suggested Locations

Latest Comments

Paul Oliva
Got a similar email that seemed suspicious. Ignored it and they even followed up today.
Alex
My organization received one of these emails from "Linda," but uses https://www.bestprosintown.com/p...
Angela Snowman
Hi Nate, I got the same email template from the same email address today and found you through a ...
Renan
Just received one today (16 Aug 2022) from "Mailchimp". Thanks for sharing!
Julia G Dumas
Thanks for posting this. I just got one today. I was 99% sure it was a scam, and your post confirmed...


Design & Development

Wordpress, Drupal, Joomla
New custom websites
Bespoke themes and extensions
Redesigns, upgrades, migrations

Web Design & Development


Optimization & SEO

Let us optimize and manage your overall online presence. We offer full service monthly SEO as well as one-time projects.  

Optimization Plans & Pricing


Maintenance, Patching

White glove monthly backups, security updates, maintenance and testing for your Wordpress, Drupal, or Joomla site.

Maintenance Plans & Pricing


Email Newsletter

Bring your web & marketing performance to the next level: monthly blog post roundup via email.  

Stay in Touch!