Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL error when changing grup permission

 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic