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

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