Hello!

Running CB 2.0.11 on Jommla 3.4.4: After upgrading to Mysql 5.6 we're getting these error message if going to a user profile view or to a user list - we're getting this error message only if a user is logged in - if the profile or the user list gets viewed as a guest we do not get any error messages and the profile or the userlist gets shown correctly.

This is the query:
SELECT DISTINCT UE.*, U.* AS NA FROM xxx_USERS U JOIN xxx_USER_USERGROUP_MAP G ON G.`USER_ID` = U.`ID` JOIN xxx_COMPROFILER UE ON UE.`ID` = U.`ID` WHERE U.BLOCK = 0 AND UE.APPROVED = 1 AND UE.CONFIRMED = 1 AND UE.BANNED = 0 AND UE.AVATAR IS NOT NULL AND G.GROUP_ID IN (2, 3) ORDER BY RAND() LIMIT 0, 3

And this the error message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS NA FROM xxx_USERS U JOIN xxx_USER_USERGROUP_MAP G ON G.`USER_ID` = U.`ID`' at line 1

Any thoughts?

Thanks for your help
Frank

can be closed. Root cause found ...