Tickets :: [#5211] Importing event with category name > 80 char fails

6.0.0-alpha14

7/2/25

Summary	Importing event with category name > 80 char fails
Queue	Kronolith
Queue Version	HEAD
Type	Bug
State	Resolved
Priority	1. Low
Owners	jan (at) horde (dot) org
Requester	patrick.abiven (at) apitech (dot) fr
Created	04/04/2007 (6664 days ago)
Due
Updated	04/02/2008 (6300 days ago)
Assigned	03/14/2008 (6319 days ago)
Resolved	04/02/2008 (6300 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

04/02/2008 11:49:33 PM	Jan Schneider	Comment #6 Assigned to Jan Schneider State ⇒ Resolved	Reply to this comment
Alright, we cut them off at 80 chars now.

03/16/2008 03:13:16 AM	Chuck Hagenbuch	Comment #5	Reply to this comment
I would guess single digits.

03/14/2008 02:21:40 PM	Jan Schneider	Comment #4	Reply to this comment
I'm a bit hesitating to hardcode the limit inside the SQL code. It would of course be possible to cut off the categories at 80 chars. OTOH, how many people really do change the default SQL scheme that we provide with Kronolith?

03/14/2008 02:11:31 PM	patrick (dot) abiven (at) apitech (dot) fr	Comment #3	Reply to this comment
PostGreSQL Which database do you use? MySQL seems to truncate the category automatically.

03/14/2008 02:09:21 PM	Jan Schneider	Comment #2 Taken from Karsten Fourmont State ⇒ Feedback	Reply to this comment
Which database do you use? MySQL seems to truncate the category automatically.

03/14/2008 01:47:43 PM	Jan Schneider	Version ⇒ HEAD Queue ⇒ Kronolith

04/11/2007 01:48:53 PM	Jan Schneider	State ⇒ Assigned Assigned to Karsten Fourmont

04/04/2007 11:59:59 AM	patrick (dot) abiven (at) apitech (dot) fr	Comment #1 Priority ⇒ 1. Low Type ⇒ Bug Summary ⇒ Importing event with category name > 80 char fails Queue ⇒ Synchronization State ⇒ Unconfirmed	Reply to this comment
Hello In the kronolith_events table, the field event_category is defined as VARCHAR(80). But in kronolith/lib/Driver.php, the setCategory() function doesn't check the size of $category. So importing or synchronizing events having a category name greater than 80 char fails (DB Error: unknown error). A workaround is to reduce the $category to 80 char. Regards Patrick