TYPO3 Core

Install Tool always shows this with the current TYPO3 4.3 svn trunk:

select/deselect all
    ALTER TABLE cache_pagesection DROP PRIMARY KEY;
    ALTER TABLE cache_pagesection ADD PRIMARY KEY (page_id,mpvar_hash);

I think there recently were fixes which should make DBAL work with the install tool flawlessly.
Is it still a problem in 4.4beta2 or newer?

After checking it myself: This still is an issue with 4.4beta3.

I had some errors on compare in install tool too, only with DBAL installed. When deinstalled, compare was succesfull.

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';

Did not give any info.

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

The engine problem is more general, this can be closed.