Win a copy of Cross-Platform Desktop Applications: Using Node, Electron, and NW.js this week in the JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Workaround for using JForum2 on PostgreSQL 8.3  RSS feed

Migrated From
Ranch Hand
Posts: 17424
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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):

BTW I'm surprised that the type of the role_value column (in jforum_role_values table) is character varying.
[originally posted on by turman]
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!