ERROR: column "phpbb_modules.left_id" must appear in the GROUP BY clause or be used in an aggregate function LINE 6: ORDER BY left_id ^ []

SQL

SELECT COUNT(module_id) as num_modules FROM phpbb_modules WHERE module_class = 'acp' AND parent_id = 10 AND left_id BETWEEN 89 AND 97 ORDER BY left_id

BACKTRACE

FILE: includes/db/postgres.php

LINE: 188

CALL: dbal->sql_error()

FILE: install/database_update.php

LINE: 690

CALL: dbal_postgres->sql_query()

FILE: install/database_update.php

LINE: 1721

CALL: _add_modules()

FILE: install/database_update.php

LINE: 398

CALL: change_database_data()