[EventCalendar] 3.0.4 iCal DB corruption?

[Alex Tingle]

Hi Jim,

Wow, what a mess!

I can't clear this up right now for you - I've got to cook the dinner. However...

> - upgrading caused event posts dates to be rewritten to the current
> date.

It looks like the upgrade process has failed for you. (Event) Post
timestamps are supposed to be turned back to the original post date. The
event times should be written into the new table: wp_ec3_schedule.

You say you have a database dump from before the upgrade? Does it
contain anything secret? May I have a copy of it - that might REALLY
help me to work out why some people's upgrade fails.

One of the biggest problems I have is that although there are obviously
problems, I'm not seeing any error messages. Page generation seems to
just stop! Is you web-server reporting any errors?


>       SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat
> ec3_post2cat ON ec3_post2cat.post_id=id LEFT JOIN wp_post2cat ON
> (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND post_date_gmt <=
> '2006-10-12 17:26:59' AND (post_status = "publish" OR post_author = 1
> AND post_status != 'draft' AND post_status != 'static') AND
> post_status != "attachment" AND category_id = 4 GROUP BY wp_posts.ID
> ORDER BY post_date DESC LIMIT 0, 5

Weird. Are your *sure* this SQL is generated by EC v3.1._pre16. It ought
to be impossible.

Can you disable ALL OTHER PLUGINS except EC. (Scroll down and make sure
you've got them all.) What does it look like now? If that fixes it, then
try activating the other plugins one by one until you find the culprit.

regards,

-Alex

--

On Thu, 12 Oct 2006 13:35:07 -0400
"Jim Galley" <jim.galley at gmail.com> wrote:

> Alex,
> 
> Yep - saw the downgrade issue before - restored a backup prior to
> reverting back to 3.0.4
> 
> Ok - running rc16 now.
> 
> The site is http://troop565.org - notice that when you click the home
> tab, sometimes the left sidebar appears, other times it does not. Some
> other "interesting" behavior:
> 
> - the 404 page throws an error - example http://troop565.org/general/
> shows a db error on recent posts.
> 
> ----------------
> Recent Posts
> 
>       WordPress database error: [Column 'category_id' in where clause
> is ambiguous]
>       SELECT DISTINCT * FROM wp_posts LEFT JOIN wp_post2cat
> ec3_post2cat ON ec3_post2cat.post_id=id LEFT JOIN wp_post2cat ON
> (wp_posts.ID = wp_post2cat.post_id) WHERE 1=1 AND post_date_gmt <=
> '2006-10-12 17:26:59' AND (post_status = "publish" OR post_author = 1
> AND post_status != 'draft' AND post_status != 'static') AND
> post_status != "attachment" AND category_id = 4 GROUP BY wp_posts.ID
> ORDER BY post_date DESC LIMIT 0, 5
> --------------
> 
> - ical works (yeah!)
> 
> _______________________________________________
> EventCalendar at firetree.net mailing list
> Unsubscribe: http://penguin.firetree.net/eventcalendar
> Download: http://sf.net/projects/wpcal


-- 
:: Let me solve your problems: http://www.firetree.net/consulting/
:: alex.tingle AT firetree.net  +44-7901-552763