Bug #24411
closedError messages using DB compare function with tables definitions from real_url extension
0%
Description
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)