• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Modify Groups->Permissions->save ERROR

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ok

[originally posted on jforum.net by ��ԍ?�]
 
Migrated From Jforum.net
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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 ��ԍ?�]
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!