yup.. but still the sql error remains... if I just know where this error came from then maybe I can fix it manually...

thanks for your suggestions krileon...

their are only two tables involved?

jos_users and jos_core_acl_aro

i checked them both in phpmyadmin and their collation is in latin1_general_ci... there is no latin1_swedish_ci...

thanks for your help..

no... only the text or varchar datatype has the latin1_general_ci...

thanks for the help.. i really appreciate it.. god bless

I am having the same issue with a fresh install of 1.2.1.

The check users database output:
[code:1]Checking Users Datbase:

All Community Builder comprofiler table rows have links to user table.

All users table rows have links to comprofiler table.

users table has no zero id row.

comprofiler table has no zero id row.

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

All ACL core_acl_aro table rows have corresponding entries in users table.

All core_acl_aro table rows have ACL entries in core_acl_groups_aro_map table.

All core_acl_aro table rows have ACL entries in core_acl_groups_aro_map table.[/code:1]

What is happening on the site is that you cannot save anything in the additional info tab either on the front end or the back end.

Any help would be appreciated. Hostgator support is helping me, here's what they said so far:

Ok I have attempted to change the collation in question on that phpmyadmin however it seems there is another related issue on it as it will not keep the change.

I will have to escalate this issue to an administrator for you

Would you like to be kept posted?