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

[Jigal van Hemert]

Hi,

On 24-12-2011 12:32, Simon Child wrote:
> 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;
>

In 3.1.0 the table definition reads:

#
# Table structure for table 'tt_news_cache_tags'
#
CREATE TABLE tt_news_cache_tags (
   id int(11) unsigned NOT NULL auto_increment,
   identifier varchar(128) DEFAULT '' NOT NULL,
   tag varchar(128) DEFAULT '' NOT NULL,
   PRIMARY KEY (id),
   KEY cache_id (identifier),
   KEY cache_tag (tag)
) ENGINE=InnoDB;

Maybe it's easiest to drop the index 'cache_id' first and then let the 
update script (Install Tool compare options) take care of the updates.

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert.