problem posting in forums

[djbeenie]

No one can post anything. It even says I do not have permission to post and I am the admistrator.

[KevC]

Have you set the permissions to post?

[djbeenie]

I am getting this error when I try to give admin permissions to all forums.

Code: Select all

SQL ERROR [ mssql ]

Incorrect syntax near the keyword 'ESCAPE'.
Incorrect syntax near the keyword '%.*ls'. [156]

SQL

SELECT a.group_id, ao.auth_option, a.forum_id, a.auth_setting, a.auth_role_id, r.auth_setting as role_auth_setting FROM phpbb_acl_options ao, phpbb_acl_groups a LEFT JOIN phpbb_acl_roles_data r ON (a.auth_role_id = r.role_id) WHERE (ao.auth_option_id = a.auth_option_id OR ao.auth_option_id = r.auth_option_id) AND a.group_id = 5 AND a.forum_id IN (3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17) AND ao.auth_option LIKE 'f\_%' ORDER BY a.forum_id, ao.auth_option ESCAPE '\'

BACKTRACE


FILE: includes/db/mssql.php
LINE: 129
CALL: dbal->sql_error()

FILE: includes/auth.php
LINE: 677
CALL: dbal_mssql->sql_query()

FILE: includes/acp/auth.php
LINE: 104
CALL: auth->acl_group_raw_data()

FILE: includes/acp/acp_permissions.php
LINE: 464
CALL: auth_admin->get_mask()

FILE: includes/functions_module.php
LINE: 361
CALL: acp_permissions->main()

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

[karlake]

Got this when trying to register as a user:

SQL ERROR [ mssql_odbc ]

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'ESCAPE'. [37000]

SQL

SELECT a.group_id, ao.auth_option, a.forum_id, a.auth_setting, a.auth_role_id, r.auth_setting as role_auth_setting FROM phpbb_acl_options ao, phpbb_acl_groups a LEFT JOIN phpbb_acl_roles_data r ON (a.auth_role_id = r.role_id) WHERE (ao.auth_option_id = a.auth_option_id OR ao.auth_option_id = r.auth_option_id) AND a.group_id = '2' AND a.forum_id IN ('1', '2') AND ao.auth_option LIKE 'f\_%' ORDER BY a.forum_id, ao.auth_option ESCAPE '\'

BACKTRACE

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

FILE: includes/auth.php
LINE: 677
CALL: dbal_mssql_odbc->sql_query()

FILE: includes/acp/auth.php
LINE: 104
CALL: auth_admin->acl_group_raw_data()

FILE: includes/acp/acp_permissions.php
LINE: 464
CALL: auth_admin->get_mask()

FILE: includes/functions_module.php
LINE: 361
CALL: acp_permissions->main()

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

[Acyd Burn]

Please submit such things to the bug tracker.

[djbeenie]

Added!

http://www.phpbb.com/bugs/viewreport.php?b=5388