Win a copy of Svelte and Sapper in Action this week in the JavaScript 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 all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

Database Error

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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]
 
It is no measure of health to be well adjusted to a profoundly sick society. -Krishnamurti Tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic