Announcement

Collapse
No announcement yet.

1267 illegal mix of collations error

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 1267 illegal mix of collations error

    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.

  • #2
    Can some body help?

    Comment


    • #3
      Hi
      Check database tables CHARACTER and COLATE

      http://www.javaquery.com/2014/04/err...al-mix-of.html

      Comment


      • #4
        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.

        Comment


        • #5
          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

          Comment


          • #6
            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?

            Comment


            • #7
              Could tell me the MySQL version and server collation and charset?

              Comment


              • #8
                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

                Comment


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

                  Comment


                  • #10
                    Thanks for your support!

                    Comment

                    Working...
                    X