Project

General

Profile

Actions
Copy link

Bug #18433

closed

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

Added by Erwin Hontheim over 16 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Michael Stucki
Category:
Install Tool
Target version:
-
Start date:
2008-03-12
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

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

bug_7841_db_compare_collate.diff (630 Bytes) bug_7841_db_compare_collate.diff Administrator Admin, 2008-04-01 21:30
Actions
Copy link

Also available in: Atom PDF