This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JForum and the fly likes Workaround for using JForum2 on PostgreSQL 8.3 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "Workaround for using JForum2 on PostgreSQL 8.3" Watch "Workaround for using JForum2 on PostgreSQL 8.3" New topic
Author

Workaround for using JForum2 on PostgreSQL 8.3

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hi,

I've just upgraded my Debian server to 5.0 (Lenny) and now I'm with PostgreSQL 8.3. But with that release JForum2 has a SQL issue because PG 8.3 is more strict than older versions.

The error is:

It's relative to the ForumModel.getModeratorList SQL query.

A workaround is to change the SQL queries (directly in WEB-INF/config/database/generic/generic_queries.sql):
by

BTW I'm surprised that the type of the role_value column (in jforum_role_values table) is character varying.
[originally posted on jforum.net by turman]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Workaround for using JForum2 on PostgreSQL 8.3
 
Similar Threads
error when going to forum from forum list
Error after integrating JForum
Hibernate: Mapping a sequence to a serial (autoincr) field (Postgresql)
Filtering string
IllegalArgumentException when using clj-record's create function