File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Workaround for using JForum2 on PostgreSQL 8.3
Migrated From Jforum.net
Joined: Apr 22, 2012
Mar 31, 2009 00:05:49
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:
java.sql.SQLException: ERROR: operator doesn't exist : character varying = integer
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):
AND rv.role_value = ?
AND CAST(rv.role_value AS integer) = ?
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]
It is sorta covered in the
JavaRanch Style Guide
subject: Workaround for using JForum2 on PostgreSQL 8.3
IllegalArgumentException when using clj-record's create function
Error after integrating JForum
error when going to forum from forum list
Hibernate: Mapping a sequence to a serial (autoincr) field (Postgresql)
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014