[EventCalendar] Moving the database help ...

[Alex Tingle]

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