Forum izinleri hata

[kaksay]

forum izinleri ayarlamak istediğimde aaşağıdaki hatayı aldım. sebebi ve çözümü hakkında bilgi verirseniz sevinirim.

Genel Hata
SQL ERROR [ mssql_odbc ]

[Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified. [37000]

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 IN (5, 6, 7, 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/mssql_odbc.php
LINE: 149
CALL: dbal_mssql_odbc->sql_error()

FILE: includes/acp/acp_permissions.php
LINE: 1165
CALL: dbal_mssql_odbc->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()

[kaksay]

ayrıca izinler tab'ında "yöneticiler" ve "global moderatörler" linkine tıklayınca da aşağıdakş mesaj geliyor.

Genel Hata
SQL ERROR [ mssql_odbc ]

[Microsoft][ODBC SQL Server Driver][SQL Server]ORDER BY items must appear in the select list if SELECT DISTINCT is specified. [37000]

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 = 0 AND (a.auth_option_id IN (31, 32, 42, 33, 34, 35, 36, 37, 38, 39, 40, 41, 43) OR a.auth_role_id IN (10, 11, 12, 13)) ORDER BY u.username_clean, u.user_regdate ASC

BACKTRACE


FILE: includes/db/mssql_odbc.php
LINE: 149
CALL: dbal_mssql_odbc->sql_error()

FILE: includes/acp/acp_permissions.php
LINE: 1165
CALL: dbal_mssql_odbc->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()