[EventCalendar] MySQL Error, MySQL 5.0.18

[Alex Tingle]

Hi Tobias,

On Thu, 09 Nov 2006 09:27:40 +0100
Tobias Baus <tobias at tobiasbaus.de> wrote:

> 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

Your "post timestamp" is set to a future date for your post 55
(landesmitgliederversammlung). Set it back to the date when you made the
post.

Out of interest, how did that time get set into the future? Did you set
it yourself?

Did you upgrade from v3.0? Sometimes the upgrade process would cause
this problem, but I thought I had fixed that.

-Alex

-- 
:: Let me solve your problems: http://www.firetree.net/consulting/
:: alex.tingle AT firetree.net  +44-7901-552763