[Fwd: Re: [EventCalendar] vcal output error apparantly?]

Malcolm Bell malcolm at 3hc.co.uk
Mon Feb 13 22:49:11 UTC 2006



-------- Original Message --------
Subject: 	Re: [EventCalendar] vcal output error apparantly?
Date: 	Mon, 13 Feb 2006 22:48:28 +0000
From: 	Malcolm Bell <malcolm at 3hc.co.uk>
To: 	Alex Tingle <alex at firetree.net>
References: 	<43F0F74F.6060906 at 3hc.co.uk> 
<20060213222648.3e6b4d09 at localhost.localdomain>



Apologies - its v 3.0.4 - is that the latest?

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



Alex Tingle wrote:
> Malcolm,
>
> Don't bother! v3.0.2 doesn't work with iCal2. Upgrade to the latest version of the plugin, and things should go better for you.
>
> On the other hand. Your error isn't the one I expected to see. Perhaps you are using Wp2.0 and have discovered another upgrade bug. Does anyone know if the column "post_author" has been removed or renamed in Wp2?
>
> Let me know how you get on.
>
> -Alex
>
> --
>
> On Mon, 13 Feb 2006 21:17:03 +0000
> Malcolm Bell <malcolm at 3hc.co.uk> wrote:
>
>   
>> I've been trying to make event calendar 3.0.2 work with ical 2.0
>>
>> When I enter the URL to create the vcs file this is what I see if I open 
>> it in a text browser:
>>
>> BEGIN:VCALENDAR
>> VERSION:2.0
>> X-WR-CALNAME:Brownsea2007
>> <div id='error'>
>>             <p class='wpdberror'><strong>WordPress database 
>> error:</strong> [Unknown column 'p.post_author' in 'on clause']<br />
>>             <code>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, 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</code></p>
>>             </div>END:VCALENDAR
>>
>> So I assume from this that I've got something wrong in EventCalendar but 
>> haven't got a clue what.
>>
>> Any ideas?
>>
>> PHP5 + MySQL5 Apache 2 on remote server
>>
>> Malcolm
>>
>> -- 
>> website:    www.3hc.co.uk
>> Skype u/n:  malcolmbell
>>
>>     
>
>
>   

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20060213/c41b77b1/attachment.htm


More information about the EventCalendar mailing list