datamintsGmbH / datamints_locallang_builder

Offers developers and editors a backend module for creating, changing and translating language files for your extensions. Significant improvement of the workflow by using an independent translation provider such as Azure, DeepL or Google Translate.
https://www.datamints.com
Other
4 stars 5 forks source link

Incorrect string value: '\xF0\x9F\x91\x8D G...' for column .... #21

Open hieblmedia opened 1 year ago

hieblmedia commented 1 year ago

After installation and on reimport i get this error and can not start.

Core: Exception handler (WEB): Uncaught TYPO3 Exception: #1470230766: Incorrect string value: '\xF0\x9F\x91\x8D G...' for column db_name.tx_datamintslocallangbuilder_domain_model_translationvalue.value at row 1 | TYPO3\CMS\Extbase\Persistence\Generic\Storage\Exception\SqlErrorException thrown in file .../typo3_src-10.4.32/typo3/sysext/extbase/Classes/Persistence/Generic/Storage/Typo3DbBackend.php in line 158. Requested URL: https://.../typo3/index.php?route=%%2Fmodule%%2Ftools%%2FDatamintsLocallangBuilderTranslate&token=--AnonymizedToken--&tx_datamintslocallangbuilder_tools_datamintslocallangbuildertranslate%%5Baction%%5D=list&tx_datamintslocallangbuilder_tools_datamintslocallangbuildertranslate%%5Bcontroller%%5D=Extension

Found out the affected string is part of the cs_seo extension. Here are the Fielddata of the db transition. Looks like there is an issue with emotes in translation files.

Array
(
    [ident] => en
    [value] => 👍 Good job. All images here have an alternative text.
    [resname] => module.file.error.no_image_without_alt
    [xml_space] => 
    [approved] => 0
    [comment] => 
    [crdate] => 1665653307
    [tstamp] => 1665653307
    [pid] => 0
    [sys_language_uid] => 0
    [l10n_parent] => 0
    [l10n_diffsource] => 
)