[TYPO3-ttnews] sql error in updating to tt_news 3.1.0

[Simon Child]

updating tt_news from 2.5.2 to 3.1.0 and applying database updates:

BLOB/TEXT column 'identifier' used in key specification without a key length

CREATE TABLE tt_news_cache_tags (
id int(11) unsigned NOT NULL auto_increment,
identifier text NOT NULL,
tag text NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier),
KEY cache_tag (tag(384))
) ENGINE=InnoDB;


This is because of trying to create a key on a text filed which apparently 
isn't allowed:

http://stackoverflow.com/questions/1827063/mysql-error-key-specification-without-a-key-length


Suggestions?

(as a workaround for now I have edited the sql so as not to create the 
identifier key).


Happy Christmas!

-- 
Simon Child