[EventCalendar] Moving the database help ...

[Darrell Schulte]

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