date_views.inc line 71
" WHERE node.nid = ". $data->nid . $where .
This produces an error because the nid is immediately next to the next WHERE statement, and, it's missing an AND.
Here is the error:

user warning: FUNCTION user_drupal.3FROM_UNIXTIME does not exist 

query: SELECT node_data_field_event_date.field_event_date_value AS value, node_data_field_event_date.field_event_date_rrule AS rrule, node_data_field_event_date.delta AS delta FROM node node LEFT JOIN content_field_event_date node_data_field_event_date ON node.vid = node_data_field_event_date.vid WHERE node.nid = 3FROM_UNIXTIME(node_data_field_event_date.field_event_date_value) >= '2009-02-01 00:00:00' AND FROM_UNIXTIME(node_data_field_event_date.field_event_date_value) <= '2009-02-28 23:59:59' ORDER BY node_data_field_event_date.delta ASC in /home/user/public_html/includes/database.mysql.inc on line 174.

I replaced line 71 with:
" WHERE node.nid = ". $data->nid . " AND " . $where .

Afterward, everything worked great.

Comments

clivesj’s picture

clivesj commented

Even though I don't understand why does it, this change breaks the "Date" column of my View (Multiple dates are not shown, column is empty).

karens’s picture

karens commented
Status: Active » Fixed

Right idea, wrong fix. You need to prefix $where with 'AND' only if there is a value in $where, otherwise you'll have a broken SQL.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.