[EventCalendar] Re: vcal output error apparantly?

Malcolm Bell malcolm at 3hc.co.uk
Sun Feb 19 23:22:27 UTC 2006


Thank You Peter

This makes the URL for the calendar output (http://mysite.com/?ec3_vcal) 
create a valid looking XML file ... but now i don't seem to be able to 
get PHP icalendar to recognise it!

I think I'm doing everything right - but obviously not.  Time to read 
the manual again.

Malcolm

website:    www.3hc.co.uk
Skype u/n:  malcolmbell



Peter Allgeyer wrote:
> Am Sonntag, den 19.02.2006, 22:09 +0100 schrieb Peter Allgeyer:
>   
>> Hi,
>>
>> same problem here (MySQL 5.0, WP 2.0.1).
>>
>> post_author is bigint(20) in wp_posts, I can confirm that.
>>
>> Let me know, if I can help further in debugging the problem.
>>     
>
> Ok, found the solution (see http://www.planetmysql.org/):
>
> Relace the ',' with INNER JOIN:
>
> ---< schnipp >---
> SELECT p.id AS id,
>   post_title,
>   post_excerpt,
>   DATE_FORMAT( post_date_gmt, '%Y%m%dT%H%i%sZ' ) AS dt_start,     
>   user_nicename
> FROM wp_posts p INNER JOIN wp_post2cat p2c
> LEFT JOIN wp_users u ON u.ID = p.post_author
> WHERE post_status = 'publish'
>   AND p.id = post_id
>   AND category_id =18
> ---< schnapp >---
>
> BR,
>   PIT
>
>
> ---------------------------------------------------------------------------
>  copyleft(c) by |           If you want your program to be readable,
>  Peter Allgeyer |   _-_     consider supplying the argument.  -- Larry
>                 | 0(o_o)0   Wall in the perl man page
> ---------------oOO--(_)--OOo-----------------------------------------------
>
>
>
> _______________________________________________
> EventCalendar mailing list
> EventCalendar at firetree.net
> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20060219/4a3d861f/attachment-0001.html


More information about the EventCalendar mailing list