-
Bug
-
Resolution: Fixed
-
Blocker
-
3.0.0
-
None
-
PHP Environment: 5.2.6RC3-pl0-gentoo
Database: PostgreSQL 8.2.7
I just upgraded my nearly brand new Forum to 3.0.1 and afterwards I got this error: (which I didn't had before)
In the "Administration Panel", when you click on the tab Forums->Forum Permissions and then choose a forum and click to submit.
SQL ERROR [ postgres ]
|
|
|
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list []
|
|
|
SQL
|
|
|
SELECT DISTINCT u.user_id, u.username FROM phpbb_users u, phpbb_acl_users a WHERE u.user_id = a.user_id AND a.forum_id = 3 AND (a.auth_option_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30) OR a.auth_role_id IN (14, 15, 16, 17, 18, 19, 20, 21, 22)) ORDER BY u.username_clean, u.user_regdate ASC
|
|
|
BACKTRACE
|
|
|
FILE: includes/db/postgres.php
|
LINE: 177
|
CALL: dbal->sql_error()
|
|
|
FILE: includes/acp/acp_permissions.php
|
LINE: 1165
|
CALL: dbal_postgres->sql_query()
|
|
|
FILE: includes/acp/acp_permissions.php
|
LINE: 399
|
CALL: acp_permissions->retrieve_defined_user_groups()
|
|
|
FILE: includes/functions_module.php
|
LINE: 471
|
CALL: acp_permissions->main()
|
|
|
FILE: adm/index.php
|
LINE: 74
|
CALL: p_master->load_active()
|