6.0.0-git
2019-03-19

[#7300] Bug on running mysql upgrade
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 2008-09-06 (3846 days ago)
Due 09/07/2008 (3845 days ago)
Updated 2014-08-26 (1666 days ago)
Assigned
Resolved 2008-09-06 (3846 days ago)
Milestone
Patch No

History
2008-09-06 23:19:49 Chuck Hagenbuch State ⇒ Not A Bug
 
2008-09-06 22:41:08 tony (at) ai (dot) net (dot) nz Comment #2 Reply to this comment
Found my own mistake, should have used  3.1_to_3.2.mysql.sql





Sorry
2008-09-06 22:30:41 tony (at) ai (dot) net (dot) ns Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Summary ⇒ Bug on running mysql upgrade
Due ⇒ 2008-09-07
Queue ⇒ Horde Base
Milestone ⇒
Patch ⇒ No
Reply to this comment
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

Saved Queries