Group Permission Control

[Migrated From Jforum.net]

Hi Rafael

when i choose GPC and i click "Save" button, I have got an error page...

java.lang.reflect.InvocationTargetException: Base table or view not found message from server: "Unknown table 'jforum_roles' in MULTI DELETE"

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Huh?!

If this table is not found, then you ever won't be able to log in / start the forum .. That's strange.. Which database ( plus version ) are you using?

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

[Migrated From Jforum.net]

I'm using MySQL 4.1 and i 'd like ask a question: When I post in Private Messages, "Find User" function not avaiable...

Please help me

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Anonymous wrote:I'm using MySQL 4.1 and i 'd like ask a question: When I post in Private Messages, "Find User" function not avaiable...

Please help me

The 2.0 package was released with a bug in this fuction. It is a little javascript error that causes the window to not open.

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

[Migrated From Jforum.net]

GPC??? :?:
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Anonymous wrote:GPC??? :?:

I suggest that you register and post under a username instead of remaining as anonymous. So that we knows it is the same person 8)

Besides the above mentioned error message, can you also post any error message logged in the logs folder of Tomcat folder.

[originally posted on jforum.net by jamesyong]

[Migrated From Jforum.net]

sorry!
Mynick is newmember.

There are not errors message logged in the logs folder of Tomcat's folder. :!:

2004-11-29 13:45:54 StandardHost[localhost]: Installing web application at context path /webdav from URL file:C:\tomcat\webapps\webdav
2004-11-29 13:45:54 WebappLoader[/webdav]: Deploying class repositories to work directory C:\tomcat\work\Standalone\localhost\webdav
2004-11-29 13:45:54 StandardManager[/webdav]: Seeding random number generator class java.security.SecureRandom
2004-11-29 13:45:54 StandardManager[/webdav]: Seeding of random number generator has been completed
2004-11-29 13:45:54 StandardWrapper[/webdav:default]: Loading container servlet default
2004-11-29 13:45:54 StandardWrapper[/webdav:invoker]: Loading container servlet invoker

This is Tomcat's errors.

13:38:36,078 ERROR [ForumException      ] java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:324)
        at net.jforum.Command.process(Command.java:88)
        at net.jforum.view.admin.GroupAction.process(GroupAction.java:208)
        at net.jforum.JForum.service(JForum.java:262)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.j
ava:247)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)

        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:643)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:643)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2422)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:643)
        at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:641)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:163)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:641)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
        at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Standar
dPipeline.java:643)
        at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
        at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
        at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:199)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11P
rotocol.java:700)
        at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
        at java.lang.Thread.run(Thread.java:536)
Caused by: java.sql.SQLException: Base table or view not found message from server: "Unknown table '
jforum_roles' in MULTI DELETE"
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2247)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1772)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1619)
        at net.jforum.drivers.generic.security.UserSecurityModel.deleteUserRoleByGroup(UserSecurityM
odel.java:124)
        at net.jforum.view.admin.PermissionProcessHelper.processData(PermissionProcessHelper.java:10
2)
        at net.jforum.view.admin.GroupAction.permissionsSave(GroupAction.java:190)
        ... 37 more

[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

help me!!! :?:
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

help me
[originally posted on jforum.net by newmember]

[Migrated From Jforum.net]

Reinstall JForum using the manual steps, as described at http://www.jforum.net/install_no_wizard.htm

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

[Migrated From Jforum.net]

Anonymous wrote:Hi Rafael

when i choose GPC and i click "Save" button, I have got an error page...

java.lang.reflect.InvocationTargetException: Base table or view not found message from server: "Unknown table 'jforum_roles' in MULTI DELETE"

I've found out the way to fix this bug. If you are using MySQL then read the article http://dev.mysql.com/doc/mysql/en/Upgrading-from-4.0.html section SQL Changes:

When using multiple-table DELETE statements, you should use the alias of the tables from which you want to delete, not the actual table name. For example, instead of doing this: DELETE test FROM test AS t1, test2 WHERE ...

Do this: DELETE t1 FROM test AS t1, test2 WHERE ...

This corrects a problem that was present in MySQL 4.0.

So I had to edit all statements in /config/database/mysql/mysql.sql file in order to use new syntax.

Regards,
gvp
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Fucking mysql

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