By peter@peter.karlberg.org on

I have a well functioning drupal site at http://peter.karlberg.org (all content in swedish but everything else in english because I havn't finished the translation yet - swedish is now optional for registered users). I do have one problem which relate to the Forum modul. The contributions to the forums (i.e. comments) are not displayed correctly - no linebreaks and they got the following message:

warning: pg_exec(): Query failed: ERROR: Function 'greatest(int4, int4)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
. in /usr/local/lib/php/DB/pgsql.php on line 164.
user error: DB Error: unknown error
query: SELECT n.nid, n.title, n.body, GREATEST(n.created, MAX(c.timestamp)) AS date_sort, COUNT(c.nid) AS num_comments FROM node n LEFT JOIN forum f ON n.nid = f.nid LEFT JOIN comments c ON n.nid = c.nid WHERE n.nid = f.nid AND f.tid = 4 AND n.status = 1 GROUP BY n.nid, n.title, n.body, n.created ORDER BY date_sort DESC in /var/www/domains/karlberg.org/peter/root/includes/database.pear.inc on line 74.

I am not really able to figure out what to do.

The site is running Apache/1.3.27 (Unix) PHP/4.3.2 mod_ssl/2.8.14 OpenSSL/0.9.6g on Solaris 8 and