Hi all,
I have the same problem and I found the SQL query: SELECT DISTINCT ue.*, u.*, '' AS 'NA' FROM #__users u JOIN #__user_usergroup_map g ON g.`user_id` = u.`id` JOIN #__comprofiler ue ON ue.`id` = u.`id` WHERE u.block = 0 AND ue.approved = 1 AND ue.confirmed = 1 AND ue.banned = 0 AND g.group_id IN ( 6, 2, 3, 4, 5) ORDER BY `name` ASC
The code is executed at line 346 of cb.lists.php in SITE_URL/administrator/components/com_comprofiler/library/cb.
I'll try to fix the problem, but if you know how to solve it immediately please let me know!
Official error: UnableToCalculatePositionException: cannot calculate position of name within BY `name` ASC
Further more if I remove ORDER BY `name` ASC
the problem is solved