[Tickets #13311] install error when MyISAM

[noreply at bugs.horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/13311
------------------------------------------------------------------------------
  Ticket             | 13311
  Created By         | nethubonline at gmail.com
  Summary            | install error when MyISAM
  Queue              | Horde Groupware Webmail Edition
  Version            | 5.1.4
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


nethubonline at gmail.com (2014-07-02 08:40) wrote:

Actually the Horde Groupware Webmail Edition I am testing is 5.1.6,  
but not 5.1.4


When MySQL starting with "skip-innodb" and only uses MyISAM,  
webmail-install would generate the error below:

Fatal Error:
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key  
was too long; max key length is 1000 bytes
In /usr/share/psa-pear/pear/php/Horde/Db/Adapter/Pdo/Base.php on line 201


 From the MySQL query log, I can know that the last query which cause  
the problem:
CREATE  INDEX `index_horde_dav_objects_on_id_external` ON  
`horde_dav_objects` (`id_external`)

If innodb is enabled, there is no problem for the installation.

In Horde website, I can't find any info about innodb is required or  
not, so I expect Horde supports both MyISAM and InnoDB. So above error  
should be avoid for MyISAM DB?


I found it was reported before, however I think the solution of it  
(Changing to latin1) is not a final solution and not suitable for all  
Horde users.
http://lists.horde.org/archives/horde/Week-of-Mon-20140217/050689.html