[kronolith] can't add events

[Jan Schneider]

Zitat von Erick Lopez <elopez at ues.edu.sv>:

> Thanks for your Reply Jan. The event right before that error is:
> [kronolith] SQL session setup by Administrator: query = "SET datestyle TO
> 'iso'" [on line 531 of "/var/www/horde/kronolith/lib/Driver/sql.php"]
> Eric.

I was rather talking about the log message with the sql statement below 
that causes this error.

> ---------- Original Message -----------
> From: Jan Schneider <jan at horde.org>
> To: kronolith at lists.horde.org
> Sent: Tue, 26 Apr 2005 10:00:51 +0200
> Subject: Re: [kronolith] can't add events
>
>> Zitat von Erick Lopez <elopez at ues.edu.sv>:
>>
>> > Hi all,
>> > It looks like many people have had this problem before. I just
>> > couldn't find a
>> > solution to it. I have the latest packages for Horde,IMP and 
>> Kronolith with a
>> > PostgreSQL backend. This is the error I am getting on my logs:
>> >
>> > [kronolith] DB Error: unknown error: SELECT event_id, event_uid,
>> > event_description, event_location, event_status, event_attendees,
>> > event_keywords, event_title, event_category, event_recurtype,
>> > event_recurenddate, event_recurinterval, event_recurdays, event_start,
>> > event_end, event_alarm, event_modified, event_exceptions, event_creator_id
>> > FROM kronolith_events WHERE calendar_id = 'Administrator' AND 
>> ((event_end >
>> > '-001-11-27 00:00:00' AND event_start < '2005-01-02 00:00:00') OR
>> > (event_recurenddate >= '-001-11-27 00:00:00' AND event_start <= 
>> '2005-01-02
>> > 00:00:00' AND event_recurtype <> 0)) [nativecode=ERROR:  invalid 
>> input syntax
>> > for type timestamp: "-001-11-27 00:00:00"] [on line 206 of
>> > "/var/www/horde/kronolith/lib/Driver/sql.php"]
>>
>> Set logging level to debug and post the last log entry before that error.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/