Project

General

Profile

Actions

Bug #17074

closed

Install tool 123 mode only creates 26 out of 36 tables

Added by Palahala over 17 years ago. Updated over 17 years ago.

Status:
Closed
Priority:
Should have
Category:
Install Tool
Target version:
-
Start date:
2007-03-04
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.1
PHP Version:
4.3
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

A fresh installation of 4.1RC2 gave me a lot of "supplied argument is not a valid MySQL result resource", and made it impossible to get into the BE. I think this is a big problem for new users.

Back in the install tool clicking Compare in the Database Analyser gave me a list of 10 CREATE TABLE statements for cache_hash, cache_imagesizes, sys_history, sys_log, cache_pages, cache_pagesection, cache_typo3temp_log, cache_md5params, fe_session_data and fe_sessions.

Having the install tool write those changes to the database solved the problems.

Using "Compare with $TCA" now still tells me static_tsconfig_help and tx_impexp_presets are in the database, but not in TCA, and shows me a lot of other differences such as "Fields from database, but not in $TCA" and "Actual and suggested field definitions". Probably not an issue.

The database already existed; as I do not have enough rights on this machine to create a new database, I dropped all existing tables (actually an old TYPO3 installation) using phpMyAdmin before I deleted all the old TYPO3 files and installed the fresh copy of TYPO3. I think any indexes et cetera will also have been deleted at that point.

In 123 mode I could only select "Create default database tables" and click "Import database".

MySQL 3.23.56-Max, PHP 4.3.10, Linux

On the (empty) site, before showing "No pages are found on the rootlevel"
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /web/typo3_src-4.1.0RC2/t3lib/class.t3lib_db.php on line 79

Warning: Cannot modify header information - headers already sent by (output started at /web/typo3_src-4.1.0RC2/t3lib/class.t3lib_db.php:796) in /web/typo3_src-4.1.0RC2/t3lib/class.t3lib_userauth.php on line 311

When trying to login to the BE:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /web/typo3_src-4.1.0RC2/t3lib/class.t3lib_db.php on line 796

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /web/typo3_src-4.1.0RC2/t3lib/class.t3lib_db.php on line 783

Warning: Cannot modify header information - headers already sent by (output started at /web/typo3_src-4.1.0RC2/t3lib/class.t3lib_db.php:796) in /web/typo3_src-4.1.0RC2/t3lib/class.t3lib_userauth.php on line 311

(issue imported from #M5125)


Files

bug_5125.diff (2.57 KB) bug_5125.diff Administrator Admin, 2007-03-04 16:45
Actions #1

Updated by Oliver Hader over 17 years ago

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

Actions #2

Updated by Palahala over 17 years ago

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

Actions #3

Updated by Palahala over 17 years ago

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.

Actions #4

Updated by Michael Stucki over 17 years ago

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.

Actions #5

Updated by Michael Stucki over 17 years ago

Fixed in 4.1

Actions

Also available in: Atom PDF