• 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
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • 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]
 
I'm not sure if I approve of this interruption. But this tiny ad checks out:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic