Migration of submissions fails on values with foreign characters

Created on 3 November 2022, about 2 years ago
Updated 6 February 2023, almost 2 years ago

My migration of webform submissions fails when reaching this particular submission. It looks like the encoding of the Chinese characters is breaking.

See error output:

 [error]  Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB2\xA1\xE6\x9C\x89' for column 'value' at row 10: INSERT INTO "webform_submission_data" ("webform_id", "sid", "name", "property", "delta", "value") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5), (:db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11), (:db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17), (:db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29), (:db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35), (:db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41), (:db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47), (:db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_placeholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53), (:db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :db_insert_placeholder_59), (:db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_placeholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71), (:db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75, :db_insert_placeholder_76, :db_insert_placeholder_77), (:db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83), (:db_insert_placeholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89); Array
(
    [:db_insert_placeholder_0] => webform_3132
    [:db_insert_placeholder_1] => 6343
    [:db_insert_placeholder_2] => field1
    [:db_insert_placeholder_3] =>
    [:db_insert_placeholder_4] => 0
    [:db_insert_placeholder_5] => janedoe
    [:db_insert_placeholder_6] => webform_3132
    [:db_insert_placeholder_7] => 6343
    [:db_insert_placeholder_8] => email
    [:db_insert_placeholder_9] =>
    [:db_insert_placeholder_10] => 0
    [:db_insert_placeholder_11] => janedoe@example.com
    [:db_insert_placeholder_12] => webform_3132
    [:db_insert_placeholder_13] => 6343
    [:db_insert_placeholder_14] => source
    [:db_insert_placeholder_15] =>
    [:db_insert_placeholder_16] => 0
    [:db_insert_placeholder_17] => 3
    [:db_insert_placeholder_18] => webform_3132
    [:db_insert_placeholder_19] => 6343
    [:db_insert_placeholder_20] => field9
    [:db_insert_placeholder_21] =>
    [:db_insert_placeholder_22] => 0
    [:db_insert_placeholder_23] => Mozilla/5.0 (Linux; Android 5.1; OPPO R9m Build/LMY47I) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36
    [:db_insert_placeholder_24] => webform_3132
    [:db_insert_placeholder_25] => 6343
    [:db_insert_placeholder_26] => assign
    [:db_insert_placeholder_27] =>
    [:db_insert_placeholder_28] => 0
    [:db_insert_placeholder_29] => 1
    [:db_insert_placeholder_30] => webform_3132
    [:db_insert_placeholder_31] => 6343
    [:db_insert_placeholder_32] => confirm_email
    [:db_insert_placeholder_33] =>
    [:db_insert_placeholder_34] => 0
    [:db_insert_placeholder_35] => janedoe@example.com
    [:db_insert_placeholder_36] => webform_3132
    [:db_insert_placeholder_37] => 6343
    [:db_insert_placeholder_38] => library_card
    [:db_insert_placeholder_39] =>
    [:db_insert_placeholder_40] => 0
    [:db_insert_placeholder_41] => Yes
    [:db_insert_placeholder_42] => webform_3132
    [:db_insert_placeholder_43] => 6343
    [:db_insert_placeholder_44] => question
    [:db_insert_placeholder_45] =>
    [:db_insert_placeholder_46] => 0
    [:db_insert_placeholder_47] => 我比较喜欢一切,一切这本书
    [:db_insert_placeholder_48] => webform_3132
    [:db_insert_placeholder_49] => 6343
    [:db_insert_placeholder_50] => field4
    [:db_insert_placeholder_51] =>
    [:db_insert_placeholder_52] => 0
    [:db_insert_placeholder_53] => 没有
    [:db_insert_placeholder_54] => webform_3132
    [:db_insert_placeholder_55] => 6343
    [:db_insert_placeholder_56] => field5
    [:db_insert_placeholder_57] =>
    [:db_insert_placeholder_58] => 0
    [:db_insert_placeholder_59] => J▒▒有
    [:db_insert_placeholder_60] => webform_3132
    [:db_insert_placeholder_61] => 6343
    [:db_insert_placeholder_62] => field7
    [:db_insert_placeholder_63] =>
    [:db_insert_placeholder_64] => 0
    [:db_insert_placeholder_65] => B▒▒有
    [:db_insert_placeholder_66] => webform_3132
    [:db_insert_placeholder_67] => 6343
    [:db_insert_placeholder_68] => field8
    [:db_insert_placeholder_69] =>
    [:db_insert_placeholder_70] => 0
    [:db_insert_placeholder_71] => Y▒▒有
    [:db_insert_placeholder_72] => webform_3132
    [:db_insert_placeholder_73] => 6343
    [:db_insert_placeholder_74] => field2
    [:db_insert_placeholder_75] =>
    [:db_insert_placeholder_76] => 0
    [:db_insert_placeholder_77] => 21111000000000
    [:db_insert_placeholder_78] => webform_3132
    [:db_insert_placeholder_79] => 6343
    [:db_insert_placeholder_80] => field6
    [:db_insert_placeholder_81] =>
    [:db_insert_placeholder_82] => 0
    [:db_insert_placeholder_83] => 13
    [:db_insert_placeholder_84] => webform_3132
    [:db_insert_placeholder_85] => 6343
    [:db_insert_placeholder_86] => field10
    [:db_insert_placeholder_87] =>
    [:db_insert_placeholder_88] => 0
    [:db_insert_placeholder_89] => Book Form
)
 in Drupal\webform\WebformSubmissionStorage->saveData() (line 1369 of /var/www/html/bpld9/modules/contrib/webform/src/WebformSubmissionStorage.php). [234.87 sec, 127.74 MB]

In ExceptionHandler.php line 53:

  [Drupal\Core\Database\DatabaseExceptionWrapper]
  SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB2\xA1\xE6\x9C\x89\x0A...' for column 'message' at row 1: INSERT INTO "migrate_message_upgrade_d7_webform_submission" ("source_ids_hash", "level", "message") VALUES (:d
  b_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array
  (
      [:db_insert_placeholder_0] => 9cb6511b71cd50440ac2f7d72b5904d7f92d2b52956356cb2fc611cfa4ae965a
      [:db_insert_placeholder_1] => 1
      [:db_insert_placeholder_2] => SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB2\xA1\xE6\x9C\x89' for column 'value' at row 10: INSERT INTO "webform_submission_data" ("webform_id", "sid", "name", "property", "del
  ta", "value") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5), (:db_insert_placeholder_6, :db_insert_placeholder_7,
  :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11), (:db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_place
  holder_16, :db_insert_placeholder_17), (:db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23), (:db_insert_placeholder_24, :
  db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29), (:db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_plac
  eholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35), (:db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40, :db_insert_placeholder_41), (
  :db_insert_placeholder_42, :db_insert_placeholder_43, :db_insert_placeholder_44, :db_insert_placeholder_45, :db_insert_placeholder_46, :db_insert_placeholder_47), (:db_insert_placeholder_48, :db_insert_placeholder_49, :db_insert_pla
  ceholder_50, :db_insert_placeholder_51, :db_insert_placeholder_52, :db_insert_placeholder_53), (:db_insert_placeholder_54, :db_insert_placeholder_55, :db_insert_placeholder_56, :db_insert_placeholder_57, :db_insert_placeholder_58, :
  db_insert_placeholder_59), (:db_insert_placeholder_60, :db_insert_placeholder_61, :db_insert_placeholder_62, :db_insert_placeholder_63, :db_insert_placeholder_64, :db_insert_placeholder_65), (:db_insert_placeholder_66, :db_insert_pl
  aceholder_67, :db_insert_placeholder_68, :db_insert_placeholder_69, :db_insert_placeholder_70, :db_insert_placeholder_71), (:db_insert_placeholder_72, :db_insert_placeholder_73, :db_insert_placeholder_74, :db_insert_placeholder_75,
  :db_insert_placeholder_76, :db_insert_placeholder_77), (:db_insert_placeholder_78, :db_insert_placeholder_79, :db_insert_placeholder_80, :db_insert_placeholder_81, :db_insert_placeholder_82, :db_insert_placeholder_83), (:db_insert_p
  laceholder_84, :db_insert_placeholder_85, :db_insert_placeholder_86, :db_insert_placeholder_87, :db_insert_placeholder_88, :db_insert_placeholder_89); Array
  (
      [:db_insert_placeholder_0] => webform_3132
      [:db_insert_placeholder_1] => 6343
      [:db_insert_placeholder_2] => field1
      [:db_insert_placeholder_3] =>
      [:db_insert_placeholder_4] => 0
      [:db_insert_placeholder_5] => janedoe
      [:db_insert_placeholder_6] => webform_3132
      [:db_insert_placeholder_7] => 6343
      [:db_insert_placeholder_8] => email
      [:db_insert_placeholder_9] =>
      [:db_insert_placeholder_10] => 0
      [:db_insert_placeholder_11] => janedoe@example.com
      [:db_insert_placeholder_12] => webform_3132
      [:db_insert_placeholder_13] => 6343
      [:db_insert_placeholder_14] => source
      [:db_insert_placeholder_15] =>
      [:db_insert_placeholder_16] => 0
      [:db_insert_placeholder_17] => 3
      [:db_insert_placeholder_18] => webform_3132
      [:db_insert_placeholder_19] => 6343
      [:db_insert_placeholder_20] => field9
      [:db_insert_placeholder_21] =>
      [:db_insert_placeholder_22] => 0
      [:db_insert_placeholder_23] => Mozilla/5.0 (Linux; Android 5.1; OPPO R9m Build/LMY47I) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.125 Mobile Safari/537.36
      [:db_insert_placeholder_24] => webform_3132
      [:db_insert_placeholder_25] => 6343
      [:db_insert_placeholder_26] => assign
      [:db_insert_placeholder_27] =>
      [:db_insert_placeholder_28] => 0
      [:db_insert_placeholder_29] => 1
      [:db_insert_placeholder_30] => webform_3132
      [:db_insert_placeholder_31] => 6343
      [:db_insert_placeholder_32] => confirm_email
      [:db_insert_placeholder_33] =>
      [:db_insert_placeholder_34] => 0
      [:db_insert_placeholder_35] => janedoe@example.com
      [:db_insert_placeholder_36] => webform_3132
      [:db_insert_placeholder_37] => 6343
      [:db_insert_placeholder_38] => library_card
      [:db_insert_placeholder_39] =>
      [:db_insert_placeholder_40] => 0
      [:db_insert_placeholder_41] => Yes
      [:db_insert_placeholder_42] => webform_3132
      [:db_insert_placeholder_43] => 6343
      [:db_insert_placeholder_44] => question
      [:db_insert_placeholder_45] =>
      [:db_insert_placeholder_46] => 0
      [:db_insert_placeholder_47] => 我比较喜欢一切,一切这本书
      [:db_insert_placeholder_48] => webform_3132
      [:db_insert_placeholder_49] => 6343
      [:db_insert_placeholder_50] => field4
      [:db_insert_placeholder_51] =>
      [:db_insert_placeholder_52] => 0
      [:db_insert_placeholder_53] => 没有
      [:db_insert_placeholder_54] => webform_3132
      [:db_insert_placeholder_55] => 6343
      [:db_insert_placeholder_56] => field5
      [:db_insert_placeholder_57] =>
      [:db_insert_placeholder_58] => 0
      [:db_insert_placeholder_59] => J▒▒有
      [:db_insert_placeholder_60] => webform_3132
      [:db_insert_placeholder_61] => 6343
      [:db_insert_placeholder_62] => field7
      [:db_insert_placeholder_63] =>
      [:db_insert_placeholder_64] => 0
      [:db_insert_placeholder_65] => B▒▒有
      [:db_insert_placeholder_66] => webform_3132
      [:db_insert_placeholder_67] => 6343
      [:db_insert_placeholder_68] => field8
      [:db_insert_placeholder_69] =>
      [:db_insert_placeholder_70] => 0
      [:db_insert_placeholder_71] => Y▒▒有
      [:db_insert_placeholder_72] => webform_3132
      [:db_insert_placeholder_73] => 6343
      [:db_insert_placeholder_74] => field2
      [:db_insert_placeholder_75] =>
      [:db_insert_placeholder_76] => 0
      [:db_insert_placeholder_77] => 21111000000000
      [:db_insert_placeholder_78] => webform_3132
      [:db_insert_placeholder_79] => 6343
      [:db_insert_placeholder_80] => field6
      [:db_insert_placeholder_81] =>
      [:db_insert_placeholder_82] => 0
      [:db_insert_placeholder_83] => 13
      [:db_insert_placeholder_84] => webform_3132
      [:db_insert_placeholder_85] => 6343
      [:db_insert_placeholder_86] => field10
      [:db_insert_placeholder_87] =>
      [:db_insert_placeholder_88] => 0
      [:db_insert_placeholder_89] => Book Form
  )
   (/var/www/html/bpld9/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php:811)
  )


Exception trace:
  at /var/www/html/bpld9/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php:53
 Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() at /var/www/html/bpld9/core/modules/mysql/src/Driver/Database/mysql/Insert.php:48
 Drupal\mysql\Driver\Database\mysql\Insert->execute() at /var/www/html/bpld9/core/modules/migrate/src/Plugin/migrate/id_map/Sql.php:711
 Drupal\migrate\Plugin\migrate\id_map\Sql->saveMessage() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/IdMapFilter.php:63
 Drupal\migrate_tools\IdMapFilter->saveMessage() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:488
 Drupal\migrate\MigrateExecutable->saveMessage() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:506
 Drupal\migrate\MigrateExecutable->handleException() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:273
 Drupal\migrate\MigrateExecutable->import() at /var/www/html/bpld9/vendor/drush/drush/includes/drush.inc:122
 drush_call_user_func_array() at /var/www/html/bpld9/vendor/drush/drush/includes/drush.inc:113
 drush_op() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/Commands/MigrateToolsCommands.php:951
 Drupal\migrate_tools\Commands\MigrateToolsCommands->executeMigration() at n/a:n/a
 array_walk() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/Commands/MigrateToolsCommands.php:409
 Drupal\migrate_tools\Commands\MigrateToolsCommands->import() at n/a:n/a
 call_user_func_array() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:257
 Consolidation\AnnotatedCommand\CommandProcessor->runCommandCallback() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:212
 Consolidation\AnnotatedCommand\CommandProcessor->validateRunAndAlter() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:176
 Consolidation\AnnotatedCommand\CommandProcessor->process() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/AnnotatedCommand.php:350
 Consolidation\AnnotatedCommand\AnnotatedCommand->execute() at /var/www/html/bpld9/vendor/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/html/bpld9/vendor/symfony/console/Application.php:1039
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/bpld9/vendor/symfony/console/Application.php:275
 Symfony\Component\Console\Application->doRun() at /var/www/html/bpld9/vendor/symfony/console/Application.php:149
 Symfony\Component\Console\Application->run() at /var/www/html/bpld9/vendor/drush/drush/src/Runtime/Runtime.php:124
 Drush\Runtime\Runtime->doRun() at /var/www/html/bpld9/vendor/drush/drush/src/Runtime/Runtime.php:51
 Drush\Runtime\Runtime->run() at /var/www/html/bpld9/vendor/drush/drush/drush.php:72
 require() at /var/www/html/bpld9/vendor/drush/drush/includes/preflight.inc:18
 drush_main() at phar:///usr/local/bin/drush/bin/drush.php:143
 require() at /usr/local/bin/drush:14

In StatementWrapper.php line 145:

  [PDOException (HY000)]
  SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB2\xA1\xE6\x9C\x89\x0A...' for column 'message' at row 1


Exception trace:
  at /var/www/html/bpld9/core/lib/Drupal/Core/Database/StatementWrapper.php:145
 PDOStatement->execute() at /var/www/html/bpld9/core/lib/Drupal/Core/Database/StatementWrapper.php:145
 Drupal\Core\Database\StatementWrapper->execute() at /var/www/html/bpld9/core/modules/mysql/src/Driver/Database/mysql/Insert.php:44
 Drupal\mysql\Driver\Database\mysql\Insert->execute() at /var/www/html/bpld9/core/modules/migrate/src/Plugin/migrate/id_map/Sql.php:711
 Drupal\migrate\Plugin\migrate\id_map\Sql->saveMessage() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/IdMapFilter.php:63
 Drupal\migrate_tools\IdMapFilter->saveMessage() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:488
 Drupal\migrate\MigrateExecutable->saveMessage() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:506
 Drupal\migrate\MigrateExecutable->handleException() at /var/www/html/bpld9/core/modules/migrate/src/MigrateExecutable.php:273
 Drupal\migrate\MigrateExecutable->import() at /var/www/html/bpld9/vendor/drush/drush/includes/drush.inc:122
 drush_call_user_func_array() at /var/www/html/bpld9/vendor/drush/drush/includes/drush.inc:113
 drush_op() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/Commands/MigrateToolsCommands.php:951
 Drupal\migrate_tools\Commands\MigrateToolsCommands->executeMigration() at n/a:n/a
 array_walk() at /var/www/html/bpld9/modules/contrib/migrate_tools/src/Commands/MigrateToolsCommands.php:409
 Drupal\migrate_tools\Commands\MigrateToolsCommands->import() at n/a:n/a
 call_user_func_array() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:257
 Consolidation\AnnotatedCommand\CommandProcessor->runCommandCallback() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:212
 Consolidation\AnnotatedCommand\CommandProcessor->validateRunAndAlter() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/CommandProcessor.php:176
 Consolidation\AnnotatedCommand\CommandProcessor->process() at /var/www/html/bpld9/vendor/consolidation/annotated-command/src/AnnotatedCommand.php:350
 Consolidation\AnnotatedCommand\AnnotatedCommand->execute() at /var/www/html/bpld9/vendor/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/html/bpld9/vendor/symfony/console/Application.php:1039
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/bpld9/vendor/symfony/console/Application.php:275
 Symfony\Component\Console\Application->doRun() at /var/www/html/bpld9/vendor/symfony/console/Application.php:149
 Symfony\Component\Console\Application->run() at /var/www/html/bpld9/vendor/drush/drush/src/Runtime/Runtime.php:124
 Drush\Runtime\Runtime->doRun() at /var/www/html/bpld9/vendor/drush/drush/src/Runtime/Runtime.php:51
 Drush\Runtime\Runtime->run() at /var/www/html/bpld9/vendor/drush/drush/drush.php:72
 require() at /var/www/html/bpld9/vendor/drush/drush/includes/preflight.inc:18
 drush_main() at phar:///usr/local/bin/drush/bin/drush.php:143
 require() at /usr/local/bin/drush:14
🐛 Bug report
Status

Closed: cannot reproduce

Version

1.0

Component

Code

Created by

🇺🇸United States todea

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • What is your database collation?

    Does it work if you use this?

    $databases['default']['default']['charset'] = 'utf8mb4';
    $databases['default']['default']['collation'] = 'utf8mb4_general_ci';
    
  • 🇺🇸United States todea

    I believe I initially had this issue while using drupal/webform_migrate:^1.2. I then switched to drupal/webform_migrate:1.x-dev@dev and the issue went away.

    My charset and collation is:

    utf8mb4
    utf8mb4_unicode_ci
  • Status changed to Closed: cannot reproduce almost 2 years ago
  • I'm using 1.x-dev, but also with these composer patches:

        "drupal/webform_migrate": {
          "#3182466: Issues submitting forms with migrated Checkbox elements": "https://www.drupal.org/files/issues/2022-01-10/3182466-8.patch",
          "#3182469: Phone number elements migrated as 'generic element' instead of 'tel'": "./patches/webform_migrate-m18.patch",
          "#3187664: Number field imported as Generic Element": "./patches/webform_migrate-m14.patch",
          "#3196003: Input migration doesn't include the placeholder attribute": "./patches/webform_migrate-m17.patch",
          "#3221876: Default handlers being set incorrectly on buildEmailHandlers": "./patches/webform_migrate-m8.patch",
          "#3253813: Element attribute disabled not migrated": "https://www.drupal.org/files/issues/2022-03-05/webform_migrate-3253813-4-element_disabled_attribute.patch",
          "#3255209: Allow draft is not handled": "https://www.drupal.org/files/issues/2021-12-20/webform_migrate-3255209-2-allow_draft.patch",
          "#3317856: Webforms: 'falsy' default/settings values not migrated.": "./patches/webform_migrate-m22.patch",
          "#3318724: Element attribute private not migrated": "./patches/webform_migrate-m23.patch"
        },
    
  • 🇺🇸United States todea

    Thanks for the tip. I am also using #3253813 but I may add some of those other patches to help with our migrate.

Production build 0.71.5 2024