[EventCalendar] vcal output error apparantly?
paolo.gabrielli at gmail.com
Mon Feb 13 22:34:25 UTC 2006
On 2/13/06, Alex Tingle <alex at firetree.net> wrote:
> 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).
> Let me know how you get on.
> 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
More information about the EventCalendar