[EventCalendar] database error since update

[Pappenberger Martin]

Hello!

I hope you can help me! Since I have updated the Wordpress from 1.5  
to 2.0.5 the calendar plugin does no work. So I have installed the  
newest version of the plugin (3.1.0) and now there is a database  
error where I call <?php ec3_get_calendar(); ?>:

WordPress database error: [You have an error in your SQL syntax near  
'( SELECT DISTINCT id, post_title, GREATEST(start,'2006-10-0' at line 1]
( SELECT DISTINCT id, post_title, GREATEST(start,'2006-10-01  
00:00:00') AS start_date, LEAST(end,'2006-11-01 00:00:00') AS  
end_date, allday, 1 AS is_event FROM wp_posts,wp_ec3_schedule WHERE  
post_status='publish' AND post_id=id AND end>='2006-10-01 00:00:00'  
AND start<'2006-11-01 00:00:00' ) UNION ( SELECT DISTINCT id,  
post_title, post_date AS start_date, post_date AS end_date, 0 AS  
allday, 0 AS is_event FROM wp_posts WHERE post_status='publish' AND  
post_date>='2006-10-01 00:00:00' AND post_date<'2006-11-01 00:00:00'  
AND post_date<NOW() ) ORDER BY id, allday DESC, start_date, is_event  
DESC

What can I do?



Yours,

Martin

Website: http://www.sportschuetzen-tiefenbach.de/blog
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20061108/6f6f4f2f/attachment-0001.html