[TYPO3-english] Errors on compare

[Jacco van der Post]

When I removed DBAL no more errors...

http://bugs.typo3.org/view.php?id=11486&nbn=3

Op 10-1-2011 11:45, Jacco van der Post schreef:
> 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
>
>
>
>
>
>


-- 
Met vriendelijke groet
Kind Regards

Jacco van der Post
Certified TYPO3 Integrator

Tel +31 (0)24 3602100

www.id-internetservices.com