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

[Thomas Skierlo]

Quote: Markus Klein (liayn) wrote on Tue, 14 January 2014 18:27
----------------------------------------------------
> 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

Hi Markus,

I was searching the sources for parts of the query, but without finding any occurances. It's probably kind of assembled and therefore hard to find. After three days of struggling (not only with this issue) I'm kind of bananas. Are you on utf8_unicode_ci? 

Kind regards,

Thomas

> 
> > -----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
----------------------------------------------------