[Tickets #6696] Cannot create an event without a category in a Postgres back-end

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/6696
-----------------------------------------------------------------------
 Ticket             | 6696
 Created By         | paul.bohme at brivo.com
 Summary            | Cannot create an event without a category in a
Postgres back-end
 Queue              | Kronolith
 Version            | 2.2-RC3
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Milestone          |
 Patch              |
 Owners             |
-----------------------------------------------------------------------


paul.bohme at brivo.com (2008-05-13 15:38) wrote:

If you create an event without a category, and are using the pgsql
database, it attempts to insert a boolean FALSE into a character field, and
postgres gives the following error:

Error
There was an error adding the event: 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_modified, event_start,
event_end, event_alarm, event_recurtype, calendar_id) VALUES
('67ce2d1f0f0951b7cf0b69f316d81a17',
'20080513150806.19221xhjov4jgvmo at kaizen.brivo.net', 'paul.bohme', 'Event',
'', FALSE, '', 0, '2', 'a:0:{}', '', 1210705686, '2008-05-13 06:00:00',
'2008-05-13 07:00:00', 0, 0, 'paul.bohme') [nativecode=ERROR: column
"event_category" is of type character varying but expression is of type
boolean LINE 1: ...event_creator_id, event_title, event_description,
event_cate... ^ HINT: You will need to rewrite or cast the expression.]

Postgres 8.2.6.