Bug #18433
closed
Install-Tool creates SQL-Statements ending with ...)COLLATE=;
0%
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)
Files
Updated by Erwin Hontheim over 16 years ago
Holds true even when installing extensions which are updating the database
To my knowledge the COLLATE statement is only valid for MySQL 5.1 and higher!
Updated by Erwin Hontheim over 16 years ago
Just a typing error: Collate was established with MySQL 4.1
Proposed solution:
a) raise the required MySQL version up to 4.1 (would be bad for several TYPO3 installations)
b) Build in a switch which checks for the MySQL version to suppres the collate statement for MySQL versions below 4.1
Updated by Ingo Renner over 16 years ago
HI Michael,
did you notice this one? I guess this is a blocker for 4.2. What do you think?
Updated by Michael Stucki over 16 years ago
Indeed looks like something went wrong. I will look at it.
Updated by Michael Stucki over 16 years ago
I have dropped the collate statement now. See attached patch.