Hi guyz,
I am having the following error as a result after using the "CB Tools: Check Users database".
[code:1]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[/code:1]
I have just upgraded to 1.2.3 from 1.2.2.
I must confess that I was getting this error even before upgrading to 1.2.3
How to get it fix?
many Thanks