user_id columns identical to id columns

I am using Joomla 1.5.22 and just installed CB latest version.

When running the tools/check user database this error comes up.

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

Can anyone give me some help with this?

Dr. Dave, this has been discussed before on these forums (please search).
You need to make sure all collations are set to same encoding (utf8_general).

Yes, they have been discussed before. The last time I tried to use CB I had the same problem and you couldn't figure out why. My host worked on it for quite some time only to determine that it was CB that was causing the problem. I couldn't get any assistance so I tried another mod.

I was hoping that there would be a fix, but guess not. I have considered purchasing the support package, but don't think that would help.

If I use CB with this conflict will in cause other issues?

The mixed collations isn't even coming from CB. It's the result of your ACL tables and your _users tables having 2 different collations, which shouldn't be the case. You only see the error because CB joins them together to perform a DB query on them combined. To fix this you could use phpmyadmin for example then navigate to the below tables and select "Operations" on the top menu while viewing those tables (1 by 1) and changing the collation to match the rest of your install. Ideally they should all be set to collation "utf8_general_ci".

_core_acl_aro
_core_acl_aro_groups
_core_acl_aro_map
_core_acl_aro_sections
_core_acl_groups_aro_map
_users

A (Advanced or Professional) support subscription would of course make a significant difference as I could review your database and fix this for you.

Thanks Kyle,

I may take you up on the professional or advanced. We did what you recommended last time with my host provider and but CB kept creating an error and changing it back.

If you will fix it for me then it would be worth the cost. I will look into this and get back with you.