I'm trying to save permissions in a group and i clicked the checkbox for attachments:
<!-- BEGIN ERROR STACK TRACE
<br /> java.lang.reflect.InvocationTargetException
<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
<br /> at java.lang.reflect.Method.invoke(Unknown Source)
<br /> at net.jforum.Command.process(Command.java:106)
<br /> at net.jforum.view.admin.GroupAction.process(GroupAction.java:209)
<br /> at net.jforum.JForum.service(JForum.java:298)
<br /> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
<br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
<br /> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
<br /> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
<br /> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
<br /> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
<br /> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
<br /> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
<br /> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
<br /> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825)
<br /> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:743)
<br /> at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
<br /> at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
<br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
<br /> at java.lang.Thread.run(Unknown Source)
<br /> Caused by: java.sql.SQLException: 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
<br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2816)
<br /> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1518)
<br /> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1609)
<br /> at com.mysql.jdbc.Connection.execSQL(Connection.java:2234)
<br /> at com.mysql.jdbc.Connection.execSQL(Connection.java:2159)
<br /> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1802)
<br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1896)
<br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1821)
<br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1683)
<br /> at net.jforum.drivers.generic.security.UserSecurityModel.deleteUserRoleByGroup(UserSecurityModel.java:126)
<br /> at net.jforum.view.admin.PermissionProcessHelper.processData(PermissionProcessHelper.java:122)
<br /> at net.jforum.view.admin.GroupAction.permissionsSave(GroupAction.java:195)
<br /> ... 22 more
<br />
<br /> END ERROR STACK TRACE--> [originally posted on jforum.net by Anonymous]
I'm having a similar problem after a fresh installation of jforum214. I'm on debian/jetty/mysql3.23.49. I get the sql syntax error message when clicking the save button on a group permission page.
As you suggested to Anonymous, I am attaching my mysql.sql file.
The relevant portion of my stack trace looks like this
Caused by: java.sql.SQLException: You have an error in your SQL syntax near 'jforum_role_values FROM jforum_role_values rv, jforum_roles r WHERE r.role_id = ' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2816)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1518)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1609)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2234)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2159)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1802)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1896)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1821)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1683)
at net.jforum.drivers.generic.security.GroupSecurityModel.deleteAllRoles(GroupSecurityModel.java:70)
at net.jforum.security.PermissionControl.deleteAllRoles(PermissionControl.java:91)
at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:191)
at net.jforum.view.admin.PermissionProcessHelper.<init>(PermissionProcessHelper.java:79)
at net.jforum.view.admin.GroupAction.permissionsSave(GroupAction.java:195) [originally posted on jforum.net by guyhillyer]
Thinking this might be a jdbc driver problem, I tried replacing the mysq-connect-java-3.1.4-beta-bin.jar with mysql-connector-java-3.0.15-ga-bin.jar, with the same result. I'm mystified, what do you think is going on?
-- Guy [originally posted on jforum.net by guyhillyer]
Hard to say. I can suggest you to use a debugger ( I use Eclipse's one) and put a breakpoint at
then watch the SQL query that will be executed. The error description looks like some problem with the SLQ's .properties file - I mean, if there are some missing "\" OR a blank space after it, the java properties parser gets confused.
Have you tried downloading the package again and replacing the .sql files?
Rafael [originally posted on jforum.net by Rafael Steil]