The 'latest articles' section repeats the listing for articles, once for each taxonomy term it has. So, for example, if an article has 3 terms associated with it, it will appear three times in the list.

The fix was a simple matter of adding 'DISTINCT' to the SQL query. A patch is attached.

CommentFileSizeAuthor
distinct.diff1.01 KBtomchance@www.remixreading.org

Comments

tomchance@www.remixreading.org’s picture

tomchance@www.remixreading.org commented

Just updating the status to reflect the fact that I included a patch...

tomchance@www.remixreading.org’s picture

tomchance@www.remixreading.org commented
Title: Latest articles repeats with multiple taxonomy » Latest articles & article listings repeat with multiple taxonomy

And another update... the article listings exhibit the same problem. However, I'm not able to fix this one because it seems to be a more general taxonomy issue, one that I can't isolate at the moment.

Have a look, for example, at this listing:
http://tom.acrewoods.net/writing/technology

And at the count for the technology category on:
http://tom.acrewoods.net/writing

All the articles that are members of the "KDE" category and the parent category "Technology" are listed twice. It can be solved by only selecting "KDE", but then this seems unintuitive to me: if you are only supposed to select the lowest-level category in a hierarchy, the form should reflect this.

tomchance@www.remixreading.org’s picture

tomchance@www.remixreading.org commented

Actually, ignore those URLs... I've done some SQL surgery to ensure that the listings are correct for now, by ensuring that no node has both Technology and KDE as terms.

onedrupaluser’s picture

onedrupaluser commented

Same problem here. Latest articles is useless as the same article gets repeated several times.

(drupal 4.6.1, Apache2, PHP5)

Chris

green monkey’s picture

green monkey commented

i'm a little confused by this thread.

Is this or can this be repaired... patched?

thanks

gtoddv’s picture

gtoddv commented

Yes, could someone please clarify if this is something that can be fixed?

Thanks in advance.

boris mann’s picture

boris mann commented
Status: Needs review » Closed (duplicate)

Duplicate of 28566.