So I have calendar working fine on the Admin side when I go to it but when I try to access it on the public side I get this error:

* user warning: Unknown column 'node_data_field_event_date.field_event_date_value' in 'where clause' query: SELECT node.nid AS nid, node.title AS node_title, node.changed AS node_changed, node.type AS node_type FROM node node WHERE (node.status <> 0) AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_event_date.field_event_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2011-04' AND DATE_FORMAT(STR_TO_DATE(node_data_field_event_date.field_event_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2011-04')) ORDER BY node_changed ASC in /home/carligho/public_html/sites/default/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 node.nid AS nid, node.title AS node_title, node.changed AS node_changed, node.type AS node_type FROM node node WHERE (node.status <> 0) AND ((DATE_FORMAT(STR_TO_DATE(node_data_field_event_date.field_event_date_value, '%Y-%m-%dT%T'), '%Y-%m') <= '2011-04' AND DATE_FORMAT(STR_TO_DATE(node_data_field_event_date.field_event_date_value2, '%Y-%m-%dT%T'), '%Y-%m') >= '2011-04')) ORDER BY node_changed ASC in /home/carligho/public_html/sites/default/modules/views/includes/view.inc on line 775.

Comments

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Closed (won't fix)

Please read the submission guidelines.

dkblay’s picture

dkblay commented
Status: Closed (won't fix) » Active

Please can u come clear on that .

dawehner’s picture

dawehner
Primary language German
commented
Status: Active » Closed (won't fix)

Point one

Make sure that your issue is a Views issue! Views provides the ability to list data - if your data is provided by a module other than Drupal Core, please enter your issue in that module's issue queue instead. If your problem deals exclusively with fields or filters provided by another module (CCK, Image, VotingAPI are common) please post the issue under the queue for that module first; all modules are responsible for telling Views about their own fields. Issues based on other module's data sent to the Views queue will be punted over to that module's issue queue. Module maintainers are the best people to make the determination that the module is providing the right information to Views and they can kick the issue into the Views queue with an explanation of what's wrong if that is the case.

Point two


Priority: Critical, major, normal, minor. There is no such thing as a critical support request. If you are under a time constraint, Drupal Jobs< or the irc channel #drupal-consultants are better options. Critical issues are bugs where the application crashes or is otherwise completely unusable. For all other issues where a feature does not work properly, please use "Normal".

Point three:

Description: This is critical. Be as specific as possible.
dkblay’s picture

dkblay commented

Please probably not sure which module is responsible for this. I used the views module to display a calendar. This works very well on localhost but is giving me problems on the live environment.
Can anyone please check it out, using this link: http://carligh.org/calendar
Am not sure if it is from the views module or the calendar module please

Thanks a lot for your support.

dkblay’s picture

dkblay commented

wow finally resolved it...just had to enable view field_event_date(a field i created under views) under content_permissions module to anonymous users................................