[EventCalendar] SQL-Error with EC3.1/WP2.1 using advanced query

postmaster at baeckmann.com postmaster at baeckmann.com
Wed Jan 31 10:38:26 UTC 2007


Hello everybody,

Event Calendar works very fine on my Installation, when I list my event
category via ..../category/events  everything works fine. But if I use an
advanced query e.g. ..../category/events/?ec3_after=today  I get following
mysql-error:

[Column 'category_id' in where clause is ambiguous]
SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts LEFT JOIN wp_post2cat
ON (wp_posts.ID = wp_post2cat.post_id) LEFT JOIN wp_categories ON
(wp_post2cat.category_id = wp_categories.cat_ID) LEFT JOIN wp_post2cat
ec3_post2cat ON ec3_post2cat.post_id=id LEFT JOIN wp_ec3_schedule ec3_sch
ON ec3_sch.post_id=id WHERE 1=1 AND category_id IN (4) AND (post_type =
'post' AND (post_status = 'publish' OR post_status = 'private')) AND
(end>='2007-01-31') AND ec3_post2cat.category_id=4 GROUP BY wp_posts.ID
ORDER BY post_date DESC LIMIT 0, 10

The error can be corrected with ... WHERE 1=1 AND ec3_post2cat.category_id
IN (4) ....

But I don't know where to change this behaviour...

Perhaps someone has an hint....

Wordpress 2.1 (german) with Mysql 5.0.18 and official Eventcalendar 3.10
(not latest svn-version)



More information about the EventCalendar mailing list