[EventCalendar] vcal output error apparantly?

Malcolm Bell malcolm at 3hc.co.uk
Sun Feb 19 20:11:09 UTC 2006


I wonder if any of you clever database-savvy people can throw any light 
on this?

A later post from me confirmed the columns in the table.

WP2 & MySQL5

Thanks

Malcolm

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



Malcolm Bell wrote:
> Same error message :-(
>
>
> *SQL Error*
> Unknown column 'wp_posts.post_author' in 'on clause'
>
> Malcolm
>
> website:    www.3hc.co.uk
> Skype u/n:  malcolmbell
>
>
> Alex Tingle wrote:
>> Hi Malcolm,
>>
>> Hmm. Well I'm assured that coumn exists, so it seems to be a wrinkle with MySQL 5. Let's see...
>>
>> 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
>>   ON wp_users.ID=wp_posts.post_author
>> WHERE post_status = 'publish'
>>   AND p.id = post_id
>>   AND category_id = 18;
>>
>> Does that work any better? (I've changed it to explicitly name the table, rather than usinag an alias.)
>>
>> Can you also run this command, and let me know what it says:
>>
>> DESC wp_posts;
>>
>> (This just lists the definition of the wp_posts table.)
>>
>> Your difficulty in running database queries makes me think that a WP plugin could be written to do the job. Just something to add a database query interface to the WP Admin screens. Has anybody already done this?
>>
>> -Alex
>>
>> --
>>
>>
>> On Tue, 14 Feb 2006 13:12:48 +0000
>> Malcolm Bell <malcolm at 3hc.co.uk> wrote:
>>
>>   
>>> 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
>>>>>     
>>>>>         
>>>>   
>>>>       
>>
>>
>>   
> ------------------------------------------------------------------------
>
> _______________________________________________
> 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/586c8424/attachment.htm


More information about the EventCalendar mailing list