Database error with event_views 1.8.2.3 under Drupal 4.7

I enabled the event_views module 1.8.2.3 under Drupal 4.7.2 and then enabled the view "event_date"

Then when I go to http://test.cooldomain.com.com/event/date I get this error message:

* 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 ')))) FROM node node 
LEFT JOIN event event ON node.nid = event.nid WHERE 
(node.s' at line 1 query: SELECT count(DISTINCT(YEAR(from_UNIXTIME()))) 
FROM node node LEFT JOIN event event ON node.nid = event.nid 
WHERE (node.status = '1') AND (node.type IN ('event')) in
/var/www/html/includes/database.mysql.inc on line 120.

* 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 ')) AS event_year, 
count(DISTINCT(node.nid)) as num_nodes, node.title AS node_tit'
 at line 1 query: SELECT YEAR(from_UNIXTIME()) AS event_year, 
count(DISTINCT(node.nid)) as num_nodes, node.title AS node_title, 
node.changed AS node_changed, event.event_start AS 
event_event_start, event.event_end AS event_event_end 
FROM node node LEFT JOIN event event ON node.nid = event.nid 
WHERE (node.status = '1') AND (node.type IN ('event')) GROUP BY 
YEAR(from_UNIXTIME()) ORDER BY event.event_end ASC LIMIT
 0, 10 in /var/www/html/includes/database.mysql.inc on line 120.

Get same error with event/calendar

Curiously event/selector is fine.