TYPO3 Core

Please turn on the "sqlDebug" in the Install-Tool at "All configuration" and tell us the SQL statements producing errors/warnings.

Please turn on the "sqlDebug" in the Install-Tool

Ok, nice feature!

First of all note that after running the steps given in the bug report above, my problem was solved. So if others do not suffer this then that might be all right, as I know I'm using an old version of MySQL and PHP (but I cannot find any minimum MySQL version on pages such as http://typo3.org/about/system-requirements/ )

To enhance this bug report I enabled the debug mode and ran 123 mode again to see if any errors were shown. In detail:

- enabled SQL debug mode
- used a standalone installation of phpMyAdmin to drop all tables
- explicitly started 123 mode using /typo3/install/index.php?mode=123&step=1
- as I did not replace localconf.php with a clean copy, the database name etc. were already known this time, so I just clicked Continue in steps 1 and 2
- step 3, "Please select a database dump", only gave me a single option: "Create default database tables"
- now, with the debug enabled, the next screen showed the errors below, and no "Done" screen at all
- manually going to /typo3/install/ allowed me to run the Database Analyser, to fix the missing tables using the Compare option; problem fixed

Final note: I do not have root access to the database. So, the credentials I entered were those of a user of an existing, empty database.

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 7
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 9
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near ')' at line 14
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 21
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 14
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 7
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 7
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 7
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 9
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDB' at line 6
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR You have an error in your SQL syntax near 'ENGINE=InnoDb' at line 11
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

caller t3lib_DB::admin_query
ERROR Key column 'pid' doesn't exist in table
lastBuiltQuery
debug_backtrace require // tx_install->init // tx_install->checkthedatabase // t3lib_db->admin_query // t3lib_db->debug

Warning: Cannot modify header information - headers already sent by (output started at /web/typo3_src-4.1.0RC2/t3lib/class.t3lib_db.php:1094) in /web/typo3_src-4.1.0RC2/typo3/sysext/install/mod/class.tx_install.php on line 3649

Just in case this should not have happened either: following the procedure above, upon first login in the BE I get

"The Reference Index table is empty which is likely to be the case because you just upgraded your TYPO3 source. Please go to Tools>DB Check and update the reference index."

This is, of course, easily solved by following the instructions that are given, so not a problem.

I just rechecked this and found out that there is indeed a problem with the 1-2-3 wizard: Due to a typo in the SQL definition, the table "sys_history" is not created automatically. I will take care of this problem.

Fixed in 4.1