When ever I view the calendar with a different user, other then the admin I get this error:

user warning: Unknown column 'node_data_field_event_date.field_event_date_value' in 'where clause' query: SELECT DISTINCT node.nid AS nid, node.title AS node_title, node.changed AS node_changed, node.type AS node_type FROM node node 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 = 5 AND na.realm = 'nodeaccess_userreference') OR (na.gid = 5 AND na.realm = 'nodeaccess_userreference_author') OR (na.gid = 1 AND na.realm = 'nodeaccess_userreference_all'))) AND ( (node.status <> 0) AND ((DATE_FORMAT(CONVERT_TZ(STR_TO_DATE(node_data_field_event_date.field_event_date_value, '%Y-%m-%dT%T'), 'UTC', 'America/New_York'), '%Y-%m') <= '2011-05' AND DATE_FORMAT(CONVERT_TZ(STR_TO_DATE(node_data_field_event_date.field_event_date_value2, '%Y-%m-%dT%T'), 'UTC', 'America/New_York'), '%Y-%m') >= '2011-05')) )ORDER BY node_changed ASC in /home/content/39/4009339/html/portal.inkasgroup.com/modules/views/includes/view.inc on line 775.
user warning: Unknown column 'node_data_field_event_date.field_event_date_value' in 'where clause' query: SELECT DISTINCT node.nid AS nid, node.title AS node_title, node.changed AS node_changed, node.type AS node_type FROM node node 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 = 5 AND na.realm = 'nodeaccess_userreference') OR (na.gid = 5 AND na.realm = 'nodeaccess_userreference_author') OR (na.gid = 1 AND na.realm = 'nodeaccess_userreference_all'))) AND ( (node.status <> 0) AND ((DATE_FORMAT(CONVERT_TZ(STR_TO_DATE(node_data_field_event_date.field_event_date_value, '%Y-%m-%dT%T'), 'UTC', 'America/New_York'), '%Y-%m') <= '2011-05' AND DATE_FORMAT(CONVERT_TZ(STR_TO_DATE(node_data_field_event_date.field_event_date_value2, '%Y-%m-%dT%T'), 'UTC', 'America/New_York'), '%Y-%m') >= '2011-05')) )ORDER BY node_changed ASC in /home/content/39/4009339/html/portal.inkasgroup.com/modules/views/includes/view.inc on line 775.

What can the issue be? I have User Referenced activated on the Create An Event content type, and it even works, when wanting to show an event to only a specific person.

Comments

Neslee Canil Pinto’s picture

Status: Active » Closed (outdated)

The D6 branch is no longer supported so we're closing this issue. If you think this issue still exists in D7 you can open a new one.