Eroare Cand Creez un Nou Forum Sau Categorie.
Scris: 10-Iul-2008, 09:38:13
Imi Da eroarea asta cand creez un nou forum sau o noua categorie .dc ??din admin panel bine inteles.
General Error
SQL ERROR [ mssql ]
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified. [145]
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 = 1 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.php
LINE: 137
CALL: dbal_mssql->sql_error()
FILE: includes/acp/acp_permissions.php
LINE: 1165
CALL: dbal_mssql->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()
Please notify the board administrator or webmaster: marius_boss_piratu@yahoo.com
please help me.
General Error
SQL ERROR [ mssql ]
ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified. [145]
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 = 1 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.php
LINE: 137
CALL: dbal_mssql->sql_error()
FILE: includes/acp/acp_permissions.php
LINE: 1165
CALL: dbal_mssql->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()
Please notify the board administrator or webmaster: marius_boss_piratu@yahoo.com
please help me.