Tickets :: Comment on [#13311] install error when MyISAM

* Your Email Address
* Spam protection	Enter the letters below: \ /. ..__ .__.. . >< \ /[__)[__]\| \| / \ \/ \| \\| \|\|__\|
Comment	> 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 >
Attachment
Watch this ticket