[kronolith] can't add events

Jan Schneider jan at horde.org
Fri May 6 02:58:50 PDT 2005


Please file a bug report on bugs.horde.org.

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

> Jan, sorry about the confusion, here it is:
> [kronolith] SQL event list by Administrator: query = "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 = ? AND ((event_end > ? AND
> event_start < ?) OR (event_recurenddate >= ? AND event_start <= ? AND
> event_recurtype <> ?))" [on line 201 of
> "/var/www/horde/kronolith/lib/Driver/sql.php"]
>
> ---------- Original Message -----------
> From: Jan Schneider <jan at horde.org>
> To: Erick Lopez <elopez at ues.edu.sv>
> Cc: kronolith at lists.horde.org
> Sent: Tue, 26 Apr 2005 15:56:45 +0200
> Subject: Re: [kronolith] can't add events
>
>> 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/
> ------- End of Original Message -------
>
>



Jan.

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



More information about the kronolith mailing list