[kronolith] configuring kronolith for use w/ sql

[Chuck Hagenbuch]

Quoting Liam Hoekenga <liamr@umich.edu>:

> object(db_error)(10) { ["error_message_prefix"]=> string(0) ""
> ["error_prepend"]=> string(0) "" ["error_append"]=> string(0) ""
>  ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> int(-1)
> ["message"]=>
> string(23) "DB Error: unknown error" ["debuginfo"]=> string(0) ""
>  ["userinfo"]=> string(314) "SELECT DISTINCT e.event_id FROM
> kronolith_events e WHERE e.calendar_id = 'liamr' AND e.event_start >=
> {ts
>  '2001-09-01 00:00:00.000'} AND (e.event_end <= {ts '2001-09-30
> 23:59:59.999'} OR (e.event_recurEnddate <= {ts '2001-09-30
>  23:59:59.999'} AND e.event_recurType != 0)) [nativecode=ORA-00911:
> invalid character ]" ["callback"]=> NULL }

Hmm. Can you get more details running that query from sqlplus? Please don't 
tell me that oracle doesn't like that date format - I tried so hard to find 
something that both MySQL and SQL Server support. :)

> I guess I'm just trying to be too bleeding edge... experimental sql
> driver, using a database that only a minority use with this software. ;)

The problem is that I don't have an Oracle installation to play with, so it's 
very hard for me to test. And it's not exactly a lightweight app, so I'm 
hesitant to try putting it on one of my existing servers. But if you'll work 
with me, I'm happy to send you fixes and ideas until we get stuff working.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"What was and what may be lie, like children whose faces we cannot see, in the 
arms of silence. All we ever have is here, now." - Ursula K. Le Guin