6.0.0-alpha14
7/2/25

[#5211] Importing event with category name > 80 char fails
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

History
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

Saved Queries