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

6.0.0-beta1

7/4/25

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	06/30/2008 (6213 days ago)
Due
Updated	06/30/2008 (6213 days ago)
Assigned	06/30/2008 (6213 days ago)
Resolved	06/30/2008 (6213 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch	No

06/30/2008 10:40:16 PM	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 10:39:29 PM	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 08:50:44 PM	Chuck Hagenbuch	Assigned to Jan Schneider State ⇒ Assigned

06/30/2008 08:49:03 PM	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.