Upgraded date. Now all views show all dates - queries for views no longer contain filter by date. Ex:
Filters
Node: Published Yes
Node: Type = Event
Settings
Taxonomy: Term = Meeting
Settings
Date: Date Content: Date (field_date) between now and +6 days
generates:
SELECT DISTINCT(node.nid) AS nid,
node.title AS node_title,
node_data_field_date.field_date_value AS node_data_field_date_field_date_value,
node.type AS node_type,
node.vid AS node_vid,
location.name AS location_name,
node_revisions.body AS node_revisions_body,
node_revisions.format AS node_revisions_format
FROM node node
LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid
LEFT JOIN location_instance location_instance ON node.vid = location_instance.vid
LEFT JOIN location location ON location_instance.lid = location.lid
LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
WHERE (node.status <> 0) AND (node.type in ('event'))
ORDER BY node_data_field_date_field_date_value DESC
Comments
OK, not sure what's going on.
OK, not sure what's going on. Backed out date upgrade. Views now display OK on site, but preview in edit still gives same unfiltered SQL and same wrong data. Cleared cache and reloaded home page - same behavior.
With date 2.1 views display wrong on pages - missing any filters by date value. With date 2.0 they display correctly on pages.
With *either* 2.0 or 2.1 view displays wrong on edit preview - missing any filters by date value.
Could this be a CCK issue? I upgraded CCK a short while ago, and I found and applied the recommended patch. If it is a CCK issue, why does it seem to work with date 2.0 in some contexts, but not others?
hi
Hi,
This is onlinev from canada. I am a newbie of this site and i think this site has a lot to provide to the visitors.
onlinev
debt consolidation