Here is the feedback from my host on this situation
Hello,
As far as I can tell this seems to be an issue going on with the upgrade of Community Builder. I checked and there were a mix of a couple different character sets in use. I ran a script we have to set them all to the same collation, utf8_general_ci, but unfortunately this does not seem to have helped. The error message points to two different tables in your database, jos_core_acl_aro and jos_users. I checked these two in particular and verified that they are both only using the utf8_general_ci set. Further, I logged into the database and ran the actual query that the error message refers to, which is:
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
It returned a single result without generating any kind of error whatsoever:
mysql> 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;
+
+
| id |
+
+
| 202 |
+
+
1 row in set (0.00 sec)
I don't expect either the query or the result to mean much to you, but it may be helpful to you in dealing further with the plugin's author. You mentioned that the plugin's author is suggesting that we need to fix a conflict. I have verified that there is no conflict between the two tables in question, but the error message remains. If there is anything more specific that they can suggest we look at we would be happy to do so. Please let us know if we can be of any further assistance.
Best regards,
Peter Weber
Linux Systems Administrator
HostGator.com LLC
support.hostgator.com
beat
