duplicated links in the article listing box
Evan Wise - October 13, 2005 - 18:47
| Project: | Article |
| Version: | 4.6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | minor |
| Assigned: | Evan Wise |
| Status: | duplicate |
Jump to:
Description
The articles listed by the module duplicate if there are more than one category tag selected. I have fixed this issue by changing the SQL in article_select_nodes
$sql = 'SELECT DISTINCT n.nid, n.title, n.sticky, n.created FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid WHERE tn.tid IN ('. $str_tids .') AND n.status = 1 ORDER BY n.sticky DESC, n.created DESC';
I simply added the DISTINCT to the query to prevent multiples from being selected.
HTH,
E/.

#1
Please provide a patch next time, and also look for duplicates first.
Duplicate of 28566.