error after successfully install

[Migrated From Jforum.net]

I recieve following exception messages after installation and click "click here to access forum" button. I use tomcat 5 and mysql 5.

Please help me to find out the problem. Thanks!

---------------------------------------------------------------------------------

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:856)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
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

java.lang.NoClassDefFoundError: com/mchange/v2/c3p0/ComboPooledDataSource
net.jforum.C3P0PooledConnection.init(C3P0PooledConnection.java:64)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:75)
net.jforum.JForum.init(JForum.java:93)
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:856)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
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 Anonymous]

[Migrated From Jforum.net]

FYI, the j-forum i download is the latest 2.1.5.
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Ooops, a missing jar. Sorry about that.

I'm updating the package. You can also download the jar file from the attachment below.

[edited]
crap.. Try this link and save as "c3p0-0.9.0.2.jar"
[/edited]

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

[Migrated From Jforum.net]

Thx. That works.

I also found a sql bug during installation. I corrected it by adding the missing "," to the table below. That will fix it.

------------------------------------------------------------------
-- Table structure for table 'jforum_topics_watch'
--

DROP TABLE IF EXISTS jforum_topics_watch;
CREATE TABLE jforum_topics_watch (
topic_id INT NOT NULL,
user_id INT NOT NULL,
is_read tinyint(1) DEFAULT 1,
INDEX idx_topic (topic_id),
INDEX idx_user (user_id)
) TYPE=InnoDB;

[originally posted on jforum.net by rainerblue]

[Migrated From Jforum.net]

Thanks, I fixed all of that and now I'm sending the file to the ftp.

Btw, open your SystemGlobals.properties / jforum-custom.conf and change the value of "database.ping.delay" to "3600".. The correct time should be in seconds, but the first package was using miliseconds.

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

[Migrated From Jforum.net]

Thx for the info.

I love this java forum application. The best in the market. Great work, guys!


[originally posted on jforum.net by rainerblue]

[Migrated From Jforum.net]

By the way, the web application i am building is a local community which have many different locations. The ideal way to apply this forum is to localize the forum too.

Inside my application, each location can be identified by a location id and location type. Is there a way I can configure the forum so that the forum and posts can be seperated by different locations?

For example, the link to the forum now is

http://localhost:8080/community/forums/show/1.page

Can I add location parameters to the url and modify the data retrieving and saving from and to the DB with a location filter?

I don't know how much work it would be in order to achieve that.

Thanks!
[originally posted on jforum.net by rainerblue]

[Migrated From Jforum.net]

Try the following:

http://localhost:8080/community/jforum.page?module=forums&action=list&forum_id=1&lang=fr_FR


It will only work for anonymous users accessing this action, and the settings are then valid for the entire session.

For more information, take a look in the method "list" of the class "ForumAction"

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

[Migrated From Jforum.net]

How can i access the source code? Is jforum an open source software? I couldn't find src in the downloaded zip file. :roll:
[originally posted on jforum.net by rainerblue]

[Migrated From Jforum.net]

Here:

http://sourceforge.net/project/showfiles.php?group_id=15940

There is a package named "JForum-src-2.1.5.zip".

Also, you can always get the source from the CVS

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