By kaporter on

I am using Drupal 4.7 with PHP 4.4 and when I display the calendar view for the events module I get the following warning:

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 'DISTINCT(node.nid) = event.nid WHERE (MONTH(from_UNIXTIME(event.event_start)) = ' at line 1 query: SELECT count(*) FROM node node LEFT JOIN event event ON DISTINCT(node.nid) = event.nid WHERE (MONTH(from_UNIXTIME(event.event_start)) = 8) AND (YEAR(from_UNIXTIME(event.event_start)) = 2006) in /home/webadmin/domains/cpnhoa.org/public_html/includes/database.mysql.inc on line 120

Do I need to upgrade my PHP version to 5?

Thanks,
Kari

⋅ Categories: Drupal 4.7.x

Comments

jrc’s picture

jrc commented

I am experiencing the same error. Tracking down the culprit now.

hintbw’s picture

hintbw commented

Could this possibly be coming from the event views module? When I go to the "event" page (drupal url of event) I get a regularly formatted month/week etc calendar. When I configure a event view and go to that URL however, I get a similar sql error.