[EventCalendar] database error since update

[Darrell Schulte]

On Nov 8, 2006, at 10:28 AM, Pappenberger Martin wrote:

> 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?

Hi Martin,

 From the FAQ
http://wpcal.firetree.net/faq/

> Q. I get WordPress database errors
>
> You have an error in your SQL syntax near '( SELECT DISTINCT id,  
> post_title, GREATEST(start,'2006-10-0' at line 1
>
> A. You must have at least MySQL 4 to run the EventCalendar plugin.

Are you using MySQL 3?

Darrell



Darrell Schulte
http://schulte.mn