|
Error
- 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
LEFT JOIN node modr_n ON node.nid = modr_n.nid WHERE ((modr_n.moderate != 1)) AND ( ((node.status = 1) AND (node.type in ('event')))
AND ((DATE_FORMAT(ADDTIME(node_data_field_datetime.field_datetime_value, SEC_TO_TIME(-18000)), '%Y-%m-%d') <= '2010-09-30' AND DATE_FORMAT(ADDTIME(node_data_field_datetime.field_datetime_value2, SEC_TO_TIME(-18000)), '%Y-%m-%d') >= '2010-09-30'))
)ORDER BY node_changed ASC
in /home/ackerman/public_html/sites/all/modules/views/includes/view.inc on line 814.
- 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
LEFT JOIN node modr_n ON node.nid = modr_n.nid WHERE ((modr_n.moderate != 1)) AND ( ((node.status = 1) AND (node.type in ('event')))
AND ((DATE_FORMAT(ADDTIME(node_data_field_datetime.field_datetime_value, SEC_TO_TIME(-18000)), '%Y-%m-%d') <= '2010-09-30' AND DATE_FORMAT(ADDTIME(node_data_field_datetime.field_datetime_value2, SEC_TO_TIME(-18000)), '%Y-%m-%d') >= '2010-09-30'))
)ORDER BY node_changed ASC
in /home/ackerman/public_html/sites/all/modules/views/includes/view.inc on line 814.
|
|
