I'm getting duplicate results from the latest version (4.7.x-1.0, v 1.2.2.10 2007/01/21 19:40:33 deekayen) of similar.module.

The duplicates are blog entries that do not have revisions. I've read the issue about duplicate revisions appearing, but these are just regular blog entries without revisions. I have edited/resubmitted the post a few times, but again, no revisions exist.

I've tried all different kinds of situations and settings that I can think of, but still get duplicate results sometimes.

I've attached screenshots. I'm not a coder so this is about all I can do to help. I hope to resolve this because I really love this module. Thanks in advance :)

CommentFileSizeAuthor
similar_module_duplicates.jpg122.72 KBjrstmartin

Comments

schmkr’s picture

schmkr commented

I am also getting duplicate results in the block and I think this is caused by having multiple terms for one post and the duplicate posts too have multiple terms.

schmkr’s picture

schmkr commented

I think I have a very simple solution to the issue and that is adding 'GROUP BY n.nid' between 'AND n.type IN ($types)' and 'ORDER BY score' on line 233 of similar.module

At least, this works fine for me!

deekayen’s picture

deekayen commented
Status: Active » Fixed

Added in DRUPAL-4-7--1-2 and DRUPAL-5--1-2.

jrstmartin’s picture

jrstmartin commented

Thanks schmkr! Works for me too :)

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)