group permission can't be changed

[Migrated From Jforum.net]

Hi guys,

Running latest from CVS, MySQL 4.1.4.

The problem is in the PermissionControl.deleteAllRoleValues statement. Replaced it with DELETE FROM jforum_role_values where role_id in (select r.role_id from jforum_roles r where r.group_id = ?). Works ok.

Thanks.
[originally posted on jforum.net by rkhaskin]

[Migrated From Jforum.net]

Same problem for me, but off the disted version. It seems like the SQL has one extra parentheses at the end of the line.


An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT role_id FROM jforum_roles WHERE group_id = 6)' at line 1



[originally posted on jforum.net by flannelboy]