in function aggregator_page_sources() of aggregator.module there is a problem with SQL statement and GROUPING rows. That is to say, as mentioned in the PostgreSQL book,
"If several columns or expressions are specified (delimited by commas), the entire set of specified criteria must be identical for rows to be grouped together."
. So the query represented in that should be:
SELECT f.fid, f.title, f.description, f.image, MAX(i.timestamp) AS last FROM aggregator_feed f LEFT JOIN aggregator_item i ON f.fid = i.fid GROUP BY f.fid, f.title, f.description, f.image;
bye
paquin
Comments
Comment #1
Bèr Kessels commentedThis module is deprecated in favour of http://drupal.org/project/feedparser