user warning: Unknown column 'node_data_field_datetime.field_datetime_value' in 'where clause'
query: SELECT node.nid AS nid,
node_data_field_event_link.field_event_link_url AS node_data_field_event_link_field_event_link_url,
node_data_field_event_link.field_event_link_title AS node_data_field_event_link_field_event_link_title,
node_data_field_event_link.field_event_link_attributes AS node_data_field_event_link_field_event_link_attributes,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_event_link.field_datetime_value AS node_data_field_event_link_field_datetime_value,
node_data_field_event_link.field_datetime_value2 AS node_data_field_event_link_field_datetime_value2,
node.changed AS node_changed
FROM node node
LEFT JOIN content_type_event node_data_field_event_link ON node.vid = node_data_field_event_link.vid
WHERE ((node.status <> 0) AND (node.type in ('event')))
AND ((DATE_FORMAT(ADDTIME(node_data_field_datetime.field_datetime_value, SEC_TO_TIME(-25200)), '%Y-%m-%d') <= '2010-03-31' AND DATE_FORMAT(ADDTIME(node_data_field_datetime.field_datetime_value2, SEC_TO_TIME(-25200)), '%Y-%m-%d') >= '2010-03-31'))
ORDER BY node_changed ASC
in /home/rockymou/public_html/sites/all/modules/views/includes/view.inc on line 775.
user warning: Unknown column 'node_data_field_datetime.field_datetime_value' in 'where clause'
query: SELECT node.nid AS nid,
node_data_field_event_link.field_event_link_url AS node_data_field_event_link_field_event_link_url,
node_data_field_event_link.field_event_link_title AS node_data_field_event_link_field_event_link_title,
node_data_field_event_link.field_event_link_attributes AS node_data_field_event_link_field_event_link_attributes,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_event_link.field_datetime_value AS node_data_field_event_link_field_datetime_value,
node_data_field_event_link.field_datetime_value2 AS node_data_field_event_link_field_datetime_value2,
node.changed AS node_changed
FROM node node
LEFT JOIN content_type_event node_data_field_event_link ON node.vid = node_data_field_event_link.vid
WHERE ((node.status <> 0) AND (node.type in ('event')))
AND ((DATE_FORMAT(ADDTIME(node_data_field_datetime.field_datetime_value, SEC_TO_TIME(-25200)), '%Y-%m-%d') <= '2010-03-31' AND DATE_FORMAT(ADDTIME(node_data_field_datetime.field_datetime_value2, SEC_TO_TIME(-25200)), '%Y-%m-%d') >= '2010-03-31'))
ORDER BY node_changed ASC
in /home/rockymou/public_html/sites/all/modules/views/includes/view.inc on line 775.