Tickets :: [#7001] Creating index on table hermes_deliverables fails

Summary	Creating index on table hermes_deliverables fails
Queue	Hermes
Queue Version	1.0-RC1
Type	Bug
State	Resolved
Priority	1. Low
Owners	Jan Schneider <jan (at) horde (dot) org>
Requester	mail (at) dunix-data (dot) de
Created	06/30/2008 (143 days ago)
Due
Updated	06/30/2008 (143 days ago)
Assigned	06/30/2008 (143 days ago)
Resolved	06/30/2008 (143 days ago)
Attachments
Milestone
Patch	No

06/30/2008	Jan Schneider	Comment #3 State ⇒ Resolved	Reply to this comment
Fixed. The index on deliverable_name didn't make any sense anyway.

06/30/2008	CVS Commit	Comment #2	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/diff.php/hermes/docs/CHANGES?r1=1.37&r2=1.38&ty=u http://cvs.horde.org/diff.php/hermes/scripts/sql/hermes.sql?r1=1.14&r2=1.15&ty=u http://cvs.horde.org/diff.php/hermes/scripts/sql/hermes.xml?r1=1.1&r2=1.2&ty=u http://cvs.horde.org/co.php/hermes/scripts/upgrades/2008-07-01_deliverables_index.sql?r=1.1

06/30/2008	Chuck Hagenbuch	State ⇒ Assigned Assigned to Jan Schneider

06/30/2008	mail (at) dunix-data (dot) de	Comment #1 Patch ⇒ Milestone ⇒ Queue ⇒ Hermes Summary ⇒ Creating index on table hermes_deliverables fails Type ⇒ Bug Priority ⇒ 1. Low State ⇒ Unconfirmed	Reply to this comment
MySQL error message: ~~#1071~~ - Specified key was too long; max key length is 1000 bytes This only happens with UTF8 since it needs 3 bytes / character. Solution: shorten the client_id and/or deliverable_name field so that combined they are not longer than 333 characters.