Win a copy of React Cookbook: Recipes for Mastering the React Framework this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

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

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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]
 
reply
    Bookmark Topic Watch Topic
  • New Topic