[Tickets #3708] NEW: event_private breaks kronolith w/ Postgres

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=3708
-----------------------------------------------------------------------
 Ticket             | 3708
 Created By         | horde at sthias.de
 Summary            | event_private breaks kronolith w/ Postgres
 Queue              | Kronolith
 Version            | HEAD
 State              | Unconfirmed
 Priority           | 3. High
 Type               | Bug
 Owners             | 
-----------------------------------------------------------------------


horde at sthias.de (2006-03-29 07:39) wrote:

Adding a new event fails with following error:
DB is PostgreSQL 8.1
event_private field is of type    "integer DEFAULT 0 NOT NULL"

DB Error: unknown error : INSERT INTO kronolith_events (event_id, event_uid,
event_creator_id, event_title, event_description, event_category,
event_location, event_private, event_status, event_attendees,
event_keywords, event_exceptions, event_modified, event_start, event_end,
event_alarm, event_recurtype, calendar_id) VALUES
('0034644e66b84a0b96e341f669a60c70', '20060329173255.6git4hjidr40 at x.y',
'seth', '', '', '', '', FALSE, '2', 'a:0:{}', '', '', 1143646375,
'2006-03-29 12:00:00', '2006-03-29 13:00:00', 0, '0',
'174968920bc65ce6a9916a77a8979eb9') 
[nativecode=ERROR: column "event_private" is of type integer but expression
is of type boolean HINT: You will need to rewrite or cast the expression.].