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

6.0.0-beta13

4/11/26

Summary	Creating index on table hermes_deliverables fails
Queue	Hermes
Queue Version	1.0-RC1
Type	Bug
State	Resolved
Priority	1. Low
Owners	jan (at) horde (dot) org
Requester	mail (at) dunix-data (dot) de
Created	6/30/08 (6494 days ago)
Due
Updated	6/30/08 (6494 days ago)
Assigned	6/30/08 (6494 days ago)
Resolved	6/30/08 (6494 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

30.06.2008 22:40:16	Jan Schneider	Comment #3 State ⇒ Resolved	Reply to this comment
Fixed. The index on deliverable_name didn't make any sense anyway.

30.06.2008 22:39:29	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

30.06.2008 20:50:44	Chuck Hagenbuch	Assigned to Jan Schneider State ⇒ Assigned

30.06.2008 20:49:03	mail (at) dunix-data (dot) de	Comment #1 Priority ⇒ 1. Low Type ⇒ Bug Summary ⇒ Creating index on table hermes_deliverables fails Queue ⇒ Hermes Milestone ⇒ Patch ⇒ No 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.