includes/acp/acp_users.php around line 125, need to add module_auth & left_id to group by clause.

$sql = 'SELECT module_mode, module_auth
FROM ' . MODULES_TABLE . "
WHERE module_basename = 'users'
AND module_enabled = 1
AND module_class = 'acp'
GROUP BY module_mode
ORDER BY left_id";

thanks.

General Error
SQL ERROR [ postgres ]

ERROR: column "phpbb_modules.module_auth" must appear in the GROUP BY clause or be used in an aggregate function []

SQL

SELECT module_mode, module_auth FROM phpbb_modules WHERE module_basename = 'users' AND module_enabled = 1 AND module_class = 'acp' GROUP BY module_mode ORDER BY left_id

BACKTRACE

FILE: includes/db/postgres.php
LINE: 177
CALL: dbal_postgres->sql_error()

FILE: includes/acp/acp_users.php
LINE: 125
CALL: dbal_postgres->sql_query()

FILE: includes/functions_module.php
LINE: 463
CALL: acp_users->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()