[EventCalendar] Re: no posts in events page

Alex Tingle alex at firetree.net
Tue Oct 24 12:35:11 UTC 2006


Hi Mels,

On 24 Oct 2006, at 11:16, Ordinary Gal wrote:

> 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...

You have the option "Keep Events Separate" selected. That already keeps 
events off the front page. Why are you trying to do it with 
"query_posts('&cat=-4')"?

Just pick one way or the other (but not both) and it will work.

That is a bug, by the way. Thanks for spotting it.

-Alex

--

>
> 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
>>
>>
> _______________________________________________
> Blog: http://wpcal.firetree.net/
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar




More information about the EventCalendar mailing list