| Summary | Bug on running mysql upgrade |
| Queue | Horde Base |
| Queue Version | 3.2.1 |
| Type | Bug |
| State | Not A Bug |
| Priority | 1. Low |
| Owners | |
| Requester | tony (at) ai (dot) net (dot) ns |
| Created | 09/06/2008 (6292 days ago) |
| Due | 09/07/2008 (6291 days ago) |
| Updated | 08/26/2014 (4112 days ago) |
| Assigned | |
| Resolved | 09/06/2008 (6292 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
Sorry
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Bug on running mysql upgrade
Due ⇒ 09/07/2008
Queue ⇒ Horde Base
Milestone ⇒
Patch ⇒ No
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