Posted by stodge on February 25, 2011 at 1:00pm
I realise the requirements state that MySQL is strongly recommended but I wanted to let you know of an issued with PostgreSQL. I installed OpenPublish and the first page I visited gave me errors. This is the latest rc OpenPublish-2.3-Build441.tar.gz.
* warning: pg_query(): Query failed: ERROR: column reference "nid" is ambiguous LINE 8: GROUP BY nid ^ in /var/www/sites/openpublish/includes/database.pgsql.inc on line 139.
* user warning: ERROR: column reference "nid" is ambiguous LINE 8: GROUP BY nid ^ query: SELECT DISTINCT(node.nid) AS nid, FIRST(node.title) AS node_title, FIRST(node.language) AS node_language, FIRST(node_comment_statistics.comment_count) AS node_comment_statistics_comment_count FROM node node INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.status <> 0) AND (node.type in ('article')) GROUP BY nid ORDER BY node_comment_statistics_comment_count DESC, node_title ASC LIMIT 5 OFFSET 0 in /var/www/sites/openpublish/sites/all/modules/views/includes/view.inc on line 771.
* warning: pg_query(): Query failed: ERROR: column "v.vid" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT v.vid, td.name, t.tid, COUNT(n.nid) AS count FROM ter... ^ in /var/www/sites/openpublish/includes/database.pgsql.inc on line 139.
* user warning: ERROR: column "v.vid" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: SELECT v.vid, td.name, t.tid, COUNT(n.nid) AS count FROM ter... ^ query: SELECT v.vid, td.name, t.tid, COUNT(n.nid) AS count FROM term_node t INNER JOIN node n ON t.vid = n.vid INNER JOIN term_data td ON t.tid = td.tid INNER JOIN vocabulary v ON v.vid = td.vid WHERE n.status = 1 AND td.name NOT IN ('Other', ' Person Professional', ' Quotation', ' Person Political', ' Person Travel', ' Person Professional Past', ' Person Political Past') GROUP BY t.tid ORDER BY count DESC LIMIT 5 OFFSET 0 in /var/www/sites/openpublish/sites/all/modules/openpublish_core/openpublish_popular_terms/openpublish_popular_terms.module on line 181.
* warning: pg_query(): Query failed: ERROR: argument of AND must be type boolean, not type integer LINE 1: ...bulary v ON v.vid = td.vid WHERE n.status = 1 and t.tid AND ... ^ in /var/www/sites/openpublish/includes/database.pgsql.inc on line 139.
* user warning: ERROR: argument of AND must be type boolean, not type integer LINE 1: ...bulary v ON v.vid = td.vid WHERE n.status = 1 and t.tid AND ... ^ query: SELECT DISTINCT n.title, n.nid, COUNT(n.nid) as count FROM term_node t INNER JOIN topichub_condition thc ON thc.tid = t.tid INNER JOIN node n ON n.nid = thc.nid INNER JOIN term_data td ON t.tid = td.tid INNER JOIN vocabulary v ON v.vid = td.vid WHERE n.status = 1 and t.tid AND td.name NOT IN ('Other', ' Person Professional', ' Quotation', ' Person Political', ' Person Travel', ' Person Professional Past', ' Person Political Past') GROUP BY n.title ORDER BY count DESC LIMIT 5 in /var/www/sites/openpublish/sites/all/modules/openpublish_core/openpublish_popular_terms/openpublish_popular_terms.module on line 218.