rafaelsteil / jforum2 Goto Github PK

View Code? Open in Web Editor NEW

53.0 53.0 48.0 24.68 MB

JForum 2.x series. Please see the README

Home Page: http://jforum.net

License: Other

JavaScript 2.95% Java 71.06% HTML 11.99% PLSQL 1.59% FreeMarker 0.60% CSS 2.50% TSQL 9.26% Batchfile 0.02% Shell 0.01%

jforum2's People

Contributors

Stargazers

Watchers

Forkers

ramilani12 sutra lixinso guorouda asutos mikele biliroy dalockr webdevwilson shucb wendaoke avec112 iwaterman amaurel chentest2013 jskyme davidding1994 wenjwen yeahestherchan jack84888 alexguo88 yuchueh supernow jackyshi3333 visenwang wenhulove333 acseed mathter jackjiao6 dtpanda caokaifeng liudianpeng aihua wj86 ws-os ws-apps ws-development ws-java ws-tools guoyu07 stacktim rzs840707 vijayeluri lxuds hzmartin freshwlnd liuhongchen middlewayexplorer

jforum2's Issues

Jforum - utf-8 database problem

Dear Jforum Team,
afterr installing jforum 2.1.8 in an Ubuntu/Tomcat/mySQL machine, a problem arised with greek characters in forum posts.

During the installation process, all the encoding configuration (mySQL database, jforum) has been specified as utf-8.

Any help will be welcomed.

Support Documentation missing from site

Hello -

Before your site redesign, there was a section of the site containing examples and documentation for UI customization and for the SSO integration, and many other topics. I cannot find these documents on the new site. Can you please repost these items or tell me where I can view them? Thanks

SQL Exceptions using PostgreSQL in 2.1.9

There are three SQL Exceptions in 2.1.9 when using Postgres. I have suggested fixes for each

net/jforum/dao/generic/GenericForumDao.java:

/**
 * @see net.jforum.dao.ForumDAO#getModeratorList(int)
 */
public List getModeratorList(int forumId)
{
    List l = new ArrayList();

    PreparedStatement p = null;
    ResultSet rs = null;
    try {
        p = JForumExecutionContext.getConnection().prepareStatement(
                SystemGlobals.getSql("ForumModel.getModeratorList"));
        //  OLD: p.setInt(1, forumId);
        p.setString(1, String.valueOf(forumId));

        rs = p.executeQuery();

        while (rs.next()) {
            ModeratorInfo mi = new ModeratorInfo();

            mi.setId(rs.getInt("id"));
            mi.setName(rs.getString("name"));

            l.add(mi);
        }

        return l;
    }
    catch (SQLException e) {
        throw new DatabaseException(e);
    }
    finally {
        DbUtils.close(rs, p);
    }
}

WEB-INF/config/database/postgresql/postgresql.sql:

# #############
# ForumModel
# #############
ForumModel.lastGeneratedForumId = SELECT CURRVAL('jforum_forums_seq');

#
#  Add the following two queries
#
ForumModel.statsFirstPostTime = SELECT MIN(post_time) FROM jforum_posts     WHERE post_time > timestamp '01-01-01 00:00:00'
ForumModel.statsFirstRegisteredUserTime = SELECT MIN(user_regdate) FROM jforum_users WHERE user_regdate > timestamp '01-01-01 00:00:00'

Compass lib dependency is missing

I added compass-1.2.1.jar to solve a dependency issue in version 2.1.9.
The error: Caused by: java.lang.ClassNotFoundException: org.apache.lucene.index.CompassSegmentReader

What's new in JForum 3?

Hi Rafael,

May I know what is the difference between JForum 2 and 3?

Regards,
James

the exception is posted alone with html output into the page /jforum/forums/show/3.page

see the stack trace please

11:59:42,346 ERROR [runtime ]
Method public java.util.List net.jforum.entities.Forum.getModeratorList() threw an exception when invoked on [Свій , id=3, order=3]

The problematic instruction:

==> assignment: moderators=forum.getModeratorList() [on line 311, column 41 in default/forum_show.htm]

Java backtrace for programmers:

freemarker.template.TemplateModelException: Method public java.util.List net.jforum.entities.Forum.getModeratorList() threw an exception when invoked on [Свій , id=3, order=3]
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:136)
at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
at freemarker.core.Assignment.accept(Assignment.java:90)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.MixedContent.accept(MixedContent.java:92)
at freemarker.core.Environment.visit(Environment.java:196)
at freemarker.core.Environment.process(Environment.java:176)
at freemarker.template.Template.process(Template.java:232)
at net.jforum.JForum.processCommand(JForum.java:233)
at net.jforum.JForum.service(JForum.java:200)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: net.jforum.exceptions.DatabaseException: net.jforum.exceptions.DatabaseException: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 237
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2077)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1810)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:498)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at net.jforum.dao.generic.GenericForumDAO.getModeratorList(GenericForumDAO.java:498)
at net.jforum.repository.ForumRepository.getModeratorList(ForumRepository.java:596)
at net.jforum.entities.Forum.getModeratorList(Forum.java:101)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:825)
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:113)
... 26 more
Caused by: net.jforum.exceptions.DatabaseException: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 237
... 42 more
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Position: 237
... 42 more
11:59:42,738 ERROR [ExceptionWriter ]
Method public java.util.List net.jforum.entities.Forum.getModeratorList() threw an exception when invoked on [Свій , id=3, order=3]

The problematic instruction:

==> assignment: moderators=forum.getModeratorList() [on line 311, column 41 in default/forum_show.htm]

Java backtrace for programmers:

URL is: /jforum/forums/show/3.page?null
2011-06-06 11:59:50,019 [DefaultQuartzScheduler_Worker-8 INFO RefreshFeeds]: Initializing RefreshFeeds Job.
java.net.NoRouteToHostException: No route to host
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocVersion(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.jdom.input.SAXBuilder.build(SAXBuilder.java:453)
at de.nava.informa.parsers.FeedParser.parse(FeedParser.java:220)
at de.nava.informa.parsers.FeedParser.parse(FeedParser.java:125)
at org.javabb.component.feed.ReadRSS.getFeeds(ReadRSS.java:16)
at org.javabb.transaction.ForumTransaction.feedEmpregos(ForumTransaction.java:344)
at org.javabb.transaction.ForumTransaction$$FastClassByCGLIB$$d68f6af.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.javabb.transaction.ForumTransaction$$EnhancerByCGLIB$$2699f12e.feedEmpregos()
at org.javabb.quartz.RefreshFeeds.executeInternal(RefreshFeeds.java:33)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:66)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
2011-06-06 11:59:51,737 [DefaultQuartzScheduler_Worker-8 INFO FeedParser]: Channel uses RSS root element (Version 2.0).
2011-06-06 11:59:51,738 [DefaultQuartzScheduler_Worker-8 INFO RefreshFeeds]: Finishing RefreshFeeds Job.
2011-06-06 12:00:50,025 [DefaultQuartzScheduler_Worker-8 INFO RefreshFeeds]: Initializing RefreshFeeds Job.
java.net.NoRouteToHostException: No route to host
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.http.HttpClient.New(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocVersion(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.AbstractSAXParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.SAXParserImpl$JAXPSAXParser.parse(Unknown Source)
at org.jdom.input.SAXBuilder.build(SAXBuilder.java:453)
at de.nava.informa.parsers.FeedParser.parse(FeedParser.java:220)
at de.nava.informa.parsers.FeedParser.parse(FeedParser.java:125)
at org.javabb.component.feed.ReadRSS.getFeeds(ReadRSS.java:16)
at org.javabb.transaction.ForumTransaction.feedEmpregos(ForumTransaction.java:344)
at org.javabb.transaction.ForumTransaction$$FastClassByCGLIB$$d68f6af.invoke()
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:56)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.javabb.transaction.ForumTransaction$$EnhancerByCGLIB$$2699f12e.feedEmpregos()
at org.javabb.quartz.RefreshFeeds.executeInternal(RefreshFeeds.java:33)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:66)
at org.quartz.core.JobRunShell.run(JobRunShell.java:195)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
2011-06-06 12:00:51,283 [DefaultQuartzScheduler_Worker-8 INFO FeedParser]: Channel uses RSS root element (Version 2.0).
2011-06-06 12:00:51,284 [DefaultQuartzScheduler_Worker-8 INFO RefreshFeeds]: Finishing RefreshFeeds Job.

Problemas com jforum

a versao mais estavel 2.1.9 consegui instalar, mas o botão de criar topicos não aparece, sera que estou enganado e estou acessando um forum que não permite a criação de topicos, acho que não neh???

e quando eu abaixo o codigo ele não executa no netbeans... precisa de alguma configuração especial???

jforum 2.1.9 Security Vulnerabilities Notification

Hello,

High-Tech Bridge Security Research Lab has discovered multiple security vulnerabilities in jforum 2.1.9

Preview available here: https://www.htbridge.com/advisory/HTB23134

Developers can contact us by email for details: advisory (at) htbridge.com

For any questions related to this notification message - please visit our General Information & Disclosure Policy page: https://www.htbridge.com/advisory/disclosure_policy.html

Best regards,

High-Tech Bridge Security Research Lab

jforum3/lib folder missing

Just downloaded the jforum3 git based on the excellence of the code's organisation and cleanliness....
I want to add a user feature to jforum3
and then I ran my first ant build to compile the project....

First off: the lib folder and all dependencies are missing, so compile is a no go.
The documentation has the following to say:
/src/lib
Helper libraries not required to run the project, like JUnit and Servle-API.

That would make sense if this were a Maven or other "dependency managed" project (ivy etc), but, it's not.

I downloaded jforum2 zip package to extract the jars from that version, as the 'binary option doesn't seem to be available for jforum3 (while it's beta?) and started with those.

Next I converted to a maven project for ease of jar management and started downloading the missing dependencies one by one. I'll let you know how that goes when I'm done. I'm bound to run into version issues.

Would be great help if I could get a printed list of the required jars for jforum3?
or instructions if I missed something.

Double slash in smilies URIs

When configuring the forum base url with a trailing slash as the form requests, smilies URIs include a double slash such as this:

http://mywebsite.cloudapp.net/jforum//images/smilies/9d71f0541cff0a302a0309c5079e8dee.gif

This results in 404 errors in some web servers (such as Jetty).

The root cause is that the HTML templates inside the jforum_smilies table follow this pattern

#CONTEXT#/images

when it should be

#CONTEXT#images

These SQL commands fixed the issue on an installed forum:

UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif" /\>' WHERE smilie_id = 1;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/3b63d1616c5dfcf29f8a7a031aaa7cad.gif" /\>' WHERE smilie_id = 2;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/283a16da79f3aa23fe1025c96295f04f.gif" /\>' WHERE smilie_id = 3;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/283a16da79f3aa23fe1025c96295f04f.gif" /\>' WHERE smilie_id = 4;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/9d71f0541cff0a302a0309c5079e8dee.gif" /\>' WHERE smilie_id = 5;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/ed515dbff23a0ee3241dcc0a601c9ed6.gif" /\>' WHERE smilie_id = 6;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/47941865eb7bbc2a777305b46cc059a2.gif" /\>' WHERE smilie_id = 7;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/385970365b8ed7503b4294502a458efa.gif" /\>' WHERE smilie_id = 8;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/0a4d7238daa496a758252d0a2b1a1384.gif" /\>' WHERE smilie_id = 9;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/b2eb59423fbf5fa39342041237025880.gif" /\>' WHERE smilie_id = 10;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/97ada74b88049a6d50a6ed40898a03d7.gif" /\>' WHERE smilie_id = 11;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/1069449046bcd664c21db15b1dfedaee.gif" /\>' WHERE smilie_id = 12;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/69934afc394145350659cd7add244ca9.gif" /\>' WHERE smilie_id = 13;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/69934afc394145350659cd7add244ca9.gif" /\>' WHERE smilie_id = 14;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/499fd50bc713bfcdf2ab5a23c00c2d62.gif" /\>' WHERE smilie_id = 15;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/c30b4198e0907b23b8246bdd52aa1c3c.gif" /\>' WHERE smilie_id = 16;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/2e207fad049d4d292f60607f80f05768.gif" /\>' WHERE smilie_id = 17;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/908627bbe5e9f6a080977db8c365caff.gif" /\>' WHERE smilie_id = 18;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/2786c5c8e1a8be796fb2f726cca5a0fe.gif" /\>' WHERE smilie_id = 19;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/8a80c6485cd926be453217d59a84a888.gif" /\>' WHERE smilie_id = 20;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/8a80c6485cd926be453217d59a84a888.gif" /\>' WHERE smilie_id = 21;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/8a80c6485cd926be453217d59a84a888.gif" /\>' WHERE smilie_id = 22;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/9293feeb0183c67ea1ea8c52f0dbaf8c.gif" /\>' WHERE smilie_id = 23;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/136dd33cba83140c7ce38db096d05aed.gif" /\>' WHERE smilie_id = 24;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/8f7fb9dd46fb8ef86f81154a4feaada9.gif" /\>' WHERE smilie_id = 25;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/d6741711aa045b812616853b5507fd2a.gif" /\>' WHERE smilie_id = 26;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/0320a00cb4bb5629ab9fc2bc1fcc4e9e.gif" /\>' WHERE smilie_id = 27;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/9d71f0541cff0a302a0309c5079e8dee.gif" /\>' WHERE smilie_id = 28;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/49869fe8223507d7223db3451e5321aa.gif" /\>' WHERE smilie_id = 29;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/e8a506dc4ad763aca51bec4ca7dc8560.gif" /\>' WHERE smilie_id = 30;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/e78feac27fa924c4d0ad6cf5819f3554.gif" /\>' WHERE smilie_id = 31;
UPDATE jforum_smilies SET url='\<img src="#CONTEXT#images/smilies/1cfd6e2a9a2c0cf8e74b49b35e2e46c7.gif" /\>' WHERE smilie_id = 32;

jforum 2.1.9 problems

------------------- that I solved ------------------------

in jforum\WEB-INF\config\database\mysql\mysql_db_struct.sql

in jforum_privmsgs table
after privmsgs_id INT NOT NULL auto_increment,
must add privmsgs_type INT NOT NULL default '0',

in jforum_topics table
after topic_vote_id INT NOT NULL default '0',
must add topic_type INT default '0',

-------------------------unsolved-----------------------------

Expression totalRegisteredUsers is undefined on line 108, column 101 in default/forum_list.htm
...
I described the problem here with stack trace and all:
http://www.coderanch.com/t/586282/jforum/JForum#2668753

Unknown problem with jForum

Faced with such a trouble:
HTTP Status 500 -

type Exception report

message

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

exception

javax.servlet.ServletException: Servlet execution threw an exception
net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
root cause

java.lang.ExceptionInInitializerError
java.text.RBTableBuilder.build(RBTableBuilder.java:89)
java.text.RBCollationTables.(RBCollationTables.java:65)
java.text.RuleBasedCollator.(RuleBasedCollator.java:276)
java.text.Collator.getInstance(Collator.java:251)
freemarker.core.Environment.getCollator(Environment.java:671)
freemarker.core.ComparisonExpression.isTrue(ComparisonExpression.java:165)
freemarker.core.IfBlock.accept(IfBlock.java:80)
freemarker.core.Environment.visit(Environment.java:196)
freemarker.core.MixedContent.accept(MixedContent.java:92)
freemarker.core.Environment.visit(Environment.java:196)
freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160)
freemarker.core.Environment.visit(Environment.java:351)
freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)
freemarker.core.Environment.visit(Environment.java:196)
freemarker.core.MixedContent.accept(MixedContent.java:92)
freemarker.core.Environment.visit(Environment.java:196)
freemarker.core.Environment.process(Environment.java:176)
freemarker.template.Template.process(Template.java:232)
net.jforum.JForum.processCommand(JForum.java:233)
net.jforum.JForum.service(JForum.java:200)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
root cause

java.lang.RuntimeException: could not locate data
sun.text.normalizer.NormalizerImpl.(NormalizerImpl.java:44)
java.text.RBTableBuilder.build(RBTableBuilder.java:89)
java.text.RBCollationTables.(RBCollationTables.java:65)
java.text.RuleBasedCollator.(RuleBasedCollator.java:276)
java.text.Collator.getInstance(Collator.java:251)
freemarker.core.Environment.getCollator(Environment.java:671)
freemarker.core.ComparisonExpression.isTrue(ComparisonExpression.java:165)
freemarker.core.IfBlock.accept(IfBlock.java:80)
freemarker.core.Environment.visit(Environment.java:196)
freemarker.core.MixedContent.accept(MixedContent.java:92)
freemarker.core.Environment.visit(Environment.java:196)
freemarker.core.IteratorBlock$Context.runLoop(IteratorBlock.java:160)
freemarker.core.Environment.visit(Environment.java:351)
freemarker.core.IteratorBlock.accept(IteratorBlock.java:95)
freemarker.core.Environment.visit(Environment.java:196)
freemarker.core.MixedContent.accept(MixedContent.java:92)
freemarker.core.Environment.visit(Environment.java:196)
freemarker.core.Environment.process(Environment.java:176)
freemarker.template.Template.process(Template.java:232)
net.jforum.JForum.processCommand(JForum.java:233)
net.jforum.JForum.service(JForum.java:200)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(ClickstreamFilter.java:59)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.

Apache Tomcat/6.0.29

Jars

What are the external jars i should use to run the jforum source code without any error ?

integrate between jforum2 with my project in java

how do I integrate database user account management on my project with user account management on jforum2 ?

MySQL error

Hi,

Got this one when trying to set up jForum on JBoss AS 7.0.2 Final and MySQL 5.5.18 (after realising I had to set up the MySQL properties BEFORE installing. Might want to put a note on that in the install instructions).

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=InnoDB' at line 1
CREATE TABLE jforum_banlist ( banlist_id INT NOT NULL auto_increment, user_id INT, banlist_ip varchar(15), banlist_email varchar(255), PRIMARY KEY (banlist_id), INDEX idx_user (user_id), INDEX (banlist_ip), INDEX (banlist_email)) TYPE=InnoDB

Google gave me this http://www.zabbix.com/forum/showthread.php?t=17543 for what it's worth.

Thanks

bugg

i think i found a bug in jforum 2.1.9. so i thought i should report and if is a part of functionality let me know..
You guys have done really great work and saved a lot of my time for developing my own discussion board.
........thanks a lot to jForum Team..;)

i'm a attaching the screenshot.. please clear my doubt..

documentation.htm points to page that does not exist

The documentation.htm page in the download points to http://www.jforum.net/doc which does not exist on your site. Please repost the documentation section. Thanks

project repo is missing config files, incl hsqldb.properties

Github project repo is missing WEB-INF\config\database\hsqldb\hsqldb.properties
which causes bootstrap (install.jsp) to fail.
Luckily the 'binary' version available from download on the jforum website contains the files so you can merge them in your project.

link: http://jforum.net/download.jsp

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.