[EventCalendar] Moving the database help ...

[Damon]

Both local machines use "localhost" in the config.php file; however,
recently, since I have been moving everything around so much, I have
only been testing it by running the following SQL query (which is what
throws the error when I do configure everything correctly and the
plugin is enabled):

SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND (post_date_gmt <=
'2006-09-09 12:23:59' AND id NOT IN
(-1,3,4,6,7,8,9,22,28,29,30,38,39,40,41,42,43,47,48,50,51,52,53,54,55,56,57,58,59,60,61,62,63)
) AND (post_status = "publish") AND post_status != "attachment" GROUP
BY wp_posts.ID ORDER BY post_date DESC LIMIT 0, 10;

When I run this SQL in phpMyAdmin or from the command line on the
original databases it works fine; when I back it up, move it to the
new linux server (with mysql 5.x), I get a "lost connection" error.
However, if I run it on a backed-up / restored databased on the older
mysql servers (4.x) I don't get this error when running the SQL query.
 Which leads me to believe maybe there is a problem moving from 4.x to
5.x ... again: I only get this error when this SQL is run (which
happens when the EventCalendar Plugin is enabled).

Does anyone have 5.x running without a problem ?

Thanks!
D



On 9/9/06, Darrell Schulte <d at schulte.mn> wrote:
>
> On Sep 9, 2006, at 9:40 AM, Damon wrote:
>
> > Yes - 2.0.4.  The only differences I can see is the mysql version
> > (because my hosted server is a linux box as well).
>
> Just to make sure...wp-config.php on both WordPress installs point
> different MySQL hosts, right?
>
> define('DB_HOST', '????');
>
> Darrell Schulte
> http://schulte.mn
>
>
>
> _______________________________________________
> 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