[EventCalendar] btw

Alex Tingle alex at firetree.net
Wed Oct 25 21:23:50 UTC 2006


Hi Bill,

The SQL error is caused by an EC bug that I fixed today. But that's  
not your problem...

Why is category 23 excluded from that page? That's your problem!  
Something (not EC) is saying: don't put cat 23 on this page.  
Obviously, you won't see any events if they are all excluded.

I would expect this to come from a query like ?cat=-23
Do you have something like that in your theme?

Did you turn off your plugins in turn, as I suggested?

-Alex

--

On 25 Oct 2006, at 22:14, Bill Gram-Reefer wrote:

> if I toggle to "Keep events separate" I get this wonderful news
>
> Press 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 WHERE 1=1 AND (category_id ! 
> = 23) AND post_date_gmt <= '2006-10-25 21:14:59' AND (post_status =  
> "publish" OR post_author = 1 AND post_status != 'draft' AND  
> post_status != 'static') AND post_status != "attachment" AND  
> ec3_post2cat.category_id!=23
> Not Found
>
>
>
> =============
> Bill Gram-Reefer
> worldviewpr at astound.net
> 925-323-3169
>
>
>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar




More information about the EventCalendar mailing list