[EventCalendar] Moving the database help ...

[Damon]

Hi again!  Sorry I didn't send it to the list!  I just hit reply.  Whoops.

I am running 3.0.4; when I disable the plugin, everything works fine (except
calls to the plugin functions).  I suspected it might be EC related because
with the plugin activated, I get the "lost connection" error on all posts in
every category except the EC-event-category (that I specificied).  Those
posts show without a problem.

Wierd?





On 9/5/06, Alex Tingle <alex at firetree.net> wrote:
>
> Hi Damon
>
> Please send replies to the list. I'm not the only one who can help you.
>
> On 5 Sep 2006, at 19:00, Damon wrote:
> > You may have to help me out here, as I am not as savvy as I may let on.
> > What I did to move everything was call a mysqldump:
> >
> > $ mysqldump --add-drop-table -h localhost -u root -p wordpress | bzip2
> > -c >
> > wordpress.backup.sql.bz2
> >
> > Then uncompressed and loaded that file into a new database I had
> > created on
> > the other system:
> >
> > $ mysql -h localhost -u root -p wordpress-new < wordpress.backup.sql
>
> OK. That looks fine.
>
>
> > Like I said, seems to work (except for this plugin).  Now, if I run the
> > command you quoted in mysql here is what happens:
> >
> > mysql> 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;
> > ERROR 2013 (HY000): Lost connection to MySQL server during query
> > mysql>
>
> Ugh! What about your MySQL error log?
>
> (You are clearly running ec3.0.x - just an observation.)
>
>
> > If I run the "DESC wp_posts;" command I get this:
> > <snip>
>
> That looks fine too.
>
>
> > Thanks sooooooo much for your help !!!  Hope the answer is obvious.
> > Has
> > this never happened before ?
>
> It doesn't look like your problem is really EC related. What happens if
> you disable the event calendar plugin?
>
> -Alex
>
> --
>
> >
> >
> > On 9/5/06, Alex Tingle <alex at firetree.net> wrote:
> >>
> >> 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
> >>
> >>
> >> _______________________________________________
> >> EventCalendar mailing list
> >> EventCalendar at firetree.net
> >> http://penguin.firetree.net/cgi-bin/mailman/listinfo/eventcalendar
> >>
> >
> >
> >
> > --
> > "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
>



-- 
"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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://penguin.firetree.net/pipermail/eventcalendar/attachments/20060905/a111520e/attachment.htm