[TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error

[Markus Klein]

Hi!

Did you check what CAST(CAST(media AS DECIMAL) AS CHAR) <> media does?
Maybe cast() changes the charset implicitly.

Kind regards
Markus

------------------------------------------------------------
Markus Klein
TYPO3 CMS Active Contributors Team Member

> -----Original Message-----
> From: typo3-english-bounces at lists.typo3.org [mailto:typo3-english-
> bounces at lists.typo3.org] On Behalf Of Thomas Skierlo
> Sent: Tuesday, January 14, 2014 5:49 PM
> To: typo3-english at lists.typo3.org
> Subject: [TYPO3-english] 6.2.0 Install Tool Update Wizard: MySQL-Error
> 
> 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
> _______________________________________________
> TYPO3-english mailing list
> TYPO3-english at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english