[Tickets #7300] Bug on running mysql upgrade

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/7300
------------------------------------------------------------------------------
  Ticket             | 7300
  Created By         | tony at ai.net.ns
  Summary            | Bug on running mysql upgrade
  Queue              | Horde Base
  Version            | 3.2.1
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


tony at ai.net.ns (2008-09-06 18:30) wrote:

When running:
mysql -uroot horde -ppassword< 3.1_to_3.2.sql

We get:
ERROR 1170 (42000) at line 89: BLOB/TEXT column 'attribute_value' used  
in key specification without a key length

Offending line is:
CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes  
(attribute_value);

This fixed the issue, taken from  create.mysql.sql:
CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes  
(attribute_value(255));

thanks