Check Users database error
- Dr Dave
- OFFLINE
-
New Member
- Posts: 8
- Thanks: 0
- Karma: 0
Any help would be great.
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
Please Log in to join the conversation.
nant
Team Member- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- Dr Dave
- OFFLINE
-
New Member
- Posts: 8
- Thanks: 0
- Karma: 0
A little guidance from someone who knows more than me would be nice
Please Log in to join the conversation.
- nant
- Team Member
- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
Dr Dave wrote: I have searched the forum and read and read and read as I did before posting.
A little guidance from someone who knows more than me would be nice
It wasn't obvious that you searched, since you did not indicate that in your first post.
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
You have 2 tables that contain different collations either at the table level or in one of their fields.
You need to manually find the utf8_unicode_ci instances and change to utf8_general_ci.
A tool such as phpmyadmin can help you do this.
The 2 tables referenced are highlighted in bold in your original quoted post above.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
- Dr Dave
- OFFLINE
-
New Member
- Posts: 8
- Thanks: 0
- Karma: 0
They also can't figure out why this has affected several other joomla sites that I have hosted with them.
Any ideas?
Thanks
Please Log in to join the conversation.
- nant
- Team Member
- OFFLINE
- Posts: 25531
- Thanks: 1834
- Karma: 877
Dr Dave wrote: Thanks for the update. I have spent over an hour on the line with my host and they identified what you mentioned, changed it and it keeps chaning back. They can't figure out why.
They also can't figure out why this has affected several other joomla sites that I have hosted with them.
Any ideas?
Thanks
weird that is keeps coming back - are you sure that you modified it correctly?
If you did then there is something changing it back and honestly I cannot think of what could be doing this...
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
-
You are here:
- Home
- Forums
- Community Discussions
- Community Builder
- General
- Check Users database error