Issue Bug Closed

#18433Install-Tool creates SQL-Statements ending with ...)COLLATE=;

Erwin Hontheim 03/12/08, 14:44 updated 08/06/10, 13:20

Description

In Version 4.2.0beta3 the dabatase analyser generates each SQL-Statements ending with ….)COLLATE=; whereas version 4.2.0beta2a comes up with SQL-Statements each ending with ….);

The ….COLLATE= statement causes
a) warning messages
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/30/d11111111/htdocs/typo3cms/typo3_src-4.2.0beta3/t3lib/class.t3lib_db.php on line 1047

Warning: Cannot modify header information – headers already sent by (output started at /homepages/30/d111111/htdocs/typo3cms/typo3_src-4.2.0beta3/t3lib/class.t3lib_db.php:1047) in /homepages/30/d1111111/htdocs/typo3cms/typo3_src-4.2.0beta3/typo3/sysext/install/mod/class.tx_install.php on line 4860

b) no updates to the database after clicking “write to database”

With version 4.2.0beta2a the SQL statements get generated without the suffix …)COLLATE=; and tables get inserted into the database.

MySQL 4.0
PHP 5.2.7

Install-Tool
2: Database Analyser
Compare

Settings in 5: All Configuration
UTF8-filesystem yes
TTFLocaleConv = utf-8
setDBinit = SET NAMES utf-8; SET CHARACTER SET utf-8;
(issue imported from #M7841)

Reviews 0

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