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

brulain’s picture

Subscribing.

ctmattice1’s picture

Status: Active » Fixed

Fixed in 6.x-1.42 new release

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.