I think I've found the reason, it is the setting
sql_mode = only_full_group_by which leaves two options:
First you can try to disable that setting, but if you are on a managed server you may not be permitted to do this so we refrain from that.
Secondly, you can try the following SQL query if you feel comfortable with phpMyAdmin:
Code: Select all
SELECT u.user_id, u.username FROM (phpbb_users u CROSS JOIN phpbb_user_group ug CROSS JOIN phpbb_groups g)
WHERE u.user_id = ug.user_id
AND g.group_id = ug.group_id
AND (UPPER(g.group_name) LIKE 'ADMINISTRATORS' OR UPPER(g.group_name) LIKE '%MODERATOR%')
GROUP BY u.username, u.user_id;
If this works without an error message, I can rewrite the query in the next version so it will work with your system (and others as well, of course).
