my dog learned polymorphism*
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL error when changing grup permission
 
Similar Threads
All New Soft: JForum 2.1.7 with MySQL 5.0.22
Error when trying to change group permissions
permissions exception
MySQL error during config
2.1.5 stable