Closed (duplicate)
Project:
Date
Version:
6.x-2.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
8 Apr 2009 at 17:44 UTC
Updated:
9 Apr 2009 at 11:04 UTC
I just upgraded both Date and Views and not my date filter no longer work. The Live Preview query out shows the where clause doesn't have the date filter in it:
SELECT node.nid AS nid,
node.title AS node_title,
node_data_field_event_date.field_event_date_value AS node_data_field_event_date_field_event_date_value,
node_data_field_event_date.field_event_date_value2 AS node_data_field_event_date_field_event_date_value2,
node.type AS node_type,
node.vid AS node_vid
FROM node node
INNER JOIN users users ON node.uid = users.uid
LEFT JOIN content_type_event node_data_field_event_date ON node.vid = node_data_field_event_date.vid
WHERE node.type in ('event')
ORDER BY node_data_field_event_date_field_event_date_value ASC
I deleted the filter and added it again and still the query came out the same.
Comments
Comment #1
merlinofchaos commentedProblematic, but if it's a date filter you need to file this against date.module and then KarenS can pull her hair out wondering what I broke. =)
Comment #2
chromeyellow commentedI believe that this issue does not exist in 6.x-2.x-dev as of the April 2 snapshot. However, it *does* seem to be a problem in 6.x-2.1 (and duplicates http://drupal.org/node/426990 - same op's original date.module report). So when this got bounced back from views.module it became a dupe, with wrong version.
Mark this as dupe and stick to http://drupal.org/node/426990?
Comment #3
jpetso commentedyep, duplicate of #426990: Views filter "Date (field_event_date) - From date >= now" doesn't work anymore?.