[EventCalendar] SQL error with latest version of eventcalender3

Pieter Baele pieter.baele at telenet.be
Sat Jan 13 17:18:37 UTC 2007


Hello,

I have three separate installations of wordpress: one to support nl
(dutch), one for english and one for fr(ench). They al have separate
databases.

The installation works perfect on the english installation.
But for the dutch installation I get en error, for the french I also got
an error message like this one. I've tried modifying a lot of things and
events, but I haven't got any luck...

WordPress database error: [You have an error in your SQL syntax near
'( SELECT DISTINCT id, post_title, GREATEST(start,'2007-01-0' at line 1]
( SELECT DISTINCT id, post_title, GREATEST(start,'2007-01-01 00:00:00')
AS start_date, LEAST(end,'2007-02-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>='2007-01-01 00:00:00' AND start<'2007-02-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>='2007-01-01
00:00:00' AND post_date<'2007-02-01 00:00:00' AND post_date<NOW() )
ORDER BY id, allday DESC, start_date, is_event DESC


It's a very nice plugin (thx!) so I hope I can get it running...



-- 
Greetings,
Pieter Baele
---------------------------------
GNU/Linux User #310384 (Gentoo)
Jabber: pieterb at amessage.be
PGP (keyserver.net) 0x68881F36
---------------------------------




More information about the EventCalendar mailing list