[EventCalendar] vcal output error apparantly?

Malcolm Bell malcolm at 3hc.co.uk
Thu Feb 16 10:00:42 UTC 2006


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
>>>>     
>>>>         
>>>   
>>>       
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20060216/bb34fedd/attachment-0001.html


More information about the EventCalendar mailing list