When a file has been moved to other folder (term) by editing the terms of the file, it still being shown in the old folder as well.

To fix this problem, I changed the following line:

File: file_browser.module line #1059

$sql = 'SELECT DISTINCT(n.nid), n.sticky, n.title, 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 AND n.moderate = 0 ORDER BY '. $order;

Change to:

$sql = 'SELECT DISTINCT(n.nid), n.sticky, n.title, n.created FROM {node} n INNER JOIN {term_node} tn ON n.vid = tn.vid WHERE tn.tid IN ('. $str_tids .') AND n.status = 1 AND n.moderate = 0 ORDER BY '. $order;

(Change the join condition from "n.nid = tn.nid" to "n.vid = tn.vid"

Comments

BoogieBug’s picture

Please note that it occurred only when enabling the 'create new revision' option in the Work flow settings

johanneshahn’s picture

Status: Active » Closed (cannot reproduce)

try latest stable