Win a copy of Head First Android this week in the Android 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
  • Paul Clapham
  • Ron McLeod
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Rob Spoor
  • Devaka Cooray
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
  • Tim Holloway
Bartenders:
  • Jj Roberts
  • Al Hobbs
  • Piet Souris

What are the minimum requirements for JForum ?

 
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello all,

I'm sorry to report that everything is not going smooth on the install. Could I just check what the minimum requirements are? (I could not find this in the documentation anywhere).

I am using MySQL v4.0.20a and JDK 1.4

Should these suffice ?

Thank you.

Heather.


[originally posted on jforum.net by heatherfraser]
 
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
The problems I have encountered so far ~

1. Even though I configured the JNDI datasource for the jforum webapp & tested it with my own JSP code within the context, the Jforum install JSP complained that the datasource was not bound within this context.

So, I opted for the manual JDBC configuration.



2. Then I get the following error ~

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




I have found that other people are encountering the same errors ~

http://www.jforum.net/rss/topicPosts/2690.page



I am testing this on Windows XP (with security setttings very low - full access to the directories)

Am now going to go try the non-wizard approach.

http://www.jforum.net/install_no_wizard.jsp


Heather.
[originally posted on jforum.net by heatherfraser]
 
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
So, I used the manual install method (and have some comments on that too which I shall post separately) & the board is viewable.

However, it is not possible to insert anything, whether it be to create a new user, add a post, or add anything in the Admin Control Panel.

The error every time is the same "SQL String can not be NULL" with the traceback resembling the following ~

Caused by: net.jforum.exceptions.DatabaseException: java.sql.SQLException: SQL String can not be NULL
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910 )
at com.mysql.jdbc.PreparedStatement.<init>(PreparedStatement.java:438 )
at com.mysql.jdbc.Connection.clientPrepareStatement(Connection.java:2138 )
at com.mysql.jdbc.Connection.clientPrepareStatement(Connection.java:2068 )
at com.mysql.jdbc.Connection.prepareStatement(Connection.java:4611 )
at com.mysql.jdbc.Connection.prepareStatement(Connection.java:4516 )
at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:190 )
at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:137 )
at net.jforum.dao.generic.AutoKeys.executeAutoKeysQuery(AutoKeys.java:118 )
at net.jforum.dao.generic.GenericUserDAO.addNew(GenericUserDAO.java:298 )
at net.jforum.view.forum.UserAction.insertSave(UserAction.java:318 )
... 35 more
Caused by: java.sql.SQLException: SQL String can not be NULL
... 46 more



the insertSave() method makes me think that this is related to transactions. I'm not sure whether MySQL 4.0.20 had full transaction support.

Just in case I set database.use.transactions = false in JForum's SystemGlobals.properties but still the problem persists.

Any ideas?

Thank you,

Heather
[originally posted on jforum.net by heatherfraser]
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic