[Tickets #7300] Re: Bug on running mysql upgrade

[noreply at bugs.horde.org]

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

Ticket URL: https://bugs.horde.org/ticket/7300
------------------------------------------------------------------------------
  Ticket             | 7300
  Updated By         | hunde.reggassa at gmail.com
  Summary            | Bug on running mysql upgrade
  Queue              | Horde Base
  Version            | 3.2.1
  Type               | Bug
  State              | Not A Bug
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


hunde.reggassa at gmail.com (2014-08-26 14:06) 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