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

Fri, 09 Mar 2012 00:05:07 -0800 

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
_______________________________________________
TYPO3-german mailing list
TYPO3-german@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-german














    











					Antwort per Email an