[TYPO3-english] Errors on compare

[Jacco van der Post]

Hi

I have some errors on compare in install tool.

Either

You have an error in your SQL syntax; check the manual that corresponds 
to your MySQL server version for the right syntax to use near 'D' at line 1

or

Specified key was too long; max key length is 1000 bytes

the latter one happens when only trying to add RealUrl tables.

RealURL 1.10.1 and TYPO3 4.4.6, UTF-8 and [multiplyDBfieldSize] set to 1.


$GLOBALS['TYPO3_DB']->debugOutput = true;
$TYPO3_CONF_VARS['SYS']['displayErrors'] = '1';
$TYPO3_CONF_VARS['SYS']['sqlDebug'] = '1';
$TYPO3_CONF_VARS['FE']['debug'] = '1';

Does not give any info. Any help would be appreciated.





Changing fields

    1. select/deselect all
    2. ALTER TABLE cache_hash ENGINE=InnoDB;
       Current value: ENGINE=
    3. ALTER TABLE cachingframework_cache_hash ENGINE=InnoDB;
       Current value: ENGINE=
    4. ALTER TABLE cachingframework_cache_hash_tags ENGINE=InnoDB;
       Current value: ENGINE=
    5. ALTER TABLE cache_imagesizes ENGINE=InnoDB;
       Current value: ENGINE=
    6. ALTER TABLE sys_log ENGINE=InnoDB;
       Current value: ENGINE=
    7. ALTER TABLE cache_pages ENGINE=InnoDB;
       Current value: ENGINE=
    8. ALTER TABLE cache_pagesection ENGINE=InnoDB;
       Current value: ENGINE=
    9. ALTER TABLE cachingframework_cache_pages ENGINE=InnoDB;
       Current value: ENGINE=
   10. ALTER TABLE cachingframework_cache_pages_tags ENGINE=InnoDB;
       Current value: ENGINE=
   11. ALTER TABLE cachingframework_cache_pagesection ENGINE=InnoDB;
       Current value: ENGINE=
   12. ALTER TABLE cachingframework_cache_pagesection_tags ENGINE=InnoDB;
       Current value: ENGINE=
   13. ALTER TABLE cache_typo3temp_log ENGINE=InnoDB;
       Current value: ENGINE=
   14. ALTER TABLE cache_md5params ENGINE=InnoDB;
       Current value: ENGINE=
   15. ALTER TABLE cache_treelist ENGINE=InnoDB;
       Current value: ENGINE=
   16. ALTER TABLE fe_session_data ENGINE=InnoDB;
       Current value: ENGINE=
   17. ALTER TABLE fe_sessions ENGINE=InnoDB;
       Current value: ENGINE=
   18. ALTER TABLE index_phash ENGINE=InnoDB;
       Current value: ENGINE=
   19. ALTER TABLE index_fulltext ENGINE=InnoDB;
       Current value: ENGINE=
   20. ALTER TABLE index_rel ENGINE=InnoDB;
       Current value: ENGINE=
   21. ALTER TABLE index_words ENGINE=InnoDB;
       Current value: ENGINE=
   22. ALTER TABLE index_section ENGINE=InnoDB;
       Current value: ENGINE=
   23. ALTER TABLE index_grlist ENGINE=InnoDB;
       Current value: ENGINE=
   24. ALTER TABLE index_stat_search ENGINE=InnoDB;
       Current value: ENGINE=
   25. ALTER TABLE index_stat_word ENGINE=InnoDB;
       Current value: ENGINE=
   26. ALTER TABLE tx_realurl_chashcache ENGINE=InnoDB;
       Current value: ENGINE=
   27. ALTER TABLE tx_realurl_urldecodecache ENGINE=InnoDB;
       Current value: ENGINE=
   28. ALTER TABLE tx_realurl_urlencodecache ENGINE=InnoDB;
       Current value: ENGINE=

Add tables

    1. select/deselect all
    2. 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;
    3. 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) );

Drop tables (really!)

    1. select/deselect all
    2. DROP TABLE zzz_deleted_tx_femp3player_playlists;
       Records in table: 2
    3. DROP TABLE zzz_deleted_tx_mediacenter_item;
       Records in table: 8
    4. DROP TABLE zzz_deleted_tx_realurl_chashcache;
       Records in table: 273
    5. DROP TABLE zzz_deleted_tx_realurl_errorlog;
       Records in table: 133402
    6. DROP TABLE zzz_deleted_tx_realurl_pathcache;
       Records in table: 192
    7. DROP TABLE zzz_deleted_tx_realurl_redirects;
    8. DROP TABLE zzz_deleted_tx_realurl_uniqalias;
       Records in table: 90
    9. DROP TABLE zzz_deleted_tx_realurl_urldecodecache;
       Records in table: 47
   10. DROP TABLE zzz_deleted_tx_realurl_urlencodecache;
       Records in table: 209






-- 
Kind Regards

Jacco van der Post