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

Malcolm Bell malcolm at 3hc.co.uk
Tue Feb 14 13:13:25 UTC 2006



-------- Original Message --------
Subject: 	Re: [EventCalendar] vcal output error apparantly?
Date: 	Tue, 14 Feb 2006 13:12:48 +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> 
<829767470602131434l5dd17537xaa74466a7f203f3a at mail.gmail.com> 
<20060213224559.3974e45a at localhost.localdomain>



This is the message I get when running that query in the db:


*SQL Error*
Unknown column 'p.post_author' in 'on clause'


I can confirm there is a column post_author in the wp_posts table


PHP5, MySQL 5, Apache 2, WP 2, EC 3.0.4

Malcolm

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



Alex Tingle wrote:
> Thanks for that Paulo. Hmm. That SQL should be fine then.
>
> Malcolm, I notice you are using MySQL 5 - perhaps that's causing the problem. What happens when you execute that SQL directly on the database? Here it is...
>
> 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;
>
> -Alex
>
> --
>
> On Mon, 13 Feb 2006 23:34:25 +0100
> Paolo Gabrielli <paolo.gabrielli at gmail.com> wrote:
>
>   
>> On 2/13/06, Alex Tingle <alex at firetree.net> 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?
>>>       
>> In WP2.0 the wp_posts table has a column named post_author (bigint 20).
>>
>> P.
>>
>>     
>>> 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
>>>>
>>>>         
>>> --
>>> :: Let me solve your problems: http://www.firetree.net/consulting/
>>> :: alex.tingle AT firetree.net  +44-7901-552763
>>>
>>> _______________________________________________
>>> EventCalendar mailing list
>>> EventCalendar at firetree.net
>>> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
>>>
>>>       
>> _______________________________________________
>> EventCalendar mailing list
>> EventCalendar at firetree.net
>> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
>>     
>
>
>   

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

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


More information about the EventCalendar mailing list