Tickets :: [#7715] Bookmarks silently truncated at 255 chars

6.0.0-beta1

11/5/25

Summary	Bookmarks silently truncated at 255 chars
Queue	Trean
Type	Bug
State	Resolved
Priority	2. Medium
Owners	Horde Developers (at) , mrubinsk (at) horde (dot) org
Requester	felix.leimbach (at) gmx (dot) net
Created	11/22/2008 (6192 days ago)
Due
Updated	11/25/2008 (6189 days ago)
Assigned	11/23/2008 (6191 days ago)
Resolved	11/25/2008 (6189 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

11/25/2008 05:51:13 PM	Michael Rubinsky	Comment #3 Assigned to Michael Rubinsky State ⇒ Resolved	Reply to this comment
Fixed along with some other warnings while I was poking around.

11/25/2008 05:47:39 PM	CVS Commit	Comment #2	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/diff.php/trean/scripts/sql/trean.sql?r1=1.4&r2=1.5&ty=u http://cvs.horde.org/co.php/trean/scripts/upgrades/2008-11-25_fix_url_lengths.sql?r=1.1

11/23/2008 05:37:16 PM	Chuck Hagenbuch	Assigned to Horde Developers State ⇒ Assigned

11/22/2008 09:28:00 PM	felix (dot) leimbach (at) gmx (dot) net	Comment #1 Priority ⇒ 2. Medium Type ⇒ Bug Summary ⇒ Bookmarks silently truncated at 255 chars Queue ⇒ Trean Milestone ⇒ Patch ⇒ No State ⇒ Unconfirmed	Reply to this comment
I found that some URLs I entered in Trean did not work properly when accessed. Investigating, I found that the URL is silently truncated at around 250 chars when you save a bookmark. The cause: The field bookmark_url in the trean_bookmarks DB table is of type VARCHAR(255). Changing to VARCHAR(8192) fixed the problem for me. Note that MySQL prior to version 5.0 has a maximum VARCHAR lengths of 255, so you might want to use the text type instead.