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

Bèr Kessels’s picture

Status: Active » Closed (won't fix)

This module is deprecated in favour of http://drupal.org/project/feedparser