Thanks
You guys are awsome: I got collations match fixed


but I keep getting this message

All rows in comprofiler table have user_id columns identical to id columns

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

what can i do?

Post edited by: CosmicGlenn, at: 2010/04/30 04:11

Post edited by: CosmicGlenn, at: 2010/04/30 04:12

Thanks
got it fixed:cheer:


One more questions

Should all my collitions be >>>utf8_general_ci ?
cause i see a lot of >>>utf8_unicode_ci

Thanks
got it fixed:cheer:


One more questions

Should all my collitions be >>>utf8_general_ci ?
cause i see a lot of >>>utf8_unicode_ci