This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android 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]
 
jQuery in Action, 2nd edition
 
subject: Workaround for using JForum2 on PostgreSQL 8.3
 
Similar Threads
IllegalArgumentException when using clj-record's create function
Hibernate: Mapping a sequence to a serial (autoincr) field (Postgresql)
error when going to forum from forum list
Error after integrating JForum
Filtering string