GeeCON Prague 2014*
The moose likes JForum and the fly likes SQL error when changing grup permission Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Products » JForum
Bookmark "SQL error when changing grup permission" Watch "SQL error when changing grup permission" New topic
Author

SQL error when changing grup permission

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
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]
 
GeeCON Prague 2014
 
subject: SQL error when changing grup permission