Closed (duplicate)
Project:
Article
Version:
4.6.x-1.x-dev
Component:
Code
Priority:
Minor
Category:
Bug report
Assigned:
Reporter:
Created:
13 Oct 2005 at 18:47 UTC
Updated:
24 Oct 2005 at 05:40 UTC
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/.
Comments
Comment #1
boris mann commentedPlease provide a patch next time, and also look for duplicates first.
Duplicate of 28566.