[kronolith] Kronolith2.0.5 + oracle 10g

[Chuck Hagenbuch]

Quoting samer khalil <samerk1 at gmail.com>:

> 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!

There is no event_id in the query WHERE at all. You mean calendar_id?

-chuck

-- 
"So we're talking near-sonic speeds for a vegetable."
Reasons to go to the Punkin Chunkin World Championships