posted 18 years ago
Hi,
I am trying to edit group permissions and am running into mysql exception
Unknown table 'jforum_role_values' in MULTI DELETE
I have check the database and there is a table called jforum_role_values and it has quite a data in it.
I did a manual install and am using mysql 4.1 as db server.
thanks,
Rashmi
-- stack trace is
<!-- BEGIN ERROR STACK TRACE
<br /> java.lang.reflect.InvocationTargetException
<br /> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
<br /> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
<br /> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
<br /> at java.lang.reflect.Method.invoke(Method.java:324)
<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:856)
<br /> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
<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(Thread.java:534)
<br /> Caused by: java.sql.SQLException: Unknown table 'jforum_role_values' in MULTI DELETE
<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.GroupSecurityModel.deleteAllRoles(GroupSecurityModel.java:70)
<br /> at net.jforum.security.PermissionControl.deleteAllRoles(PermissionControl.java:91)
<br /> at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:191)
<br /> at net.jforum.view.admin.PermissionProcessHelper.<init>(PermissionProcessHelper.java:79)
<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]
