Fancy delete don't use curly brackets and don't work with prefix table

All tables should use curly brackets.

For example:

$query = db_query("SELECT fm.* FROM file_managed AS fm ...

Should be:

$query = db_query("SELECT fm.* FROM {file_managed} AS fm ...

If you use prefixed tables with the current code:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'file_managed' doesn't exist: SELECT fm.* FROM file_managed AS fm LEFT OUTER JOIN file_usage AS fu ON (fm.fid = fu.fid) LEFT OUTER JOIN node AS n ON (fu.id = n.nid) WHERE fu.type = 'node' AND n.nid IS NULL; Array ( ) a FancyFileDeleteOrphanFileFilter->query() (línia 25 de /var/local/html/drupal7/node1/sites/transparencia.diba.cat/modules/contrib/fancy_file_delete/views/inc/FancyFileDeleteOrphanFileFilter.inc).