Some error on 3.23

[Migrated From Jforum.net]

hi rafael.
dowdnlaoded the patch for 3.23 uploaded to the server and changed the mysql.properties, but i m getting this when i tried to edit Permission in Group. seems like some sql statement not working.

06:41:51,534 INFO [SessionFacade ] Removing session 82BBA12E854F9390B1AF669E8C91BDCB
06:43:45,562 INFO [QueriesFileListener ] Reloading /var/www/html/mykv-com-my/public_html/WEB-INF/config/database/mysql/mysql.sql
06:44:03,585 INFO [SessionFacade ] Removing session 504AB222FE7C079A2977E5D898103DFD
06:44:32,737 ERROR [ExceptionWriter ] 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:585)
at net.jforum.Command.process(Command.java:106)
at net.jforum.view.admin.GroupAction.process(GroupAction.java:209)
at net.jforum.JForum.service(JForum.java:298)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: You have an error in your SQL syntax near 'SELECT role_id FROM jforum_roles WHERE group_id = 1)' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2816)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1518)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1609)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2234)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2159)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1802)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1896)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1821)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1683)
at net.jforum.drivers.generic.security.GroupSecurityModel.deleteAllRoles(GroupSecurityModel.java:70)
at net.jforum.security.PermissionControl.deleteAllRoles(PermissionControl.java:91)
at net.jforum.view.admin.PermissionProcessHelper.init(PermissionProcessHelper.java:191)
at net.jforum.view.admin.PermissionProcessHelper.<init>(PermissionProcessHelper.java:79)
at net.jforum.view.admin.GroupAction.permissionsSave(GroupAction.java:195)
... 34 more

[originally posted on jforum.net by loonyew]

[Migrated From Jforum.net]

Hmm.. try restarting Tomcat.

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

[Migrated From Jforum.net]

ya...tried..in fact i stopped the tomcat before i do upgrade......i retarted the tomcat after done....hehe.....

wat will be the problem ya?
[originally posted on jforum.net by loonyew]

[Migrated From Jforum.net]

i have changed this from the beginning

dao.driver to net.jforum.drivers.mysql.MySQL323DataAccessDriver

read thru the steps before i carrying the changes....coz i scared will crash the forum....so already read thru the steps before i start perform changes....



[originally posted on jforum.net by loonyew]

[Migrated From Jforum.net]

Ok, your steps were:

1) Downloaded the patch from http://www.jforum.net/confluence/display/configuration/MySQL+3.23

2) Unpacked it into your jforum's root dir.

3) Admin Panel -> Groups -> Permissions -> Save

4) Got the error.

that's correct? or there are somethign different?

For me, looks like you didn't do all necessary steps in order to get the patch correctly applied. Your stack trace points to

 at net.jforum.drivers.generic.security.GroupSecurityModel.deleteAllRoles(GroupSecurityModel.java:70)

however, this is the old class. The new one is "MySQL323GroupSecurityDAO". I guess you forgot this step:

....open the file WEB-INF/config/database/mysql/mysql.properties and change the key dao.driver to net.jforum.drivers.mysql.MySQL323DataAccessDriver

take a better read there.

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

[Migrated From Jforum.net]

just curious about something....dont know whether it is right or not....hehe

your MySQL323DataAccessDriver extend net.jforum.drivers.mysql DataAccessDriver

but never overwrite the newGroupSecurityModel() method (coz ur new method in MySQL323DataAccessDriver is newGroupSecurityDAO() ) whihc will return the net.jforum.model.security.GroupSecurityModel instead the new net.jforum.drivers.mysql.security.MySQL323GroupSecurityDAO.

am i right?...hehe...just shotting blindly....hehe

[originally posted on jforum.net by loonyew]

[Migrated From Jforum.net]

hhm... yes, I do.. the code is

public class MySQL323DataAccessDriver extends DataAccessDriver
{
	private static GroupSecurityModel groupSecurityModel = new MySQL323GroupSecurityDAO();
	
	/**
	 * @see net.jforum.dao.DataAccessDriver#newGroupSecurityDAO()
	 */
	public GroupSecurityModel newGroupSecurityDAO()
	{
		return groupSecurityModel;
	}
}

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