[kronolith] Kronolith2.0.5 + oracle 10g

[samer khalil]

Hi,
You can add events to a calendar but nothing shows up when you view it
allthoug event are added to the DB.
I've checked the list archives, and the previous reference to this issue was
solved by setting:
nls_date_format = 'yyyy-mm-yy hh24:mm:ss'

with this latest version kronolith sets already nls_date_format correctly.
 when I enabled debug mode i got two sql statements. I executed them from
sqlplus:
One returned all events for the month.

The second (see below) didn't return any rows:

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 = '02b026cb5f21d43b4ade38a2ecb5c3f7'
and ((event_end > '2005-10-30 00:00:00'
AND event_start < '2005-12-0500:00:00')
OR (event_recurenddate >= '2005-10-30 00:00:00'
AND event_start <= '2005-12-05 00:00:00'
AND event_recurtype <> 0))

The begining of the clause condition should be "where event_id='.....' and
calendar_id shoulb be equal to the user.
Also the event_id '02b026cb5f21d43b4ade38a2ecb5c3f7' doesn't exist in my
database!

Could it be a bug ? could you guys shed some light on?

Thanks
Samer