[EventCalendar] 3.0.4 iCal DB corruption?
Jim Galley
jim.galley at gmail.com
Thu Oct 12 06:33:47 UTC 2006
Hi,
I'm using 3.0.4 on a scout site (for a while now, thanks!). I'm in
the process of moving the sit to a different server, and noticed that
the new sites iCal is screwed up.
old: http://565.incuspace.com/?ec3_vcal
new: http://troop565.org/?ec3_vcal
new is a restore of old - are same database, same plugin. new one
returns the following
------------------------------------------------------------
BEGIN:VCALENDAR
VERSION:2.0
X-WR-CALNAME:Troop565SmithtownNY
<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 = 2</code></p>
</div>END:VCALENDAR
--------------------------------------------------------
Any suggestions on how 2 fix?
More information about the EventCalendar
mailing list