Database Error

[Migrated From Jforum.net]

Today when I tried to start the forum I got the following error. Its like it can't connect to my MySQL database, the forum has been running fine for months now. Does it have something to do with my MySQL setup. Site is down as of right now, let me know.

______________________________________________________
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Servlet.init() for servlet jforum threw exception
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Unknown Source)


root cause

net.jforum.exceptions.ForumStartupException: Error while starting jforum - net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: java.sql.SQLException: Illegal operation on empty result set.
at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
at com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5021)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:4999)
at com.mysql.jdbc.ResultSet.getString(ResultSet.java:5015)
at net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:447)
at net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:813)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:133)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
at net.jforum.JForum.init(JForum.java:109)
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(Unknown Source)
Caused by: java.sql.SQLException: Illegal operation on empty result set.
... 23 more

com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:5021)
com.mysql.jdbc.ResultSet.getString(ResultSet.java:4999)
com.mysql.jdbc.ResultSet.getString(ResultSet.java:5015)
net.jforum.dao.generic.GenericUserDAO.getLastUserInfo(GenericUserDAO.java:447)
net.jforum.repository.ForumRepository.loadUsersInfo(ForumRepository.java:813)
net.jforum.repository.ForumRepository.start(ForumRepository.java:133)
net.jforum.ForumStartup.startForumRepository(ForumStartup.java:100)
net.jforum.JForum.init(JForum.java:109)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Unknown Source)


[originally posted on jforum.net by TheOne]

[Migrated From Jforum.net]

Hard to say exactly why this is happening. Are you able to upgrade to version 2.1.8?

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

[Migrated From Jforum.net]

I tried to test with a new Database with JForum-2.1.8... I get the following error when I try to populate the tables. Ive looked online for what this means but didnt find anything very helpful. Any ideas ??

Got error -1 from storage engine

Query being executed when exception was thrown:

INSERT INTO jforum_groups ( group_id, group_name, group_description ) VALUES (@GENERAL_GROUP_ID, 'General', 'General Users')
INSERT INTO jforum_groups ( group_id, group_name, group_description ) VALUES (@GENERAL_GROUP_ID, 'General', 'General Users')
[originally posted on jforum.net by TheOne]

[Migrated From Jforum.net]

To be honest, I only used the "update" sql script for 2.1.8 to update it from 2.1.7

but actually those always worked fine for me so far.

For using mysql you simply have to use the following command

mysql -u jforumdatabaseusername -p jforumdatabasename < createscript.sql

something of that like. copying the content into the query window of MySQLQuery may cause different bahaviour on execution maybe. Or maybe there's a flaw in the script.

Updating 2.17 to 2.18 was error free for mysql - that I can guarantee ^^
[originally posted on jforum.net by Sid]