On a fresh install of event_views on Drupal 5.7, I encountered the following error when accessing the default view event_select.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:59)) AND (MONTH(event.event_start) >= MONTH(2008-06-21 00:59)) AND (DAYOFMONT' at line 1 query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, event.event_start AS event_event_start, event.event_end AS event_event_end, event.timezone AS event_timezone FROM node node LEFT JOIN event event ON node.nid = event.nid WHERE (node.status = '1') AND (node.type IN ('event')) AND (YEAR(event.event_start) = YEAR(2008-06-21 00:59)) AND (MONTH(event.event_start) >= MONTH(2008-06-21 00:59)) AND (DAYOFMONTH(event.event_start) >= 1) ORDER BY node_title ASC LIMIT 0, 10 in /usr/local/data/d5.7b/includes/database.mysqli.inc on line 151.

It would appear the change to the MySQL datetime format has caused a problem. The datetime string should be quoted in the queries (eg. MONTH('2008-06-21 00:59') instead of MONTH(2008-06-21 00:59) ).

I have been through the code but the required change escapes me! I have reverted to 5.1 until you manage to fix this.