Unable to bootstrap JForum repository

[Migrated From Jforum.net]

Ooops, the database is empty, that's why.

First I did a copy past of mysql_db_struct.sql into mysql editor and it worked. But after I re-create my database I've used the mysql "source mysql_db_struct.sql" command to execute the script and I've realized that it didn't work. The database was empty and that's why I got the error message.
[originally posted on jforum.net by agoncal]

[Migrated From Jforum.net]

Hi, I'm using Tomcat 5.5.20, MySQL 5.0.27 and JForum 2.1.7-b3.

I've followed the installation instructions of http://www.jforum.net/install_no_wizard.jsp to install manually JForum. Once everything is done I tried to access it but here is the exception I get :

16:42:23,296 ERROR [ForumStartup        ] Unable to bootstrap JForum repository.
net.jforum.exceptions.DatabaseException: java.sql.SQLException: Illegal operation on empty result set.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
        at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:685)
        at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5487)
        at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5431)
        at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5447)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
        at net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:577)
        at net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:772)
        at net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
        at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
        at net.jforum.JForum.init(JForum.java:114)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
        at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:757)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:130)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Illegal operation on empty result set.
        ... 25 more
net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Illegal operation on empty result set.
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
        at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:685)
        at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5487)
        at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5431)
        at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5447)
        at com.mchange.v2.c3p0.impl.NewProxyResultSet.getString(NewProxyResultSet.java:3342)
        at net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:577)
        at net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:772)
        at net.jforum.repository.ForumRepository.start(ForumRepository.java:131)
        at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
        at net.jforum.JForum.init(JForum.java:114)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
        at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:757)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:130)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: Illegal operation on empty result set.
        ... 25 more
Caused by: java.sql.SQLException: Illegal operation on empty result set.
        ... 25 more

I'm using PooledConnection but I have the same problem with SimpleConnection. Any idea ?

Thanks,

Antonio
[originally posted on jforum.net by agoncal]