This week's book giveaway is in the Server-Side JavaScript and NodeJS forum.
We're giving away four copies of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques and have Mario Casciaro & Luciano Mammino on-line!
See this thread for details.
Win a copy of Node.js Design Patterns: Design and implement production-grade Node.js applications using proven patterns and techniques this week in the Server-Side JavaScript and NodeJS forum!
  • 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

Modify Groups->Permissions->save ERROR

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ��ԍ?�]
 
Don't MAKE me come back there with this tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic