?
avatar infograf768
infograf768
22 Mar 2016

I get here issues with weblinks on a legacy site:

Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT() FROM #weblinks AS a LEFT JOIN #languages AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__viewlevels AS ag ON ag.id = a.access LEFT JOIN #__categories AS c ON c.id = a.catid WHERE (a.state IN (0, 1)) Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' SQL=SELECT a.id, a.title, a.alias, a.checked_out, a.checked_out_time, a.catid,a.hits, a.state, a.access, a.ordering, a.language, a.publish_up, a.publish_down,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title FROM #weblinks AS a LEFT JOIN #languages AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__viewlevels AS ag ON ag.id = a.access LEFT JOIN #__categories AS c ON c.id = a.catid WHERE (a.state IN (0, 1)) ORDER BY a.title asc LIMIT 0, 100 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '=' SQL=SELECT COUNT() FROM #weblinks AS a LEFT JOIN #languages AS l ON l.lang_code = a.language LEFT JOIN #__users AS uc ON uc.id=a.checked_out LEFT JOIN #__viewlevels AS ag ON ag.id = a.access LEFT JOIN #__categories AS c ON c.id = a.catid WHERE (a.state IN (0, 1))

avatar infograf768 infograf768 - open - 22 Mar 2016
avatar brianteeman
brianteeman - comment - 22 Mar 2016

I thought there was an update for weblinks to specifically address this?


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/9513.

avatar wilsonge
wilsonge - comment - 22 Mar 2016

There wasn't a web links fi . But this was what we released RC4 specifically to deal with. Please try again JM (commit that should have fixed this issue: 6ac3dc4) - note the language code should have a utf8mb4_bin not a utf8mb4_general_ci collation

avatar brianteeman brianteeman - change - 22 Mar 2016
Labels Added: ?
avatar brianteeman
brianteeman - comment - 22 Mar 2016

sorry that I was confused

avatar wilsonge
wilsonge - comment - 22 Mar 2016

It's ok! I wasn't having a go at you!

avatar infograf768
infograf768 - comment - 22 Mar 2016

Yes, indeed. @wilsonge is correct.

I ran the query
ALTER TABLE#__languagesMODIFYlang_codechar(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
and it is fixed.

closing.

avatar infograf768 infograf768 - change - 22 Mar 2016
Status New Closed
Closed_Date 0000-00-00 00:00:00 2016-03-22 08:53:46
Closed_By infograf768
avatar infograf768 infograf768 - close - 22 Mar 2016
avatar infograf768 infograf768 - close - 22 Mar 2016

Add a Comment

Login with GitHub to post a comment