Categories
View Replies (3)

Resolved Import Error

  1. mauriziomomix
    mauriziomomix
  2. RO CSVI
  3. Thursday, 25 May 2017
  4.  Subscribe via email
Hello,
I just tried importing a larger file and I have this error:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

How can I start investigate about it?

Thanks

Maurizio
0
Responses (3)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Maurizio,

The table encoding doesn't happen so often. I also don't know how it happens but my guess is that it is a result of updates not going a 100%. A test site is a good place to try this out :)
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
mauriziomomix
mauriziomomix
Accepted Answer Pending Moderation
Thank you Rolandd,
actually is the first time for me to face the tables encoding...
Since is a test environment, I'll try doing myself.

Thanks a lot

Maurizio
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Maurizio,

The reason you get this problem is because your database tables are inconsistent. As the error states, you have some tables that are utf8_general_ci and other tables that are utf8mb4_general_ci. The only solution is to make all your tables have the same collation, they should all be utf8mb4. You can do this using PhpMyAdmin if you know how otherwise I believe there is an option in Akeeba Admin Tools to set all tables to the same collation.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!