Share » Forums » Install & configuration » MySQL error when upgrading to 3.5 beta

MySQL error when upgrading to 3.5 beta

MySQL error when upgrading to 3.5 beta

Wednesday 27 October 2004 10:01:48 am - 2 replies

Author Message

Björn Dieding@xrow.de

Wednesday 27 October 2004 1:35:46 pm

I have seen that before... your charsets do not match

- Did you upgrade mysql too?

Make sure the following things

- the charset setting in the site.ini [DatabaseSettings] matches the settings you have in the whole DB
- if your charsets match try to convert the whole db with mysql again to your charset you assigned to the db.

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Łukasz Serwatka

Friday 12 November 2004 1:15:09 am

Hi
I have the same problem after upgrading MySQL from 4.0.21 to 4.1.7

Error: eZMySQLDB
Query error: Illegal mix of collations (latin2_general_ci,IMPLICIT) 
and (latin1_swedish_ci,COERCIBLE) for operation '='. 
Query: SELECT data FROM ezsession WHERE session_key='5a90c3f594e7ce22f798aaf19f074e2c'

What is the solution?

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu