| Summary | Cannot create an event without a category in a Postgres back-end |
| Queue | Kronolith |
| Queue Version | 2.2-RC3 |
| Type | Bug |
| State | Resolved |
| Priority | 1. Low |
| Owners | chuck (at) horde (dot) org |
| Requester | paul.bohme (at) brivo (dot) com |
| Created | 05/13/2008 (6265 days ago) |
| Due | |
| Updated | 05/14/2008 (6264 days ago) |
| Assigned | 05/14/2008 (6264 days ago) |
| Resolved | 05/14/2008 (6264 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
Assigned to Chuck Hagenbuch
State ⇒ Resolved
New Attachment: kronolith_category.diff
State ⇒ Feedback
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Cannot create an event without a category in a Postgres back-end
Queue ⇒ Kronolith
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
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@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.