Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
This is intentional.All rows in comprofiler table have user_id columns identical to id columns.
This is not a CRITICAL error, but it can cause problems.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
Yes, you should edit your database and ensure your collations match. If unsure how to change collations please contact your host. Generally this can be done by navigating to the table within phpmyadmin followed by clicking the Operations tab at the top.Is there somthing else I need to do?
Please Log in to join the conversation.
Please Log in to join the conversation.
What should it match to?
Please Log in to join the conversation.