- user warning: Unknown column 'node_data_field_potluck_date.field_event_date_value' in 'where clause' query: SELECT DISTINCT node.nid AS nid, node_data_field_potluck_date.field_potluck_date_value AS node_data_field_potluck_date_field_potluck_date_value, node_data_field_potluck_date.field_potluck_date_value2 AS node_data_field_potluck_date_field_potluck_date_value2, node.type AS node_type, node.vid AS node_vid, 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_data_field_event_date.field_event_date_rrule AS node_data_field_event_date_field_event_date_rrule, node_data_field_event_date.delta AS node_data_field_event_date_delta, node.title AS node_title FROM node node LEFT JOIN content_field_event_date node_data_field_event_date ON node.vid = node_data_field_event_date.vid LEFT JOIN content_field_event_date node_data_field_event_date2 ON node.vid = node_data_field_event_date2.vid LEFT JOIN content_type_potluck node_data_field_potluck_date ON node.vid = node_data_field_potluck_date.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( ((node.status <> 0) AND (node.type in ('event', 'potluck'))) AND (((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_potluck_date.field_event_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') <= '2010-09' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_potluck_date.field_event_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') >= '2010-09')) OR ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_potluck_date.field_potluck_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') <= '2010-09' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_potluck_date.field_potluck_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') >= '2010-09'))) )ORDER BY node_data_field_event_date_field_event_date_value ASC, node_data_field_potluck_date_field_potluck_date_value ASC in /var/www/apc/sites/all/modules/views/includes/view.inc on line 775.
- user warning: Unknown column 'node_data_field_potluck_date.field_event_date_value' in 'where clause' query: SELECT DISTINCT node.nid AS nid, node_data_field_potluck_date.field_potluck_date_value AS node_data_field_potluck_date_field_potluck_date_value, node_data_field_potluck_date.field_potluck_date_value2 AS node_data_field_potluck_date_field_potluck_date_value2, node.type AS node_type, node.vid AS node_vid, 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_data_field_event_date.field_event_date_rrule AS node_data_field_event_date_field_event_date_rrule, node_data_field_event_date.delta AS node_data_field_event_date_delta, node.title AS node_title FROM node node LEFT JOIN content_field_event_date node_data_field_event_date ON node.vid = node_data_field_event_date.vid LEFT JOIN content_field_event_date node_data_field_event_date2 ON node.vid = node_data_field_event_date2.vid LEFT JOIN content_type_potluck node_data_field_potluck_date ON node.vid = node_data_field_potluck_date.vid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 0 AND na.realm = 'content_access_author') OR (na.gid = 1 AND na.realm = 'content_access_rid'))) AND ( ((node.status <> 0) AND (node.type in ('event', 'potluck'))) AND (((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_potluck_date.field_event_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') <= '2010-09' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_potluck_date.field_event_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') >= '2010-09')) OR ((DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_potluck_date.field_potluck_date_value, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') <= '2010-09' AND DATE_FORMAT(ADDTIME(STR_TO_DATE(node_data_field_potluck_date.field_potluck_date_value2, '%Y-%m-%dT%T'), SEC_TO_TIME(-18000)), '%Y-%m') >= '2010-09'))) )ORDER BY node_data_field_event_date_field_event_date_value ASC, node_data_field_potluck_date_field_potluck_date_value ASC in /var/www/apc/sites/all/modules/views/includes/view.inc on line 775.
