I just installed 1.2.2 over top of 1.2.1 and ran the "Check Users Database" tool and received this error along with everything else being green. Is this a real problem?

ERROR: sql query: SELECT u.id FROM #__users u LEFT JOIN #__core_acl_aro a ON a.section_value = 'users' AND a.value = CAST( u.id AS CHAR ) WHERE a.value IS NULL : returned error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' SQL=SELECT u.id FROM jos_users u LEFT JOIN jos_core_acl_aro a ON a.section_value = 'users' AND a.value = CAST( u.id AS CHAR ) WHERE a.value IS NULL

Post edited by: ThePiston, at: 2010/04/16 18:23

Post edited by: krileon, at: 2010/04/19 19:31

I can fix it - what table and how do I do it?

**edit** _ went to the DB and the Utilities tab - I pressed GO next to the Collation area and it was successful but I still get that error. I guess I need to do more?

**edit2** ok I found thta my jos_user table was using utf8_unicode_ci instead of utf8_general_ci and I can fix that. Any idea how what happend? This DB was transferred from one host to another the other day.

Post edited by: ThePiston, at: 2010/04/16 22:51

I just set both jos_users and jos_core_acl_aro to "utf8_general_c". I was looking at other Joomla tables and noticed some are using "latin1_swedish_ci" - will that be a problem in other areas of Joomla?