Deployment Error | Incorrect string value for column 'option_value'
-
Great Plugin!
I’m migrating a site running WP 4.2.2. (backed up with Duplicator 0.5.28) on a Server running MySQL 5.6.24, to another Server running MySQL 5.7.9.
I’m getting only one Deployment error (installer-log.txt):
**ERROR** database error write ‘Incorrect string value: ‘\xF0\x9F\x98\x89″ …’ for column ‘option_value’ at row 1′ – [sql=INSERT INTO
tbl_options
VALUES(“15872”, “_transient_feed_7fa907073bddbc2f…]After searching for several hours, it seems like the error may be related to the use of different character sets. Nevertheless, destination database seems to be using the same character sets as the source database, which doesn’t explain the above assumption:
# character_set_client=utf8mb4
# character_set_connection=utf8mb4
# character_set_database=latin1
# character_set_filesystem=binary
# character_set_results=utf8mb4
# character_set_server=latin1
# character_set_system=utf8
# collation_connection=utf8mb4_unicode_ci
# collation_database=latin1_swedish_ci
# collation_server=latin1_swedish_ciAny ideas what could be causing this Deployment error?
Thanks!
- The topic ‘Deployment Error | Incorrect string value for column 'option_value'’ is closed to new replies.