[SOLVED] Unknown column 'connections'

11 years 3 months ago #131796 by CosmicGlenn
Replied by CosmicGlenn on topic Re:Unknown column 'connections'
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

Please Log in to join the conversation.

11 years 3 months ago #131808 by nant
Replied by nant on topic Re:Unknown column 'connections'
CosmicGlenn wrote:

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


Look closer at the message you are getting.

The collations still differ - see the 2 (bold) items I have highlighted for you.

utf8_unicode_ci
utf8_general_ci

Please Log in to join the conversation.

11 years 3 months ago #131817 by CosmicGlenn
Replied by CosmicGlenn on topic Re:Unknown column 'connections'
Thanks
got it fixed:cheer: :cheer: :cheer: :cheer:


One more questions

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

Please Log in to join the conversation.

11 years 3 months ago #131848 by krileon
Replied by krileon on topic Re:Unknown column 'connections'
CosmicGlenn wrote:

Thanks
got it fixed:cheer: :cheer: :cheer: :cheer:


One more questions

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

Doesn't matter as long as they aren't Joined in a query which would mix the collations. It's recommend to have a single collation though unless noted otherwise.


Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

Please Log in to join the conversation.

11 years 2 months ago #131879 by nant
Replied by nant on topic Re:Unknown column 'connections'
CosmicGlenn wrote:

Thanks
got it fixed:cheer: :cheer: :cheer: :cheer:


One more questions

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


utf8_general_ci

Please Log in to join the conversation.

Moderators: beatnantkrileon
Time to create page: 0.428 seconds

Facebook Twitter LinkedIn