6.0.0-alpha14
7/2/25

[#14353] Shared calendar are truncating Description tab (only shows up 256 characters)
Summary Shared calendar are truncating Description tab (only shows up 256 characters)
Queue Kronolith
Queue Version 4.2.11
Type Bug
State Resolved
Priority 1. Low
Owners Horde Developers (at) , mrubinsk (at) horde (dot) org
Requester albert.solana (at) upcnet (dot) es
Created 05/04/2016 (3346 days ago)
Due
Updated 05/16/2016 (3334 days ago)
Assigned 05/06/2016 (3344 days ago)
Resolved 05/16/2016 (3334 days ago)
Github Issue Link
Github Pull Request
Milestone 5
Patch No

History
05/16/2016 04:42:37 PM Michael Rubinsky State ⇒ Resolved
 
05/12/2016 09:11:07 PM Git Commit Comment #6 Reply to this comment
Changes have been made in Git (master):

commit f66d2d1caf346da34c30619a33edd6b9e1c75a10
Author: Michael J Rubinsky <mrubinsk@horde.org>
Date:   Thu May 12 17:08:54 2016 -0400

     Bug: 14353 Make calendar descriptions a text field.

  .../27_kronolith_upgrade_description_totext.php    | 41 
++++++++++++++++++++++
  1 file changed, 41 insertions(+)

http://github.com/horde/horde/commit/f66d2d1caf346da34c30619a33edd6b9e1c75a10
05/09/2016 01:33:57 PM Michael Rubinsky Comment #5 Reply to this comment
Depends on Bug: 14357
05/06/2016 01:44:48 PM Michael Rubinsky State ⇒ Assigned
 
05/06/2016 01:18:24 PM Michael Rubinsky Milestone ⇒ 5
 
05/06/2016 01:18:02 PM Michael Rubinsky Comment #4 Reply to this comment
We would appreciate that you could increase the 256 characters limit 
on description tab in next versions.
This won't likely happen until Kronolith 5 / Horde 6. However, you can 
change the definition of the column on your own directly in MySQL to 
type 'text'.

Depending on what share backend you are using (SQL or SQL-NG), you 
would do something like this:

ALTER TABLE kronolith_sharesng MODIFY COLUMN attribute_desc text;

or
ALTER TABLE kronolith_shares MODIFY COLUMN attribute_desc text;
05/04/2016 05:47:43 PM albert (dot) solana (at) upcnet (dot) es Comment #3 Reply to this comment
I will assume you are using SQL for the share system?
Yes, we are using a MySQL database

[Show Quoted Text - 10 lines]
I've checked again this issue.

I've seen that Agenda Description shows more than 256 characters while 
user don't logout, perhaps full description remains in a internal 
variable without the 256 char restriction.

But after you do logout, you will see only 256 characters on next 
login, so it's limited in SQL database as you has explained.

This weird effect provokes that users complain because they doesn't 
notice that  saved description is truncated until next login.
We will need to change the schema for the description field, but 
this will probably have to wait until Horde 6 since there are 
already new migrations added for Kronolith unless another developer 
has an idea on how to add a ".5" migration...
We would appreciate that you could increase the 256 characters limit 
on description tab in next versions.
05/04/2016 03:29:54 PM Michael Rubinsky Comment #2
Assigned to Michael Rubinsky
Assigned to Horde DevelopersHorde Developers
State ⇒ Feedback
Reply to this comment
I will assume you are using SQL for the share system?
UserA creates CalendarA, its  Description tab has more than 256 
characters, then CalendarA is shared with several other users, i.e. 
userB.
This is because the database schema limits the description field to 256.
CalendarA retains the complete Description when it's saved.
Not sure how this is happening, it should be truncated on the original 
save as well.

We will need to change the schema for the description field, but this 
will probably have to wait until Horde 6 since there are already new 
migrations added for Kronolith unless another developer has an idea on 
how to add a ".5" migration...
05/04/2016 12:40:44 PM albert (dot) solana (at) upcnet (dot) es Comment #1
State ⇒ Unconfirmed
Patch ⇒ No
Milestone ⇒
Queue ⇒ Kronolith
Summary ⇒ Shared calendar are truncating Description tab (only shows up 256 characters)
Type ⇒ Bug
Priority ⇒ 1. Low
Reply to this comment
UserA creates CalendarA, its  Description tab has more than 256 
characters, then CalendarA is shared with several other users, i.e. 
userB.

CalendarA retains the complete Description when it's saved.

Then UserB has CalendarA as a shared calendar, but he only can see 256 
caracters as much in CalendarA Description tab.

Some Calendars have relevant descriptions and the truncated 
information are causing issues to our users.

Saved Queries