Closed (duplicate)
Project:
Views (for Drupal 7)
Version:
5.x-1.4-2rc1
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
18 Jan 2007 at 01:52 UTC
Updated:
18 Jan 2007 at 02:22 UTC
When filtering for "File: Has file downloads", a table join is missing. The wrong queries go like this:
SELECT count(node.nid) FROM node node WHERE (file_revisions.fid)
and
SELECT node.nid FROM node node WHERE (file_revisions.fid) LIMIT 0, 10
Of course we get Unknown column 'file_revisions.fid' warnings because of this.
As soon as we add one of the "File" fields to the View — say "File: Name" — then the file_revisions table gets included in the query and the filter works.
I noticed this problem while trying to implement a similar filter for another module.
Comments
Comment #1
merlinofchaos commentedhttp://drupal.org/node/107974