Register / Login
Win a copy of
Cross-Platform Desktop Applications: Using Node, Electron, and NW.js
this week in the
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
Workaround for using JForum2 on PostgreSQL 8.3
Migrated From Jforum.net
posted 8 years ago
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]
Don't get me started about those stupid
Boost this thread!
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)