Errors installing 2.1.7b3 on JDK 1.4.2_06/Tomcat 6.0.10/MySQL -5.0.37/Windows 2003 server

[Migrated From Jforum.net]

I run Jforum on pretty much the same hardware.

The only odd things I see here are that you're using Tomcat 6.0 with a 1.4 JRE. I THINK it's possible to do this but the 6.0 setup doc does say:

The installer will use the registry or the JAVA_HOME environment variable to determine the base path of a J2SE 5 JRE.

As to the specific error, this is coming from a normal jForum page which probably won't work until the install is done. When you say:

I tried to install using the installer option..

Did you mean calling the install.jsp page? This is the "new" way to run the install wizard (I think the old method was that the index page would call it the first time and then replace itself)

FWIW, the specific error indicates that there is no dateTime.format property in either the SystemGlobal.properties or jforum_custom.conf file.

You mentioned 2.1.6. Did you overwrite the 2.1.7 files with your old files? These need to be "reconciled" if you're updating.

Finally, when you got the SQL Syntax error were you using the MySQL Query Browser GUI tool? On Windows, I've seen this tool choke on a lot of valid SQL scripts. Try using the mysql command line function instead.


[originally posted on jforum.net by monroe]

[Migrated From Jforum.net]

Hi

I tried installing jforum using the installer option. The wizard declares the jforum directory to be unwritable if the file __index.redirect does not exist

So i copied the file from 2.1.6 and then i get the below error


INSTALLER OPTION :
-----------------------------

The Installer fails with an exception in the freemarker component.

Expression dateTimeFormat is undefined on line 2, column 29 in default/header.htm. The problematic instruction:

---------- ==> setting datetime_format set to "dateTimeFormat" [on line 2, column 1 in default/header.htm] [on line 2, column 1 in default/header.htm] in include "header.htm" [on line 1, column 1 in default/message.htm] in include "${templateName}/message.htm" [on line 5, column 1 in exception.html] ----------


Java backtrace for programmers: ----------

freemarker.core.InvalidReferenceException: Expression dateTimeFormat is undefined on line 2, column 29 in default/header.htm. at freemarker.core.TemplateObject.assertNonNull(TemplateObject.java:124) at freemarker.core.Expression.getStringValue(Expression.java:118) at freemarker.core.Expression.getStringValue(Expression.java:93) at freemarker.core.PropertySetting.accept(PropertySetting.java:110) 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.include(Environment.java:1375) at freemarker.core.Include.accept(Include.java:155) 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.include(Environment.java:1375) at freemarker.core.Include.accept(Include.java:155) 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.exceptions.ExceptionWriter.handleExceptionData(ExceptionWriter.java:110) at net.jforum.InstallServlet.service(InstallServlet.java:153) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) 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:228) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445) at java.lang.Thread.run(Unknown Source)


MANUAL OPTION :
------------------------
http://www.jforum.net/install_no_wizard.jsp

When we do an import of "_db_struct.sql" for creating the tables i get the below error.

[Err] 1064 - 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 '---------------------------------------------------------
-- Server version 4.0' at line 4
[Msg] Finished - Unsuccessfully


[originally posted on jforum.net by ajoybasu]

[Migrated From Jforum.net]

Hi,

Tomact 6.0 seems to work fine with JDK1.4 as i have other applications running in Tomcat 6.0 which are working fine.

Installer option - yes i used the install.jsp

SystemGlobal.properties has the timestamp entry as shown below
--------
# Enable or disable registration of new users.
registration.enabled = true

dateTime.format = dd/MM/yyyy HH\:mm\:ss

# RSS date and time format.
# If you want to include the timezone, use
#
# EEE, d MMM yyyy HH:mm:ss z
#
# However, currently, JForum does not include timezone
# when writing messages data to the database
rss.datetime.format = EEE, d MMM yyyy HH:mm:ss
--------------------

I am unable to find the jforum_custom.conf file. Please point me to directory where this file would be available.

I have not overwritten any file of 2.1.7. I just copied the 2.1.6 __index.redirect file which was missing in 2.1.7 in the root directory i.e jforum.

Please let me know what else is causing this problem

Regards
Ajoy

[originally posted on jforum.net by ajoybasu]