- user warning: Unknown column 'node_data_field_date.field_date_value' in 'field list'
query: SELECT node.nid AS nid,
node.title AS node_title,
node.language AS node_language,
node_data_field_date.field_date_value AS node_data_field_date_field_date_value,
node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2,
node.type AS node_type,
node.vid AS node_vid
FROM node node
LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid
WHERE ((node.status <> 0) AND (node.type in ('event')))
AND ((DATE_FORMAT(CONVERT_TZ(node_data_field_date.field_date_value, 'UTC', 'America/Los_Angeles'), '%Y-%m-%d') <= '2012-05-11' AND DATE_FORMAT(CONVERT_TZ(node_data_field_date.field_date_value2, 'UTC', 'America/Los_Angeles'), '%Y-%m-%d') >= '2012-05-11'))
ORDER BY node_data_field_date_field_date_value ASC
in /home/content/65/8097965/html/sites/all/modules/acquia/views/includes/view.inc on line 775.
- user warning: Unknown column 'node_data_field_date.field_date_value' in 'field list'
query: SELECT node.nid AS nid,
node.title AS node_title,
node.language AS node_language,
node_data_field_date.field_date_value AS node_data_field_date_field_date_value,
node_data_field_date.field_date_value2 AS node_data_field_date_field_date_value2,
node.type AS node_type,
node.vid AS node_vid
FROM node node
LEFT JOIN content_type_event node_data_field_date ON node.vid = node_data_field_date.vid
WHERE ((node.status <> 0) AND (node.type in ('event')))
AND ((DATE_FORMAT(CONVERT_TZ(node_data_field_date.field_date_value, 'UTC', 'America/Los_Angeles'), '%Y-%m-%d') <= '2012-05-11' AND DATE_FORMAT(CONVERT_TZ(node_data_field_date.field_date_value2, 'UTC', 'America/Los_Angeles'), '%Y-%m-%d') >= '2012-05-11'))
ORDER BY node_data_field_date_field_date_value ASC
in /home/content/65/8097965/html/sites/all/modules/acquia/views/includes/view.inc on line 775.
