New install on MYSQL 4.1.16 - Admin cannot see forums

[Migrated From Jforum.net]

An error has ocurred. For detailed stack trace, please see the page's source code.

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 '17:03:14 GROUP BY topic_id' at line 1

Did I do something wrong on the install?

Thanks - software looks good - I plan to replace my old jive install if I can get this going on my FC4 box.

Kevin
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

Which JForum version? 2.1.4? overwrite the file WEB-INF/config/database/mysql/mysql_41.sql over mysql.sql

Also, version 2.1.5 is done. This out: https://coderanch.com/t/575752

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

[Migrated From Jforum.net]

I've registered now to try and help resolve these issues.

Regards

Kevin
[originally posted on jforum.net by kpassey]

[Migrated From Jforum.net]

Kevin,

for the captcha thing, try passing -Djava.awt.headless=true to the VM when starting Tomcat.

I'm working to fix these pre-2.1.5 problems as soon as possible.

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

[Migrated From Jforum.net]

I'm a bit of a roockie where linux and java is concerned - my background is iSeries and RPG - sorry.

How do I do that.

Regards

Kevin
[originally posted on jforum.net by kpassey]

[Migrated From Jforum.net]

Well I tried that - I even re-extracted the install zip to my locl PC - renamed the mysql file as instructed and got the following.

Any further advice ?

<meta name="description" content=" Expression metaDescription is undefined on line 6, column 37 in default/forum_base.htm. The problematic instruction: ---------- ==> ${metaDescription} [on line 6, column 35 in default/forum_base.htm] in include "default/forum_base.htm" [on line 7, column 1 in exception.html] ---------- Java backtrace for programmers: ---------- freemarker.core.InvalidReferenceException: Expression metaDescription is undefined on line 6, column 37 in default/forum_base.htm. at freemarker.core.TemplateObject.assertNonNull(freemarker.template.TemplateModel, freemarker.core.Expression, freemarker.core.Environment) (Unknown Source) at freemarker.core.Expression.getStringValue(freemarker.template.TemplateModel, freemarker.core.Expression, freemarker.core.Environment) (Unknown Source) at freemarker.core.Expression.getStringValue(freemarker.core.Environment) (Unknown Source) at freemarker.core.DollarVariable.accept(freemarker.core.Environment) (Unknown Source) at freemarker.core.Environment.visit(freemarker.core.TemplateElement) (Unknown Source) at freemarker.core.MixedContent.accept(freemarker.core.Environment) (Unknown Source) at freemarker.core.Environment.visit(freemarker.core.TemplateElement) (Unknown Source) at freemarker.core.Environment.include(freemarker.template.Template) (Unknown Source) at freemarker.core.Include.accept(freemarker.core.Environment) (Unknown Source) at freemarker.core.Environment.visit(freemarker.core.TemplateElement) (Unknown Source) at freemarker.core.MixedContent.accept(freemarker.core.Environment) (Unknown Source) at freemarker.core.Environment.visit(freemarker.core.TemplateElement) (Unknown Source) at freemarker.core.Environment.process() (Unknown Source) at freemarker.template.Template.process(java.lang.Object, java.io.Writer) (Unknown Source) at net.jforum.exceptions.ExceptionWriter.handleExceptionData(java.lang.Throwable, java.io.Writer) (Unknown Source) at net.jforum.InstallServlet.service(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse) (Unknown Source) at javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest, javax.servlet.ServletResponse) (/usr/lib/libservletapi5-5.0.30.jar.so) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(javax.servlet.ServletRequest, javax.servlet.ServletResponse) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.ApplicationFilterChain.doFilter(javax.servlet.ServletRequest, javax.servlet.ServletResponse) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardWrapperValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardPipeline.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardContextValve.invokeInternal(org.apache.catalina.Wrapper, org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardContextValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardPipeline.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardHostValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.valves.ErrorReportValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardPipeline.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardEngineValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.StandardPipeline.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.catalina.core.ContainerBase.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.coyote.tomcat5.CoyoteAdapter.service(org.apache.coyote.Request, org.apache.coyote.Response) (/usr/lib/libcatalina-5.0.30.jar.so) at org.apache.coyote.http11.Http11Processor.process(java.io.InputStream, java.io.OutputStream) (/usr/lib/libtomcat-http11-5.0.30.jar.so) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(org.apache.tomcat.util.net.TcpConnection, java.lang.Object[]) (/usr/lib/libtomcat-http11-5.0.30.jar.so) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(java.lang.Object[]) (/tmp/libtomcat-util-5.0.30.jar.soartc0w.so) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run() (/tmp/libtomcat-util-5.0.30.jar.soartc0w.so) at java.lang.Thread.run() (/usr/lib/libgcj.so.6.0.0) >
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

We're investiganting. There are some other reports of problems with the package.

Keep an eye in the forum for news.

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

[Migrated From Jforum.net]

Hi Rafael,

Well I decided to try 2.1.5. It has cleared the original error but now I'm coming up with lots more.

Do you want to have a look around my install. I have it on a FC4 box with tomcat 5.0.x and Mysql 4.1.x

The install ran OK - I am now looking for docs so I can update the index page with my logo and description and of course clear up these errors.

Regards

Kevin
[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

To start with - register displays this:-

Information

An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

net.jforum.util.Captcha



[originally posted on jforum.net by Anonymous]

[Migrated From Jforum.net]

In your tomcat startup.sh or catalina.sh you want to find the setting of JAVA_OPTS (or add it if it does not exist). Make sure that JAVA_OPTS includes the string "-Djava.awt.headless=true".
[originally posted on jforum.net by time]

[Migrated From Jforum.net]

catalinha.sh you'll find in the directory <TOMCAT_HOME>/bin, where <TOMCAT_HOME> is where Tomcat is installed.

But, as I said for you in the private message, the captcha error you got was because some missing classes, probably due some error unpacking JForum - so, a new installation is recommended.

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

[Migrated From Jforum.net]

Btw, I made some patches for 2.1.5.. You can download it again from http://www.jforum.net/upload/JForum-2.1.5.zip

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

[Migrated From Jforum.net]

OK I'll try a re-install with a new download.

Thanks for your reply's

Kevin
[originally posted on jforum.net by kpassey]

[Migrated From Jforum.net]

OK - I've completed a re-install - I left the mysql database as it was and that was overwritten - no problem.

When I now go to the admin control panel that displays ok whereas it didn't before.

Now the test e-mail says it has worked but I do not get anything in my inbox.

And when I try and register I am still getting:-

An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

net.jforum.util.Captcha

That is after a new install - so some things have changed for the better - email has gone backwards.

I found the startup script in /USR/BIN on my FC4 box (dtomcat5) however if I change it TOMCAT will no longer start - I ended up re-installing TOMCAT via YUM

So in summary - all that does not work on my FC4 box so far now is - email and being able to register.

If you think something is missing can you tell me what and I'll check it.

Thanks - I love the look+feel of the software - I just hope I can get it working.

Kind regards

Kevin
[originally posted on jforum.net by kpassey]

[Migrated From Jforum.net]

If I restart Tomcat and login to JForums using Admin - then try and send a test msg - here is what catalina.out looks like - it would seem that mysql is causing the problems there - what do you think.

2-Feb-06 12:07:28 PM org.apache.coyote.http11.Http11Protocol start()
INFO: Starting Coyote HTTP/1.1 on http-8080
2-Feb-06 12:07:29 PM org.apache.jk.common.ChannelSocket init()
INFO: JK2: ajp13 listening on /0.0.0.0:8009
2-Feb-06 12:07:29 PM org.apache.jk.server.JkMain start()
INFO: Jk running ID=0 time=1/154 config=/usr/share/tomcat5/conf/jk2.properties
2-Feb-06 12:07:29 PM org.apache.catalina.startup.Catalina start()
INFO: Server startup in 20131 ms
12:09:39,499 INFO [JForumBaseServlet ] Starting JForum. Debug mode is true
12:09:39,610 INFO [ConfigLoader ] Using cache engine: net.jforum.cache.DefaultCacheEngine
12:09:39,651 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.BBCodeRepository
12:09:39,678 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.RankingRepository
12:09:40,173 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.SmiliesRepository
12:09:40,199 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.ForumRepository
12:09:40,346 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.TopicRepository
12:09:40,367 INFO [ConfigLoader ] Creating an instance of net.jforum.SessionFacade
12:09:40,389 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.PostRepository
12:09:40,417 INFO [ConfigLoader ] Creating an instance of net.jforum.util.search.quartz.QuartzSearchIndexerJob
12:09:40,444 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.Tpl
12:09:40,461 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.RolesRepository
12:09:40,479 INFO [ConfigLoader ] Creating an instance of net.jforum.repository.SecurityRepository
12:09:42,253 INFO [FileMonitor ] Watching /var/lib/tomcat5/webapps/JForum-2.1.5/WEB-INF/config/languages/en_US.properties
12:09:42,297 INFO [ConfigLoader ] Loading JDBC driver net.jforum.dao.mysql.MysqlDataAccessDriver
12:09:43,254 INFO [FileMonitor ] Watching /var/lib/tomcat5/webapps/JForum-2.1.5/WEB-INF/config/database/generic/generic_queries.sql
12:09:43,254 INFO [FileMonitor ] Watching /var/lib/tomcat5/webapps/JForum-2.1.5/WEB-INF/config/database/mysql/mysql.sql
12:09:43,255 INFO [FileMonitor ] Watching /var/lib/tomcat5/webapps/JForum-2.1.5/WEB-INF/config/SystemGlobals.properties
12:09:43,256 INFO [FileMonitor ] Watching /var/lib/tomcat5/webapps/JForum-2.1.5/WEB-INF/config/jforum-custom.conf
12:09:47,402 INFO [ConfigLoader ] Loading clickstream config from /var/lib/tomcat5/webapps/JForum-2.1.5/WEB-INF/config/clickstream-jforum.xml
12:09:48,095 INFO [FileMonitor ] Watching /var/lib/tomcat5/webapps/JForum-2.1.5/WEB-INF/config/jforum-custom.conf
12:10:19,333 INFO [SessionFacade ] Removing session DCAB62913307D2B7259C9C7860AF3336
12:11:06,603 WARN [SessionFacade ] Error storing user session data: java.sql.SQLException: 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 '12:10:19)' at line 1
java.sql.SQLException: 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 '12:10:19)' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(int) (Unknown Source)
at com.mysql.jdbc.MysqlIO.sendCommand(int, java.lang.String, com.mysql.jdbc.Buffer, boolean, java.lang.String) (Unknown Source)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(com.mysql.jdbc.Statement, java.lang.String, java.lang.String, com.mysql.jdbc.Buffer, int, com.mysql.jdbc.Connection, int, int, boolean, java.lang.String, boolean) (Unknown Source)
at com.mysql.jdbc.Connection.execSQL(com.mysql.jdbc.Statement, java.lang.String, int, com.mysql.jdbc.Buffer, int, int, boolean, boolean, java.lang.String, boolean, byte, boolean) (Unknown Source)
at com.mysql.jdbc.PreparedStatement.executeInternal(int, com.mysql.jdbc.Buffer, boolean, boolean, boolean, boolean) (Unknown Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate(byte[][], java.io.InputStream[], boolean[], int[], boolean[], boolean) (Unknown Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate(boolean) (Unknown Source)
at com.mysql.jdbc.PreparedStatement.executeUpdate() (Unknown Source)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate() (Unknown Source)
at net.jforum.dao.generic.GenericUserSessionDAO.add(net.jforum.entities.UserSession, java.sql.Connection, boolean) (Unknown Source)
at net.jforum.dao.generic.GenericUserSessionDAO.update(net.jforum.entities.UserSession, java.sql.Connection) (Unknown Source)
at net.jforum.SessionFacade.storeSessionData(java.lang.String, java.sql.Connection) (Unknown Source)
at net.jforum.view.forum.UserAction.logout() (Unknown Source)
at java.lang.reflect.Method.invoke(java.lang.Object, java.lang.Object[]) (/usr/lib/libgcj.so.6.0.0)
at net.jforum.Command.process(net.jforum.ActionServletRequest, javax.servlet.http.HttpServletResponse, freemarker.template.SimpleHash) (Unknown Source)
at net.jforum.JForum.service(javax.servlet.http.HttpServletRequest, javax.servlet.http.HttpServletResponse) (Unknown Source)
at javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest, javax.servlet.ServletResponse) (/usr/lib/libservletapi5-5.0.30.jar.so)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(javax.servlet.ServletRequest, javax.servlet.ServletResponse) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(javax.servlet.ServletRequest, javax.servlet.ServletResponse) (/usr/lib/libcatalina-5.0.30.jar.so)
at net.jforum.util.legacy.clickstream.ClickstreamFilter.doFilter(javax.servlet.ServletRequest, javax.servlet.ServletResponse, javax.servlet.FilterChain) (Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(javax.servlet.ServletRequest, javax.servlet.ServletResponse) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(javax.servlet.ServletRequest, javax.servlet.ServletResponse) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardWrapperValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardPipeline.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardContextValve.invokeInternal(org.apache.catalina.Wrapper, org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardContextValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardPipeline.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardHostValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.valves.ErrorReportValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardPipeline.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardEngineValve.invoke(org.apache.catalina.Request, org.apache.catalina.Response, org.apache.catalina.ValveContext) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardValveContext.invokeNext(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.StandardPipeline.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.catalina.core.ContainerBase.invoke(org.apache.catalina.Request, org.apache.catalina.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(org.apache.coyote.Request, org.apache.coyote.Response) (/usr/lib/libcatalina-5.0.30.jar.so)
at org.apache.jk.server.JkCoyoteHandler.invoke(org.apache.jk.core.Msg, org.apache.jk.core.MsgContext) (Unknown Source)
at org.apache.jk.common.HandlerRequest.invoke(org.apache.jk.core.Msg, org.apache.jk.core.MsgContext) (Unknown Source)
at org.apache.jk.common.ChannelSocket.invoke(org.apache.jk.core.Msg, org.apache.jk.core.MsgContext) (Unknown Source)

12:11:06,739 INFO [SessionFacade ] Removing session DCAB62913307D2B7259C9C7860AF3336

[originally posted on jforum.net by kpassey]

[Migrated From Jforum.net]

OK, I'll fix that as soon as possible.

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