problem posting in forums

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
djbeenie
Registered User
Posts: 48
Joined: Tue Nov 14, 2006 12:29 pm

problem posting in forums

Post by djbeenie »

No one can post anything. It even says I do not have permission to post and I am the admistrator.
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70432
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Post by KevC »

Have you set the permissions to post?
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
djbeenie
Registered User
Posts: 48
Joined: Tue Nov 14, 2006 12:29 pm

Post by 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
Registered User
Posts: 12
Joined: Sun Jan 04, 2004 5:13 pm

Post by 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
Consultant
Consultant
Posts: 5830
Joined: Wed Dec 05, 2001 8:31 pm
Location: Behind You
Name: Meik Sievertsen

Post by Acyd Burn »

Please submit such things to the bug tracker. :)
djbeenie
Registered User
Posts: 48
Joined: Tue Nov 14, 2006 12:29 pm

Post by djbeenie »

Locked

Return to “[3.0.x] Support Forum”