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
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

Boris Mann - October 24, 2005 - 05:40
Status:needs review» duplicate

Please provide a patch next time, and also look for duplicates first.

Duplicate of 28566.

 
 

Drupal is a registered trademark of Dries Buytaert.