Closed (fixed)
Project:
Quotes
Version:
6.x-1.41
Component:
Upgrading
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
22 Feb 2011 at 08:57 UTC
Updated:
6 Apr 2011 at 17:41 UTC
Unique keys for text fields need a fixed length. Otherwise you get an error when creating quotes_authors:
WD php: BLOB/TEXT column 'name' used in key specification without a key length [error]
query: CREATE TABLE quotes_authors (
`aid` INT unsigned NOT NULL auto_increment,
`name` TEXT NOT NULL,
`bio` TEXT DEFAULT NULL,
PRIMARY KEY (aid),
UNIQUE KEY name (name)
)
A possible fix is to specify a fixed key length in the schema as follows:
'unique keys' => array('name' => array(array('name', 255))),
Regards
Racke
Comments
Comment #1
brulain commentedSubscribing.
Comment #2
ctmattice1 commentedFixed in 6.x-1.42 new release