Forums / Install & configuration / MySQL error when upgrading to 3.5 beta

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

MySQL error when upgrading to 3.5 beta

Previous topic

Install & configuration

Next topic

Author	Message
Fabrice Girardot	Wednesday 27 October 2004 10:01:48 am hi all, I have that <b>Error: eZMySQLDB</b> in the debug output when trying to access to the admin page. Query error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='. Query: SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='4974f801d11f0b8669ad14511306b234' what can I do ? -- Fabrice
Björn X	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.
Ł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

Author

Message

Fabrice Girardot

Wednesday 27 October 2004 10:01:48 am

hi all,

I have that <b>Error: eZMySQLDB</b> in the debug output when trying to access to the admin page.

Query error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='. Query: SELECT data, user_id, expiration_time FROM ezsession WHERE session_key='4974f801d11f0b8669ad14511306b234'

what can I do ?

--
Fabrice

Björn X

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.

Ł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