Hallo,
I have just upgraded to 1.9 from 1.2.1. It's all almoust OK.
But 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 jd_users u LEFT JOIN jd_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 searched the forum and have found only 1 topic in archiv
www.joomlapolis.com/forum/130-cb-123-general-discussion/137392-cb-tools-check-users-database-error
But as an answer there is only the link to article:
www.joomlapolis.com/content/view/8115/58/
And this article does not exist ("500 - View not found").
How to get it fix?
Thanks,
Leon
P.S. have J1.5.26, want 2.5
