[TYPO3-german] Nach Update v. 4.5.10 auf 4.5.12 folgende Probleme im Database Analyser

Patrick Zanker pzanker at fto.de
Fri Mar 9 09:01:00 CET 2012


hallo Typo3'ler,

soeben habe ich ein Update von 4.5.10 auf 4.5.12 durchgeführt. Habe 
zuvor noch sämtliche Extensions aktualisiert.

Wenn ich nun den Compare durchführe, erscheinen da immer noch Werte, 
Fehlermeldungen die da nicht so einfach weg wollen.

Changing fields

     select/deselect all
     ALTER TABLE cachingframework_cache_hash DROP KEY cache_id;
     ALTER TABLE cachingframework_cache_hash ADD KEY cache_id 
(identifier(256));
     ALTER TABLE sys_history DROP KEY recordident_1;
     ALTER TABLE sys_history ADD KEY recordident_1 (tablename(510),recuid);
     ALTER TABLE sys_history DROP KEY recordident_2;
     ALTER TABLE sys_history ADD KEY recordident_2 (tablename(510),tstamp);
     ALTER TABLE sys_refindex CHANGE tablename tablename text;
     Current value: varchar(80) default ''

     BLOB/TEXT column 'tablename' used in key specification without a 
key length
     ALTER TABLE sys_refindex CHANGE ref_table ref_table text;
     Current value: varchar(80) default ''

     BLOB/TEXT column 'ref_table' used in key specification without a 
key length
     ALTER TABLE sys_refindex DROP KEY lookup_string;
     ALTER TABLE sys_refindex ADD KEY lookup_string (ref_string(400));
     ALTER TABLE cachingframework_cache_pages DROP KEY cache_id;
     ALTER TABLE cachingframework_cache_pages ADD KEY cache_id 
(identifier(256));
     ALTER TABLE cachingframework_cache_pagesection DROP KEY cache_id;
     ALTER TABLE cachingframework_cache_pagesection ADD KEY cache_id 
(identifier(256));

Add tables

     select/deselect all
     CREATE TABLE cachingframework_cache_hash_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(256)) ) 
ENGINE=InnoDB;

     BLOB/TEXT column 'identifier' used in key specification without a 
key length
     CREATE TABLE sys_registry ( uid int(11) unsigned NOT NULL 
auto_increment, entry_namespace text NOT NULL, entry_key text NOT NULL, 
entry_value blob, PRIMARY KEY (uid), UNIQUE entry_identifier 
(entry_namespace,entry_key(256)) );

     BLOB/TEXT column 'entry_namespace' used in key specification 
without a key length
     CREATE TABLE cachingframework_cache_pages_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(256)) ) ENGINE=InnoDB;

     BLOB/TEXT column 'identifier' used in key specification without a 
key length
     CREATE TABLE cachingframework_cache_pagesection_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(256)) ) ENGINE=InnoDB;

     BLOB/TEXT column 'identifier' used in key specification without a 
key length
     CREATE TABLE tx_realurl_uniqalias ( uid int(11) NOT NULL 
auto_increment, tstamp int(11) NOT NULL default '0', tablename text NOT 
NULL, field_alias text NOT NULL, field_id varchar(120) NOT NULL default 
'', value_alias text NOT NULL, 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) );

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

Wie bekomme ich die da wieder weg??

Über eine Antwort würde ich mich sehr freuen.

Viele Grüße
Patrick


More information about the TYPO3-german mailing list