Modify Groups->Permissions->save ERROR

[Migrated From Jforum.net]

Hi,
I want change use Forum Admin ->Group-> Permissions -> Save., but can't save.

INFO:

An error has occurred.
For detailed error information, please see the HTML source code, and contact the forum Administrator.
Unknown table 'jforum_role_values' in MULTI DELETE


<!-- BEGIN ERROR STACK TRACE <br /> net.jforum.exceptions.ForumException: 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:585) <br /> at net.jforum.Command.process(Command.java:118) <br /> at net.jforum.view.admin.AdminCommand.process(AdminCommand.java:61) <br /> at net.jforum.JForum.service(JForum.java:191) <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 net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59) <br /> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) <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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) <br /> at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) <br /> at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:744) <br /> at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:674) <br /> at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:866) <br /> at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) <br /> at java.lang.Thread.run(Thread.java:595) <br /> Caused by: java.lang.reflect.InvocationTargetException <br /> ... 26 more <br /> Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Unknown table 'jforum_role_values' in MULTI DELETE <br /> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) <br /> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) <br /> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) <br /> at com.mysql.jdbc.Connection.execSQL(Connection.java:2994) <br /> at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936) <br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166) <br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082) <br /> at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067) <br /> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) <br /> at net.jforum.dao.generic.security.GenericGroupSecurityDAO.deleteAllRoles(GenericGroupSecurityDAO.java:83) <br /> at net.jforum.security.PermissionControl.deleteAllRoles(PermissionControl.java:87) <br /> at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:151) <br /> at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:71) <br /> at net.jforum.view.admin.GroupAction.permissionsSave(GroupAction.java:198) <br /> ... 26 more <br /> Caused by: java.sql.SQLException: Unknown table 'jforum_role_values' in MULTI DELETE <br /> ... 40 more <br /> <br /> [originally posted on jforum.net by ��ԍ?�]

[Migrated From Jforum.net]

What version of MySQL are you using? Have you recently done any JForum updates, or is this a new install? The error message says it can't find the "jforum_role_values'" table .. does it exist in the DB?
[originally posted on jforum.net by GatorBait3]

[Migrated From Jforum.net]

GatorBait3 wrote:What version of MySQL are you using? Have you recently done any JForum updates, or is this a new install? The error message says it can't find the "jforum_role_values'" table .. does it exist in the DB?

1)mysql version: mysql-max-5.0.22-freebsd6.0-i386
jforum version�??2.1.7
2)new install
3)use mysqlclient can select "jforum_role_values" data.
:?:
[originally posted on jforum.net by ��ԍ?�]

[Migrated From Jforum.net]

Please report this error in our bug tracker - http://www.jforum.net/jira

I had only saw this bug on mysql 3.2.23, but...

Rafael
[originally posted on jforum.net by Rafael Steil]

[Migrated From Jforum.net]

ok

[originally posted on jforum.net by ��ԍ?�]

[Migrated From Jforum.net]

Using mysql 4.1.18 and jforums 2.1.17 from CVS.

In WEB-INF/config/database/mysql/, mysql_40.sql and mysql.sql both contain versions of PermissionControl.deleteAllRoleValues that are the same, which is where this bug comes from.

I didn't bother figuring out which was being pulled for the permission query, I just fixed them both. No idea if this will work for everyone, but it worked on my system.

Change the query from

DELETE jforum_role_values FROM jforum_role_values rv, jforum_roles r WHERE r.role_id = rv.role_id AND r.group_id = ?

to

DELETE jforum_role_values FROM jforum_role_values, jforum_roles WHERE jforum_roles.role_id = jforum_role_values.role_id AND jforum_roles.group_id = ?

Removing the table aliasing allowed mysql 4 to find the tables on my system.

Tommy
[originally posted on jforum.net by tommy]

[Migrated From Jforum.net]

tommy wrote:Using mysql 4.1.18 and jforums 2.1.17 from CVS.

In WEB-INF/config/database/mysql/, mysql_40.sql and mysql.sql both ......
Tommy

Thanks
[originally posted on jforum.net by ��ԍ?�]