Thank you for the module.

My Drupal 5 installation uses prefixes in database table names. So query

$sql = "SELECT tn2.tid, td2.name, COUNT(tn.nid) AS cnt FROM term_node tn INNER JOIN term_node tn2 ON tn2.nid = tn.nid INNER JOIN term_data td ON td.tid = tn.tid INNER JOIN term_data td2 ON td2.tid = tn2.tid WHERE (tn.tid = %d) AND tn2.tid <> %d ".$restrict_vids." GROUP BY tn.tid, tn2.tid ORDER BY cnt DESC";

doesn't work. Table names should be wrapped in { }.

$sql = "SELECT tn2.tid, td2.name, COUNT(tn.nid) AS cnt FROM {term_node} tn INNER JOIN {term_node} tn2 ON tn2.nid = tn.nid INNER JOIN {term_data} td ON td.tid = tn.tid INNER JOIN {term_data} td2 ON td2.tid = tn2.tid WHERE (tn.tid = %d) AND tn2.tid <> %d ".$restrict_vids." GROUP BY tn.tid, tn2.tid ORDER BY cnt DESC";

This solves the issue.

Comments

Dimm’s picture

+100 D5 & D6

davyvdb’s picture

Status: Active » Fixed

Fixed in 5 and 6.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.