Duplicate Results
jrstmartin - February 20, 2007 - 20:58
| Project: | Similar Entries |
| Version: | 4.7.x-1.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
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 :)
| Attachment | Size |
|---|---|
| similar_module_duplicates.jpg | 122.72 KB |
#1
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.
#2
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!
#3
Added in DRUPAL-4-7--1-2 and DRUPAL-5--1-2.
#4
Thanks schmkr! Works for me too :)
#5