Error saving group permissions

[Migrated From Jforum.net]

Hello,
I'm running JForum 2.1.4 and I get the following error when I try to save group permissions:

An error has ocurred. For detailed stack trace, please see the page's source code.

Unknown table 'jforum_role_values' in MULTI DELETE

The table does exist so I don't know where the problem lies.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

I'm guessing you are using MySQL 4.1. I had the same problem ;)
Copy the sql file for 4.1 (mysql4.1.sql or something like that) over the normal one (mysql.sql) in the WEB-INF/config/database/mysql directory.
[originally posted on jforum.net by mortis__rigor]

[Migrated From Jforum.net]

Thanks that worked, BUT I had to add the following to the new mysql.sql (ie the mysql4_1.sql):

PermissionControl.deleteAllRoleValues = DELETE rv \
	FROM jforum_role_values rv, jforum_roles r \
	WHERE r.role_id = rv.role_id \
	AND r.group_id = ?

After adding that entry it worked as expected
[originally posted on jforum.net by Anonymous]