[EventCalendar] MySQL Error, MySQL 5.0.18

Tobias Baus tobias at tobiasbaus.de
Thu Nov 9 08:27:40 UTC 2006


Hello!

I'm using Event Calendar 3.1.0 in Wordpress 2.0.5. It works wonderful on 
my Powerbook with Firefox (2.0). But it don't works, for example, under 
Safari, or in Firefox in Windows. In Windows, I see the calendar, but 
when I click on a post, I receive a MySQL error:

WordPress database error: [You have an error in your SQL syntax; check 
the manual that corresponds to your MySQL server version for the right 
syntax to use near 'ORDER BY post_date ASC LIMIT 1' at line 1]
SELECT ID,post_title FROM wp_posts WHERE post_date > '' AND post_date < 
'2006-11-09 10:22:03' AND post_status = 'publish' AND ID != ORDER BY 
post_date ASC LIMIT 1

By the way, the site I talk about, is www.gj-neunkirchen.de. You can try 
it, perhabs it's a known error.

In the FAQ of EventCalendar (http://wpcal.firetree.net/faq/) is an entry 
for database errors, but I'm using the Version 5.0.18 of MySQL.

I postet my problem in a german forum about Wordpress 
(http://forum.wordpress-deutschland.org/showthread.php?t=13766), they 
said me the problem is a missing ID and I should contact the developer.


Tobias

PS: I hope you'll understand my request, my english is not the best. ;)



More information about the EventCalendar mailing list