[EventCalendar] database error since update

[Pappenberger Martin]

  I saw that my SQL Version is: MySQL - 3.23.49
What can I do? Couldn´t I install the older Plugin running on my  
Website with Wordpress 2.0.5?

Or is there anything else I can do?



Am 08.11.2006 um 17:35 schrieb 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
>
>
>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20061108/6b243295/attachment.htm