[EventCalendar] Moving the database help ...

Damon damonjustisntfunny at gmail.com
Sat Sep 9 16:06:26 UTC 2006


Hi, sorry, no -- that didn't solve the problem.  I am using that query
because that is the first error being generated when I look at my home
page:

http://tps.homelinux.com/rlshow/

If I use that (adding double quotes):

 SELECT DISTINCT * FROM wp_posts WHERE 1=1 AND (post_date_gmt <=
"2006-09-09 15:58: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

Didn't change anything.  I tried the same string (copy paste) on the
restored backup on the Mac and it works like it should; same restored
backup on the linux box doesn't.  Hmm!  Still get the "lost connection
to mysql during query" error.

I would like to think I am doing something wrong on my end, but I have
gone step by step, repeating each movement on the Mac (mysql 4.x) and
the Linux box (mysql 5.x) and the linux throws the error while the mac
does not.  I may look into "downgrading" my mysql server and seeing if
that helps.  But, then again, if yours works without a problem that
gives me some hope.  I have 5.0.22 running.

D

On 9/9/06, Darrell Schulte <d at schulte.mn> wrote:
>
> On Sep 9, 2006, at 10:11 AM, Damon wrote:
>
> > 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;
>
> Don't know where this query comes from exactly, but it throws an
> error for me using MySQL 5.0.19. Changing from single quotes to
> double for the post_date_gmt produces successful results.
>
> 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;
>
> See: http://bugs.mysql.com/bug.php?id=21009
>       http://bugs.mysql.com/bug.php?id=19518
>
> Does modifying the query solve this issue for you?
>
> 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



More information about the EventCalendar mailing list