[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