1. joomlis
  2. RO CSVI
  3. Monday, 20 August 2018
  4.  Subscribe via email
Hi,
I try to import products to vm, but I received the following error message:
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='

Please find the log file in attachment!

Best regards,
Sam

com_csvi.log.1.zip
Accepted Answer Pending Moderation
Hello Sam,
Have a look at Deal with different collation document to know on how to fix this error.
Kind regards,

Tharuna

=========================
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
Accepted Answer Pending Moderation
Hi Tharuna,
Thanks, I changed all DB tables to utf8mb4_unicode_ci and I checked
the import file is UTF-8 encoded and check that by using CSVI Analyser.
But the error still appear!

I could not attach the logs file, is too big: 2 Mb

Please help!

Best wishes,
Sam
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Sam,
Can you post your import file? Let me check it here by running an import.

If you are on latest CSVI 7.7.0 version, check How to get debug information? document and LIMITING NUMBER OF LINES IN DEBUG LOG section to know to limit the debug log entries. This way you can post smaller debug log for us to check.
Kind regards,

Tharuna

=========================
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
Accepted Answer Pending Moderation
Hello Tharuna,
Thanks,

Yes, I am using latest version CSVI 7.6.2 version, and I checked that ''Enable logging'' is set to Yes.

Now I limited the import file (import-1.csv) to few lines, to be smaller

Please find the attachment the import file big (import.csv) and smaller (import-1.csv)


Kind regards,
Sam

import-1.csv

import.csv
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello,
Yes, I am using latest version CSVI 7.6.2 version, and I checked that ''Enable logging'' is set to Yes.

Latest version is CSVI 7.7.0 and not 7.6.2 :)

Your import file is not UTF-8 encoded. When i check the file using CSVI Analyser it shows unreadable characters. Check the attached screenshot.

Screen Shot 2018-08-21 at 3.35.03 PM.png
Attachments (1)
Kind regards,

Tharuna

=========================
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. # 5
Accepted Answer Pending Moderation
Thanks soooooooo much Tharuna,
Your are the best support,


Thanks again!

My best wishes to you!
Sam
  1. more than a month ago
  2. RO CSVI
  3. # 6
  • Page :
  • 1


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