search

craftcms / shopify

Synchronize and extend product data from your Shopify storefront.
MIT License
45 stars 25 forks source link

Error when syncing products with emoji #107

Closed tommysvr closed 7 months ago

tommysvr commented 7 months ago

Description

When trying to sync products with emoji in the title or description, getting an error: General error: 1366 Incorrect string value: '\xF0\x9F\x8D\x83' for column 'bodyHtml' at row 1 in /var/www/html/vendor/yiisoft/yii2/db/Command.php:1302

Steps to reproduce

  1. Create a Shopify product with an emoji in the title or description
  2. Run php craft shopify/sync/products

Additional info

linear[bot] commented 7 months ago

PT-1615 Error when syncing products with emoji

nfourtythree commented 7 months ago

This is now fixed in versions 4.1.2 and 5.1.1 of the plugin.

Thanks!