1267 illegal mix of collations error

[tempus]

Hallo
After installation appears General error 1267 illegal mix of collations.
Simptoms - problems on load with mail and cases functionality.
I am using ukrainian version.

[tempus]

Can some body help?

[tanya]

Hi
Check database tables CHARACTER and COLATE

http://www.javaquery.com/2014/04/error-code-1267-illegal-mix-of.html

[tempus]

Most changes they advice are in the core code (not a good idea for me I think) or in MySql server (but I use virtual hosting and don't have so much privileges)
I have tried out changing collations in the data base, but got "Bad server responce" and white screen in the browser.

[tanya]

Hello
I just shown you as example normal table charset configuration.
It was not a guide to modify configuration of your mysql server.
But if it was needed you could change it.

After any new Bad server response check logs (espocrm (data/logs) and apache error) to know more information about error

[tempus]

Thanks. My logs are full of this two types of the errors:

[2017-04-21 08:43:19] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='" at /application/Espo/ORM/DB/Mapper.php line 115 {"exception":"[object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' at /application/Espo/ORM/DB/Mapper.php:115)"} []

[2017-04-21 08:50:00] Espo.ERROR: CronManager: Failed job running, job [58f9c0b05c71a9600]. Error Details: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' [] []

Thinking how to fix. Should I make some changes in Mapper.php on line 115?

[tanya]

Could tell me the MySQL version and server collation and charset?

[tempus]

Database server

• Software: MySQL
• Software version: 5.5.28-log - Source distribution
• Protocol version: 10
• Server charset: UTF-8 Unicode (utf8)

Server connection collation utf8_general_ci

In tables and columns I have utf8_general_ci and utf8_unicode_ci

[tanya]

Change all tables and columns collation to utf8_unicode_ci
But create the dump of database before.

[Syn Gates]

Thanks for your support!