[EventCalendar] Moving the database help ...

[Alex Tingle]

Hi Damon,

> "WordPress database error: [Lost connection to MySQL server during 
> query]
> SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND (post_date_gmt <=
> '2006-09-05 17:36:59' AND id NOT IN (-1,5,6,30,31,33,37,41,42) ) AND
> (post_status = "publish") AND post_status != "attachment" GROUP BY
> wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10 "

What happens if you try to execute that SQL directly on the database?

Do you see any errors in the MySQL log?

What do you get when you enter this SQL: "DESC wp_posts;" (I'm 
wondering if you might have lost the AUTO_INCREMENT attribute of your 
table keys.)

How did you move the data from one database to another?

-Alex

--
Dammit Jim, I'm a programmer... not a mind reader!

On 5 Sep 2006, at 18:38, Damon wrote:

> Hi,
>
> I recently tried to move my wordpress database from one system to
> another ... everything is working terrifically on the new system
> except the eventcalendar plugin ... for some reason, anything that
> includes posts that are NOT in the eventcalendar category won't
> display.  Instead, I get a lot of errors ... they start with:
>
> "WordPress database error: [Lost connection to MySQL server during 
> query]
> SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND (post_date_gmt <=
> '2006-09-05 17:36:59' AND id NOT IN (-1,5,6,30,31,33,37,41,42) ) AND
> (post_status = "publish") AND post_status != "attachment" GROUP BY
> wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10 "
>
> And it goes on from there.  You can see these errors at:
>
> http://trapezeswingers.homelinux.com/rlshow/
>
> You can also see that it works fine in the event category at:
>
> http://trapezeswingers.homelinux.com/rlshow/?cat=2
>
> The page views work, but no other category will display.
>
> Any ideas why this might be ?
>
> Thanks,
> Damon
> -- 
> "In Search of #6", a travelogue & memoire  by Damon Timm
> available for free online as an audiobook / podcast or to read at:
> http://www.damonjustisntfunny.com
>
> _______________________________________________
> EventCalendar mailing list
> EventCalendar at firetree.net
> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar