XF 2.0 XF2 Cli Import Error (

[developr]

Dear Community,

while I import the users the import stops with the error message:

[XF\Db\Exception] MySQL query error [1366]: Incorrect string value: '\xF0\x9F\x91\x89 [...' for column 'signature' at row 1

Does somebody know how I can find the specific entry in source database to correct the row?

 

[Paul B]

Has the database been converted to UTF8 and has the line in config.php been entered?

https://xenforo.com/xf2-docs/manual/unicode/#running-the-conversion-script

It's the same issue as this -- https://xenforo.com/community/threads/error-in-import.154676/#post-1287246 -- so adding the config.php entry should resolve it.

 

[developr]

It works. Thank you!