Migrated From Jforum.net

Hello
are you still considering to make this feature available?
That would make life of mobile users easier (and cheaper)

Tnx
Beppe
[originally posted on jforum.net by gcatanese]

This bit me as well.

BTW of the two possible solutions for this:
1. This one - https://coderanch.com/t/578196 #19543,
2. This one - http://www.andowson.com/trac/jforum/ticket/6

The first one is way faster in all of my testing but it looks like the second solution is "preferred." Any idea why?

I've also found a secondary bug which is that if your first topic_id is > 50 then reindexing fails unless you set the start_Id as 50. The reason is because the code looks for posts in batches of 50. If the first one (1-50) returns no rows is exits without indicating a problem. Fix would be to change the firstPostId such that it gets the min ID from the jforum_topics table and if the number is higher than the user provided one uses that number.
[originally posted on jforum.net by chhum]

Habr� que hacerle seguimiento a los cambios de una versi�n a otra, utilizando un comparador de archivos... para ver que no quede faltando algo por traducir... esto en cuanto al cambio de versiones, yo comenc� desde la 2.1.7 pero no s� que cambios se habr�n hecho en la 2.1.8.

Por otro lado me parece bien que se haya hecho las adecuaciones en cuanto a las palabras acentuadas, para que puedan ser presentadas seg�n el equipo (estaci�n de trabajo) en que se ejecuten.
No s� si hayan encontrado cambios que realizar adicionales a la palabra "favor" por la frase "por favor" espero que no...

De todas maneras estos cambios requieren de tiempo.

Espero que las traducciones que hagamos en este tema (hilo) sean incluidas en las publicaciones generales, de tal forma que vengan dentro del paquete de instalaci�n.

Saludos,

Y les agradezco por colaborar tambi�n.

[originally posted on jforum.net by joseluisbz]

I see this post https://coderanch.com/t/578473

THen, i add to SessionFacade my personal method:
public static void setUserLang(Locale lang){ getUserSession().setLang(lang.getLanguage()); }

And i try to get my set Language in my webapp Spring context in services method of JForum class.

... context.put("logged", SessionFacade.isLogged()); /* MY CODE */ // Actualiza lenguaje del usuario. if (SessionFacade.getUserSession() != null) { Locale lang = RequestContextUtils.getLocaleResolver(req).resolveLocale(req); SessionFacade.setUserLang(lang); } /* END MY CODE */ // Process security data SecurityRepository.load(SessionFacade.getUserSession().getUserId()); ...

But say me one NullPointerException error, Why?, How i can fix?. is why my webapp Spring context is not possible to access from JForum?, if is possible... how?

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

Hi,
I have installed jforum but I can view forums only when i am logged in.
For example in this forum I can read posts without logging in. I could not find this option.
How can i make my forums public. No login needs to read posts or view forums
[originally posted on jforum.net by bisanthe]

Hi, i have integrated JForum in my webapp, I create and edit users out of JForum, and all found ok, but i want know how i can change Locale value in real time, to user do click in JForum link and JForum appear in the previus select language. Now i change lenguage value in DB, and if user change it, and restart web browser (restart session web browser) JForum appear in new language. but i want can change the Locale value IN SAME SESSION.

Somebody can help me?, thanks!
[originally posted on jforum.net by MiLLeN]

Hi all,

I am having problems install jforum on godaddy. I have the delux linux hosting plan at godaddy. Every time I try http://mydomain.com/jforum/install.jsp

it asks me to either save the file content or open it. if i open it, I would get "<jsp:forward page="install/install.page?module=install&action=welcome"/>"

What am I doing wrong here? Please advise.

Many Thanks
[originally posted on jforum.net by devman]

Hello,

Did you finally manage to install JForum on JBoss 5?
I am facing the same problem with version conflict on Xerces library.
I would appreciate if you can post a final solution to this problem.

Thx
[originally posted on jforum.net by mpiasecki]

Ok,

So I have configured jforum to use JBoss Cache Engine class instead of Default Cache Engine. In jboss-cluster-cache.xml file, I have set the loopback attribute to true as am running on Windows machine.

Please can any one help out with the configurations required in jboss-cluster-cache-xml file. The problem I am having is that the changes are getting saved/updated in database but are not being reflected back in the application, no matter from which server it is accessed.

The changes are reflected once I restart tomcat server.

Please help,

Thanks in advance,

Muzammil
[originally posted on jforum.net by muzammil]

hi all from Spain!

This is my first post, I've been 'playing' with JForum and I would like to know if its posible to read/display attachment files (specifically pictures) from an external folder.

SITUATION
aplication directory: /opt/websphere/forum
attachment directory: /data/upload

After puting this in SystemGlobals.properties,
# Directory to store the files attachments.upload.dir = /data/upload attachments.store.dir = ${attachments.upload.dir}
I managed to store the files in the desired directory but pictures are not displayed when read

Seeing the source code of the webpage:
<img " border="0"/>

I don't think this problem is related with privilegues because if I click on the download link I get any file succesfully, even pictures.

Anyone knows how can I fix this?

Thanks in advance


[originally posted on jforum.net by karlox]

Hello Everyone,

Could anyone plz tell me how to configure Jforum with the Apache Tomcat 6?

I have installed the apache tomcat and then unzip the Jforum file and copied it to the directory named "C:\Apache\webapps" (If I am not mistaken this is what was suppose to be done) and then I startup the Apache Tomcat server and wrote "http://localhost:8080/Jforum" in the web browser but it didn't work. I get the following page on my browser, please help me to correct this or give me step by step instructions to register the JForum application within Tomcat:

-----------------------------------------------------
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:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


root cause

net.jforum.exceptions.DatabaseException: Error while trying to start the database: net.jforum.exceptions.DatabaseException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:46
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:7
net.jforum.JForum.init(JForum.java:95)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


root cause

net.jforum.exceptions.DatabaseException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:46
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:7
net.jforum.JForum.init(JForum.java:95)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


root cause

java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:46
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:7
net.jforum.JForum.init(JForum.java:95)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


root cause

com.mchange.v2.resourcepool.TimeoutException: The pool timed out while waiting to acquire a resource -- timeout at awaitAvailable()
com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1157)
com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:405)
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:351)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:466)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:7
net.jforum.JForum.init(JForum.java:95)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.20 logs.


------------------------------------
[originally posted on jforum.net by deepakarora01]

Hello Everyone,

Could anyone plz tell me how to configure Jforum with the Apache Tomcat 6?

I have installed the apache tomcat and then unzip the Jforum file and copied it to the directory named "C:\Apache\webapps" (If I am not mistaken this is what was suppose to be done) and then I startup the Apache Tomcat server and wrote "http://localhost:8080/Jforum" in the web browser but it didn't work. I get the following page on my browser, please help me to correct this or give me step by step instructions to register the JForum application within Tomcat:

-----------------------------------------------------
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:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


root cause

net.jforum.exceptions.DatabaseException: Error while trying to start the database: net.jforum.exceptions.DatabaseException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:468)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:78)
net.jforum.JForum.init(JForum.java:95)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


root cause

net.jforum.exceptions.DatabaseException: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:468)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:78)
net.jforum.JForum.init(JForum.java:95)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


root cause

java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:468)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:78)
net.jforum.JForum.init(JForum.java:95)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


root cause

com.mchange.v2.resourcepool.TimeoutException: The pool timed out while waiting to acquire a resource -- timeout at awaitAvailable()
com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1157)
com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:405)
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:351)
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:466)
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:125)
net.jforum.C3P0PooledConnection.getConnection(C3P0PooledConnection.java:137)
net.jforum.ForumStartup.startDatabase(ForumStartup.java:78)
net.jforum.JForum.init(JForum.java:95)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849)
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454)
java.lang.Thread.run(Thread.java:619)


note The full stack trace of the root cause is available in the Apache Tomcat/6.0.20 logs.


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

Apache Tomcat/6.0.20
[originally posted on jforum.net by deepakarora01]

Hi!

I'm a Java programmer (since 1.0.2) with a few years of Hibernate experience. Version 3 sounds like something I'd find useful, and I'd like to see if I can help with it. I've requested Observer status on java.net (user leifbennett).

Leif Bennett
[originally posted on jforum.net by leifbennett]

Testing
[originally posted on jforum.net by anver]

Here is a hack for anyone in a similar situation.
I tried to change as little as I can.

The line numbers might not match with 2.1.7 vanilla because I made some other changes.
So if a patch run fails, then try editing manually or match the line numbers in the diff below to your real line numbers.

Index: src/net/jforum/dao/generic/GenericAttachmentDAO.java =================================================================== --- src/net/jforum/dao/generic/GenericAttachmentDAO.java (revision 3083) +++ src/net/jforum/dao/generic/GenericAttachmentDAO.java (working copy) @@ -42,6 +42,7 @@ */ package net.jforum.dao.generic; +import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.Timestamp; @@ -405,7 +406,8 @@ String sql = SystemGlobals.getSql("AttachmentModel.selectExtension"); sql = sql.replaceAll("\\$field", paramName); - PreparedStatement p = JForumExecutionContext.getConnection().prepareStatement(sql); + Connection conn=JForumExecutionContext.getConnectionForDownloadAttach(); + PreparedStatement p = conn.prepareStatement(sql); p.setObject(1, paramValue); AttachmentExtension e = new AttachmentExtension(); @@ -420,6 +422,7 @@ rs.close(); p.close(); + JForumExecutionContext.releaseConnectionForDownloadAttach(conn); return e; } @@ -519,13 +522,15 @@ */ public void updateAttachment(Attachment a) throws Exception { - PreparedStatement p = JForumExecutionContext.getConnection().prepareStatement( + Connection conn=JForumExecutionContext.getConnectionForDownloadAttach(); + PreparedStatement p = conn.prepareStatement( SystemGlobals.getSql("AttachmentModel.updateAttachment")); p.setString(1, a.getInfo().getComment()); p.setInt(2, a.getInfo().getDownloadCount()); p.setInt(3, a.getId()); p.executeUpdate(); p.close(); + JForumExecutionContext.releaseConnectionForDownloadAttach(conn); } /** @@ -576,7 +581,8 @@ { Attachment e = null; - PreparedStatement p = JForumExecutionContext.getConnection().prepareStatement( + Connection conn=JForumExecutionContext.getConnectionForDownloadAttach(); + PreparedStatement p = conn.prepareStatement( SystemGlobals.getSql("AttachmentModel.selectAttachmentById")); p.setInt(1, attachId); @@ -587,6 +593,7 @@ rs.close(); p.close(); + JForumExecutionContext.releaseConnectionForDownloadAttach(conn); return e; } @@ -594,8 +601,9 @@ public boolean isPhysicalDownloadMode(int extensionGroupId) throws Exception { boolean result = true; + Connection conn=JForumExecutionContext.getConnectionForDownloadAttach(); - PreparedStatement p = JForumExecutionContext.getConnection().prepareStatement( + PreparedStatement p = conn.prepareStatement( SystemGlobals.getSql("AttachmentModel.isPhysicalDownloadMode")); p.setInt(1, extensionGroupId); @@ -608,6 +616,7 @@ rs.close(); p.close(); + JForumExecutionContext.releaseConnectionForDownloadAttach(conn); return result; } Index: src/net/jforum/JForumExecutionContext.java =================================================================== --- src/net/jforum/JForumExecutionContext.java (revision 3083) +++ src/net/jforum/JForumExecutionContext.java (working copy) @@ -169,7 +169,17 @@ return c; } + + public static Connection getConnectionForDownloadAttach() + { + return DBConnection.getImplementation().getConnection(); + } + public static void releaseConnectionForDownloadAttach(Connection conn) + { + DBConnection.getImplementation().releaseConnection(conn); + } + /** * Sets a request to the execution context. * @param request The request to set
[originally posted on jforum.net by bcc]