[EventCalendar] Re: no posts in events page

[Ordinary Gal]

Hi
      I was testing out my themes and I think I found the problem why this
error is showing up. I just upgraded to the eventscalendar 3.1rc3 and when I
go to my blog page, it shows the same error below. I'm using Filosofo
Home-Page Control Plugin and my blog can be found at
testzone.shanghaipinay.com/wordpress/blog. It's using the index.php template
(default). I have this query after the if (have_posts()) :
<?php $temp_query = $wp_query; query_posts('&cat=-4'); //exclude category 4
?>

I read somewhere that this is the query to exclude a category.. and I wanted
to exclude the events category from showing up...

Aside from this problem, the events calendar works great... any way to work
this out??

Thanks!
mels


I would say that you have more problems that your events just not showing, I
> did a search in your WP search box and netted this error:
>
> WordPress database error: [Column 'category_id' in where clause is
> ambiguous]
> SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat ON (wp_posts.ID =
> wp_post2cat.post_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 AND ec3_sch.end>
> ='2006-10-24 00:00:00' WHERE 1=1 AND (category_id != 2) AND post_date_gmt
> <=
> '2006-10-24 04:47:59' AND (post_status = "publish") AND post_status !=
> "attachment"
> AND ec3_post2cat.category_id!=4 GROUP BY wp_posts.ID ORDER BY post_date
> DESC
> LIMIT 0, 10
> WordPress database error: [Column 'category_id' in where clause is
> ambiguous]
> SELECT COUNT(DISTINCT ID) FROM wp_posts LEFT JOIN wp_post2cat ON
> (wp_posts.ID
> = wp_post2cat.post_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 AND
> ec3_sch.end>='2006-10-24 00:00:00' WHERE 1=1 AND (category_id != 2) AND
> post_date_gmt <=
> '2006-10-24 04:47:59' AND (post_status = "publish") AND post_status !=
> "attachment" AND ec3_post2cat.category_id!=4
>
>
> What version of Event Calendar are you using, I'm not thinking the most
> recent?
>
> Patrick
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20061024/1a8e85cd/attachment.html