ERROR [ForumStartup] Unable to bootstrap JForum repository. Category for forum #1 not found

[Migrated From Jforum.net]

Hi,
I created the database and all the tables (by running mysql_db_struct.sql and mysql_data_dump.sql) by hand as I am not interested in the DB installation page. I configured the user, password dbname and all other fields in SystemGlobals.properties and deployed the WAR file.

Nothing seems to help and it seems that Jforum adds an undocumented jforum-custom.conf to the exploded war directory in case you DO use the "installation" option.

For some reason, I get the folowing error. I am using a simple connection after failing to use the pooled connection (I have reported those errors previously)


14:49:50,053 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.4.GA/server/default/./tmp/deploy/tmp35985jforum-exp.war/WEB-INF/config/database/mysql/mysql.sql
14:49:50,055 INFO [STDOUT] 14:49:50,055 INFO [FileMonitor ] Watching /home/shlomo/Install/jboss-4.0.4.GA/server/default/./tmp/deploy/tmp35985jforum-exp.war/WEB-INF/config/SystemGlobals.properties
14:49:50,055 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.4.GA/server/default/./tmp/deploy/tmp35985jforum-exp.war/WEB-INF/config/SystemGlobals.properties
14:49:50,056 INFO [STDOUT] 14:49:50,055 INFO [FileMonitor ] Watching /home/shlomo/Install/jboss-4.0.4.GA/server/default/./tmp/deploy/tmp35985jforum-exp.war/WEB-INF/config/jforum-custom.conf
14:49:50,055 INFO [FileMonitor] Watching /home/shlomo/Install/jboss-4.0.4.GA/server/default/./tmp/deploy/tmp35985jforum-exp.war/WEB-INF/config/jforum-custom.conf
14:49:50,565 INFO [STDOUT] 14:49:50,564 ERROR [ForumStartup ] Unable to bootstrap JForum repository.
net.jforum.exceptions.CategoryNotFoundException: Category for forum #1 not found
at net.jforum.repository.ForumRepository.loadForums(ForumRepository.java:776)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:113)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:99)
at net.jforum.JForum.init(JForum.java:106)
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.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
14:49:50,564 ERROR [ForumStartup] Unable to bootstrap JForum repository.
net.jforum.exceptions.CategoryNotFoundException: Category for forum #1 not found
at net.jforum.repository.ForumRepository.loadForums(ForumRepository.java:776)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:113)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:99)
at net.jforum.JForum.init(JForum.java:106)
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.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
14:49:50,571 ERROR [[/jforum]] StandardWrapper.Throwable
net.jforum.exceptions.ForumStartupException: Error while starting jforum - net.jforum.exceptions.RepositoryStartupException: Error while trying to start ForumRepository: net.jforum.exceptions.CategoryNotFoundException: Category for forum #1 not found
at net.jforum.repository.ForumRepository.loadForums(ForumRepository.java:776)
at net.jforum.repository.ForumRepository.start(ForumRepository.java:113)
at net.jforum.ForumStartup.startForumRepository(ForumStartup.java:99)
at net.jforum.JForum.init(JForum.java:106)
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.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74)
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.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: net.jforum.exceptions.CategoryNotFoundException: Category for forum #1 not found
... 19 more


[originally posted on jforum.net by shlomo]

[Migrated From Jforum.net]

There seems to be a broken relationship between jforum_forum and jforum_categories.

What are the contents of these tables?

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