Forums / Install & configuration / MySQL error when upgrading to 3.5 beta
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