Joomla Save failed :Illegal mix of collation

Discussion regarding Joomla! 2.5 Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
JFA
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 105
Joined: Tue Jun 24, 2014 10:49 pm

Joomla Save failed :Illegal mix of collation

Post by JFA » Tue Oct 28, 2014 11:17 pm

I have recently encountered the following error, whenever I create or edit an article and want to save.

Save failed with the following error: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' SQL=INSERT INTO `qelzw_finder_tokens_aggregate` (`term_id`, `term`, `stem`, `common`, `phrase`, `term_weight`, `context`, `context_weight`) SELECT t.term_id, t1.term, t1.stem, t1.common, t1.phrase, t1.weight, t1.context, ROUND( t1.weight * COUNT( t2.term ) * 1.700000, 8 ) AS context_weight FROM ( SELECT DISTINCT t1.term, t1.stem, t1.common, t1.phrase, t1.weight, t1.context FROM `qelzw_finder_tokens` AS t1 WHERE t1.context = 1 ) AS t1 JOIN `qelzw_finder_tokens` AS t2 ON t2.term = t1.term LEFT JOIN `qelzw_finder_terms` AS t ON t.term = t1.term WHERE t2.context = 1 GROUP BY t1.term ORDER BY t1.term DESC
You do not have the required permissions to view the files attached to this post.

imarklee
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 205
Joined: Wed Aug 29, 2012 7:07 am
Location: Kuala Lumpur, Malaysia
Contact:

Re: Joomla Save failed :Illegal mix of collation

Post by imarklee » Wed Oct 29, 2014 6:54 pm

Hello,

This is often the case when there is a SQL query trying to join 2 different tables but because they are on a different collation (charsets), MySQL is throwing these errors. What you could do is to login to your phpmyadmin and ensure that all the collations are the same for the tables.
Lead Developer,
https://stackideas.com


Locked

Return to “Performance - Joomla! 2.5”