[kronolith] configuring kronolith for use w/ sql

[Cliff Green]

On Tue, 18 Sep 2001, Chuck Hagenbuch wrote:

CH> Quoting Liam Hoekenga <liamr@umich.edu>:
CH>
CH> > object(db_error)(10) { ["error_message_prefix"]=> string(0) ""
CH> > ["error_prepend"]=> string(0) "" ["error_append"]=> string(0) ""
CH> >  ["mode"]=> int(1) ["level"]=> int(1024) ["code"]=> int(-1)
CH> > ["message"]=>
CH> > string(23) "DB Error: unknown error" ["debuginfo"]=> string(0) ""
CH> >  ["userinfo"]=> string(314) "SELECT DISTINCT e.event_id FROM
CH> > kronolith_events e WHERE e.calendar_id = 'liamr' AND e.event_start >=
CH> > {ts
CH> >  '2001-09-01 00:00:00.000'} AND (e.event_end <= {ts '2001-09-30
CH> > 23:59:59.999'} OR (e.event_recurEnddate <= {ts '2001-09-30
CH> >  23:59:59.999'} AND e.event_recurType != 0)) [nativecode=ORA-00911:
CH> > invalid character ]" ["callback"]=> NULL }
CH>
CH> Hmm. Can you get more details running that query from sqlplus? Please don't
CH> tell me that oracle doesn't like that date format - I tried so hard to find
CH> something that both MySQL and SQL Server support. :)

Can't say about Oracle, but PostgreSQL doesn't like it.

c
-- 
Clifford Green               Internet -  green@umdnj.edu
Academic Computing Services                    UMDNJ-IST
If we aren't supposed to eat animals, why are they made of meat?