ERROR: relation "og_aggregator_feed" does not exist
WISEOZ - January 22, 2008 - 02:46
| Project: | OG Aggregator |
| Version: | 5.x-1.0-2 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | zagorot |
| Status: | won't fix |
Jump to:
Description
I receive the following error on my Aggregator tab on my OG home pages ...
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "og_aggregator_feed" does not exist in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT COUNT(*) FROM og_aggregator_feed f JOIN og_aggregator_item i ON i.fid = f.fid WHERE f.nid = 37 in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "og_aggregator_feed" does not exist in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT f.*, i.* FROM og_aggregator_feed f JOIN og_aggregator_item i ON i.fid = f.fid WHERE f.nid = 37 ORDER BY i.timestamp desc LIMIT 10 OFFSET 0 in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT DISTINCT(u.uid), u.* FROM og_uid ogu INNER JOIN users u ON ogu.uid = u.uid WHERE ogu.nid = 37 AND ogu.is_active = 1 AND u.status = 1 ORDER BY ogu.created DESC LIMIT 10 OFFSET 0 in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.I am using Drupal 5.5 eith PostgreSQL.
#1
This problem caused by database table missing.
yes, I am not familiar with PostgreSQL, so this package missing a install script for PostgreSQL, currently I only did the MySQL one, maybe somebody can contribute his PostgreSQL install script for this module, I would really appreciate that.
#2
Okay, I had someone who knows PostgreSQL create the "og_aggregator_feed". The errors that remain are ...
On the "aggregator" tab ...
* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.* user warning: query: SELECT DISTINCT(u.uid), u.* FROM og_uid ogu INNER JOIN users u ON ogu.uid = u.uid WHERE ogu.nid = 37 AND ogu.is_active = 1 AND u.status = 1 ORDER BY ogu.created DESC LIMIT 10 OFFSET 0 in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
On the "Feed overview" tab ...
* warning: pg_query() [function.pg-query]: Query failed: ERROR: column "f.nid" must appear in the GROUP BY clause or be used in an aggregate function in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.* user warning: query: SELECT f.*, COUNT(i.iid) AS items FROM og_aggregator_feed f LEFT JOIN og_aggregator_item i ON f.fid = i.fid where f.nid = 37 GROUP BY f.fid, f.title, f.url, f.refresh, f.checked, f.link, f.description, f.etag, f.modified, f.image, f.block ORDER BY f.title in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
* user warning: query: SELECT DISTINCT(u.uid), u.* FROM og_uid ogu INNER JOIN users u ON ogu.uid = u.uid WHERE ogu.nid = 37 AND ogu.is_active = 1 AND u.status = 1 ORDER BY ogu.created DESC LIMIT 10 OFFSET 0 in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
On the "add feed" tab ...
* warning: pg_query() [function.pg-query]: Query failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.* user warning: query: SELECT DISTINCT(u.uid), u.* FROM og_uid ogu INNER JOIN users u ON ogu.uid = u.uid WHERE ogu.nid = 37 AND ogu.is_active = 1 AND u.status = 1 ORDER BY ogu.created DESC LIMIT 10 OFFSET 0 in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.
#3
oh, i see your problems here. it caused by sql statements not compatible with PostgreSQL, because i am mysql guy, so natually using mysql sql statements in this module, sorry for that for all you PostgreSQL guys.
i will fix this bug in the 6.x version some day.
#4
I will not be implementing PostgreSQL for OG, however it should be supported in 6 thanks to the Schema API that exists. Please test this and report any bugs.