Issue Bug Closed

#17074Install tool 123 mode only creates 26 out of 36 tables

Palahala 03/04/07, 03:38 updated 03/13/07, 15:18

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)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.