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
Comment #1
Dimm commented+100 D5 & D6
Comment #2
davyvdb commentedFixed in 5 and 6.