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

Also available in: Atom PDF