• Welcome to the Chevereto User Community!

    Here, users from all over the world come together to learn, share, and collaborate on everything related to Chevereto. It's a place to exchange ideas, ask questions, and help improve the software.

    Please keep in mind:

    • This community is user-driven. Always be polite and respectful to others.
    • Support development by purchasing a Chevereto license, which also gives you priority support.
    • Go further by joining the Community Subscription for even faster response times and to help sustain this space
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

Path with emojis don't work when using Bulk Content Importer

D

dudayz

Chevereto Member
Dear Support,

I get error when bulk import SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='

Then import won't running, I try to change collation in mysql database and table become utf8mb4_unicode_ci but still getting error, i attach u log for import.

Regards
 

Attachments

Sorry for the late reply.

Describe better the context for this issue.
 
Hello, This issue happened on 3.18 but i think will happened too in 3.20.1

Bulk import stopped work if images has name with emoji icon, i attach screenshot for log, the file name for images is

صيدلية-النخلتين-Pharmaton-‍♂️‍♀️-🤷‍♀️ا.jpg

This filename cause stopped bulk import process, after deleted it import process continue to work. And also please check this too https://chevereto.com/community/thr...o-existing-users-use-bulk-import-method.13403 cause this is related topic according to bulk import feature.
 

Attachments

  • 193246642_339304087918069_503895535846706281_n.png
    193246642_339304087918069_503895535846706281_n.png
    48.6 KB · Views: 3
The importing table runs in UTF8, it doesn't support UTFMB4 at this time.
 
Rodolfo said:
The importing table runs in UTF8, it doesn't support UTFMB4 at this time.
Click to expand...
I have change collation to utf8_general_ci and also try utf8_unicode_ci when import still get error I'm attach for error log
 

Attachments

  • Screenshot_188.png
    Screenshot_188.png
    613.2 KB · Views: 5
This has been just implemented, now the bulk importer will take UTF8MB4 so it will support emoji and any other character in that set (including all 4-byte based lang characters).

The patch will be available in the next revision (3.20.2)
 
You must log in or register to reply here.
Back
Top