Bug #24411
Updated by Alexander Opitz almost 10 years ago
Using the DB compare function shows the following erros: Error 1: BLOB/TEXT column 'pagepath' used in key specification without a key length SQL-Statement 1: CREATE TABLE tx_realurl_pathcache ( cache_id int(11) NOT NULL auto_increment, page_id int(11) NOT NULL default '0', language_id int(11) NOT NULL default '0', rootpage_id int(11) NOT NULL default '0', mpvar tinytext NOT NULL, pagepath text NOT NULL, expire int(11) NOT NULL default '0', PRIMARY KEY (cache_id), KEY pathq1 (rootpage_id,pagepath(32),expire), KEY pathq2 (page_id,language_id,rootpage_id,expire), KEY expire (expire) ) ENGINE=InnoDB; Error 2: Specified key was too long; max key length is 1000 bytes SQL-Statement 2: CREATE TABLE tx_realurl_uniqalias ( uid int(11) NOT NULL auto_increment, tstamp int(11) NOT NULL default '0', tablename varchar(255) NOT NULL default '', field_alias varchar(255) NOT NULL default '', field_id varchar(60) NOT NULL default '', value_alias varchar(255) NOT NULL default '', value_id int(11) NOT NULL default '0', lang int(11) NOT NULL default '0', expire int(11) NOT NULL default '0', PRIMARY KEY (uid), KEY tablename (tablename), KEY bk_realurl01 (field_alias(20),field_id,value_id,lang,expire), KEY bk_realurl02 (tablename(32),field_alias(20),field_id,value_alias(20),expire) ); Apache: 2.2.16 PHP Versionen: 5.2.14 mySQL Version: 5.0.91-community-log (issue imported from #M16839)