[Tickets #7001] Creating index on table hermes_deliverables fails

[bugs at horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/7001
------------------------------------------------------------------------------
  Ticket             | 7001
  Created By         | mail at dunix-data.de
  Summary            | Creating index on table hermes_deliverables fails
  Queue              | Hermes
  Version            | 1.0-RC1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


mail at dunix-data.de (2008-06-30 16:49) wrote:

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.