[EventCalendar] vcal output error apparantly?

Malcolm Bell malcolm at 3hc.co.uk
Thu Feb 16 12:18:06 UTC 2006


I can't make my interface show anything other than

DESC wp_posts
Row(s) affected: 24

However, this is what I can see when I expand the table:

*wp_posts* 
<http://217.64.126.119/test/sql/index.php?db=brownsea&tb=wp_posts> » 
<javascript:add2board(" wp_posts ")>
  	ID » <javascript:add2board(" ID ")>
/int(20),not_null primary_key unsigned auto_increment/
  	post_author » <javascript:add2board(" post_author ")>
/int(20),not_null/
  	post_date » <javascript:add2board(" post_date ")>
/datetime(19),not_null binary/
  	post_date_gmt » <javascript:add2board(" post_date_gmt ")>
/datetime(19),not_null binary/
  	post_content » <javascript:add2board(" post_content ")>
/blob(-1),not_null blob/
  	post_title » <javascript:add2board(" post_title ")>
/blob(65535),not_null blob/
  	post_category » <javascript:add2board(" post_category ")>
/int(4),not_null/
  	post_excerpt » <javascript:add2board(" post_excerpt ")>
/blob(65535),not_null blob/
  	post_status » <javascript:add2board(" post_status ")>
/string(10),not_null enum/
  	comment_status » <javascript:add2board(" comment_status ")>
/string(15),not_null enum/
  	ping_status » <javascript:add2board(" ping_status ")>
/string(6),not_null enum/
  	post_password » <javascript:add2board(" post_password ")>
/string(20),not_null/
  	post_name » <javascript:add2board(" post_name ")>
/string(200),not_null multiple_key/
  	to_ping » <javascript:add2board(" to_ping ")>
/blob(65535),not_null blob/
  	pinged » <javascript:add2board(" pinged ")>
/blob(65535),not_null blob/
  	post_modified » <javascript:add2board(" post_modified ")>
/datetime(19),not_null binary/
  	post_modified_gmt » <javascript:add2board(" post_modified_gmt ")>
/datetime(19),not_null binary/
  	post_content_filtered » <javascript:add2board(" post_content_filtered ")>
/blob(65535),not_null blob/
  	post_parent » <javascript:add2board(" post_parent ")>
/int(20),not_null/
  	guid » <javascript:add2board(" guid ")>
/string(255),not_null/
  	menu_order » <javascript:add2board(" menu_order ")>
/int(11),not_null/
  	post_type » <javascript:add2board(" post_type ")>
/string(100),not_null/
  	post_mime_type » <javascript:add2board(" post_mime_type ")>
/string(100),not_null/
  	comment_count » <javascript:add2board(" comment_count ")>
/int(20),not_null/


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



Alex Tingle wrote:
> Malcolm,
>
> You didn't try the "DESC wp_posts".
>
> I strongly suspect that the table definition has changed in WP2. Whoever said that the field was still there must have been mistaken. Just confirm it for me (with the DESC) and I'll look into how to fix it.
>
> -Alex
>
> --
>
> On Thu, 16 Feb 2006 10:00:42 +0000
> Malcolm Bell <malcolm at 3hc.co.uk> 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
>>>>>>     
>>>>>>         
>>>>>>             
>>>>>   
>>>>>       
>>>>>           
>>>   
>>>       
>
>
>   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20060216/a8517f43/attachment.htm


More information about the EventCalendar mailing list