SQL error when changing grup permission

[Migrated From Jforum.net]

When I make a change of a group permission, i get the following message (on Linux/Mysql 3.23.58, but not on Windows/Mysql 4.0.20):

java.lang.reflect.InvocationTargetException: Syntax error or access violation message from server: "You have an error in your SQL syntax near 'jforum_roles FROM jforum_roles r, jforum_user_groups ug WHERE ug.user_id = r.use' at line 1"

The problem occurs when I select 'Set Users' Role to follow'.

I have no idea why.

Cheers,
Per

[originally posted on jforum.net by per]

[Migrated From Jforum.net]

Hm, looks like an sql statement which is in the .sql file. This is likely to happen when, for some typing error when creating the instruction ( by the developer ), a "\" is forgoten or there is a blank space after it.

I'll take a look in this error on my development version.

Rafael
[originally posted on jforum.net by Rafael Steil]