[EventCalendar] MySQL error using Event calendar together with wp-sticky

[Peter Allgeyer]

Hi!

I'm using the Beta 2 version of WP-Sticky with Wordpress Ver. 2.1.3. I
have the Event Calendar Widget (3.1.1_rc1) installed and this seems to
be causing a problem. When the WP-Sticky is activated the events page is
trashed. Clicking any event in the calendar gives a MySQL error message:

---< schnipp >---
WordPress database error: [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 'DESC,'%Y-%m-%d') DESC, (wp_sticky.sticky_status = 1
AND wp_sticky.sticky_status ' at line 1]

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_sticky.sticky_status FROM
wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID = wp_post2cat.post_id)
LEFT JOIN wp_ec3_schedule ec3_sch ON ec3_sch.post_id=id LEFT JOIN
wp_sticky ON wp_sticky.sticky_post_id = wp_posts.ID WHERE 1=1 AND
wp_post2cat.category_id IN (9) AND (post_type = 'post' AND (post_status
= 'publish' OR post_status = 'private')) AND ((YEAR(start)=2007 AND
MONTH(start)=05 AND DAYOFMONTH(start)=09) OR (start<='2007-05-09 0:0:0'
AND end>='2007-05-09 0:0:0')) GROUP BY wp_posts.ID ORDER BY
(wp_sticky.sticky_status = 2 AND wp_sticky.sticky_status IS NOT NULL)
DESC, DATE_FORMAT(wp_posts.ec3_sch.start DESC,'%Y-%m-%d') DESC,
(wp_sticky.sticky_status = 1 AND wp_sticky.sticky_status IS NULL) DESC,
DATE_FORMAT(wp_posts.ec3_sch.start DESC,'%T') DESC LIMIT 0, 5
---< schnapp >---

Maybe due to a plugin conflict in queries. I can't find the error, my
SQL is somewhat to bad. Anyone who can help?

BR, PIT


---------------------------------------------------------------------------
 copyleft(c) by |   _-_     "sic transit discus mundi" (From the System
 Peter Allgeyer | 0(o_o)0   Administrator's Guide, by Lars Wirzenius)
---------------oOO--(_)--OOo-----------------------------------------------