[TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error
Thomas Skierlo
tsk at pix-pro.eu
Tue Jan 14 17:48:42 CET 2014
Hi,
I'm currently trying to get TYPO3 6.2.0 (yesterdays master, fresh install) to work with utf8_unicode_ci collation (instead of utf8_general_ci), but whenever I click on "Update Wizard" in the Install Tool, I'm getting this mySQL Error:
llegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '<>'
My my.cnf:
[mysqld]
character-set-server=utf8
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
To make absolutely sure I created an empty database with explicit collation utf8_unicode_ci
before I started TYPO3 setup. Right after setup I checked all tables as well as the database. All on "utf8_unicode_ci", looking perfect.
DB Check just loved everythink. Everything "green".
Unless I click on "Update Wizard" in the Install Tool. Doing so it gives me an SQL Error:
exec_SELECTquery
ERROR: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '<>'
lastBuiltQuery : SELECT COUNT(uid) FROM tt_content WHERE media <> '' AND CAST(CAST(media AS DECIMAL) AS CHAR) <> media OR (CType = 'uploads' AND select_key != '')
There are two possible scenarios for an error like this:
1) A collation (utf8_general_ci) is hardcoded in an SQL query
2) Database and/or table/field has wrong collation
Made an sql dump of the whole database and searched for "utf8_general_ci". No results. Did the same with all sources. No result.
Again: A clean install. No data at all, no template. No extensions. Just the default setup out of the box.
Opened an Issue yesterday (http://forge.typo3.org/issues/54952), just to find another one today, which is 16 month old: http://forge.typo3.org/issues/36754
Now my questions:
1) Is there a general problem with "utf8_unicode_ci" in TYPO3 6.2.0?
2) If not, can anyone confirm it working under 6.2.0 without this error?
3) Or is there a general problem with a click on the "Update Wizard" (independant of any collation issues)
4) Should I better use "utf8_general_ci"? Wouldn't like to do that, but would do, if it cures the problem.
I'm on Ubuntu 12.04LTS, php 5.3.10, MySQL 5.5
Thanks for any help,
Thomas
More information about the TYPO3-english
mailing list