Title: MIgration Failed Last modified: June 30, 2025 --- # MIgration Failed * [buildblog](https://wordpress.org/support/users/buildblog/) * (@buildblog) * [11 months, 2 weeks ago](https://wordpress.org/support/topic/migration-failed-60/) * I’m trying to check my database as I just migrated my site. During the ‘preview’ stage many changes were highlighted. When I try and make the changes I get the following error: * JSON.parse: unexpected character at line 1 column 1 of the JSON data * Here’s the error log: * site_url(): [https://clientwebsitetemplate.com/kdf](https://clientwebsitetemplate.com/kdf) home_url(): [https://clientwebsitetemplate.com/kdf](https://clientwebsitetemplate.com/kdf) site_path(): /home/webuildy/public_html/clientwebsitetemplate.com/kdf * Database Name: webuildy_wp226 Table Prefix: wpl1_ * WordPress Version: 6.8.1 * WP Migrate DB: 2.7.3 * Web Server: ………………… LiteSpeed PHP: ………………………. 7.4.33WP Memory Limit: ……………. 1024MPHP Time Limit: …………….. 360Blocked External HTTP Requests: Nonefsockopen: …………………. EnabledOpenSSL: …………………… OpenSSL 1.1.1w 11 Sep 2023cURL: ……………………… EnabledEnable SSL verification setting: NoOpcache Enabled: ……………. Enabled * MySQL: ………………. 5.5.5-10.6.22-MariaDB ext/mysqli: ………….. yesWP Locale: …………… enDB Charset: ………….. utf8WPMDB_STRIP_INVALID_TEXT: No * Debug Mode: … Yes Debug Log: …. YesDebug Display: NoScript Debug: NoPHP Error Log: /home/webuildy/public_html/clientwebsitetemplate.com/kdf/wp-content/debug. log * WP Max Upload Size: 256 MB PHP Post Max Size: 256 MB * WPMDB Bottleneck: …… 1 MB Compatibility Mode: …. YesDelay Between Requests: 0 * WP_HOME: ……. [https://clientwebsitetemplate.com/kdf](https://clientwebsitetemplate.com/kdf) WP_SITEURL: …. [https://clientwebsitetemplate.com/kdf](https://clientwebsitetemplate.com/kdf) WP_CONTENT_URL: [https://clientwebsitetemplate.com/kdf/wp-content](https://clientwebsitetemplate.com/kdf/wp-content) WP_CONTENT_DIR: /home/webuildy/public_html/clientwebsitetemplate.com/kdf/wp-contentWP_PLUGIN_DIR:/ home/webuildy/public_html/clientwebsitetemplate.com/kdf/wp-content/pluginsWP_PLUGIN_URL: [https://clientwebsitetemplate.com/kdf/wp-content/plugins](https://clientwebsitetemplate.com/kdf/wp-content/plugins) * Media Uploads Transfer Bottleneck: …… 256 MBUpload Folder Permissions: 755 * Themes & Plugins Transfer Bottleneck: ……… 256 MBThemes Permissions: ………. 755Plugins Permissions: ……… 755Must-Use Plugins Permissions: 755WP-Content Permissions: …… 755WP-Core Permissions: ……… 755 * Active Theme Name: Twenty Twenty-Five Active Theme Folder: /home/webuildy/public_html/ clientwebsitetemplate.com/kdf/wp-content/themes/twentytwentyfive * Active Plugins - Better Search Replace (v1.4.10) by WP Engine - WP Migrate Lite (v2.7.3) by WP Engine * Must-Use Plugins - ManageWP – Worker Loader (v1.0.0) by GoDaddy - installatron_hide_status_test.php - WP Migrate Lite Compatibility (v1.3) by Delicious Brains * And hit is just one entry in the debug.log: * [30-Jun-2025 13:37:03 UTC] WordPress database error Column ‘option_id’ cannot be null for query INSERT INTO `_mig_wpl1_options` ( `option_id`, `option_name`,` option_value`, `autoload` ) VALUES ( NULL , ‘wpmdb_migration_options’, ‘a:17:{ s:17:\”current_migration\”;a:33:{s:9:\”connected\”;b:0;s:6:\”intent\”;s:12:\” find_replace\”;s:13:\”tables_option\”;s:3:\”all\”;s:15:\”tables_selected\”;a: 104:{i:0;s:26:\”wpl1_accessibility_checker\”;i:1;s:28:\”wpl1_actionscheduler_actions\”; i:2;s:27:\”wpl1_actionscheduler_claims\”;i:3;s:27:\”wpl1_actionscheduler_groups\”; i:4;s:25:\”wpl1_actionscheduler_logs\”;i:5;s:16:\”wpl1_commentmeta\”;i:6;s:13:\” wpl1_comments\”;i:7;s:25:\”wpl1_gf_draft_submissions\”;i:8;s:13:\”wpl1_gf_entry\”; i:9;s:18:\”wpl1_gf_entry_meta\”;i:10;s:19:\”wpl1_gf_entry_notes\”;i:11;s:12:\” wpl1_gf_form\”;i:12;s:17:\”wpl1_gf_form_meta\”;i:13;s:22:\”wpl1_gf_form_revisions\”; i:14;s:17:\”wpl1_gf_form_view\”;i:15;s:27:\”wpl1_inf_infusionsoft_stats\”;i:16; s:10:\”wpl1_links\”;i:17;s:18:\”wpl1_litespeed_url\”;i:18;s:23:\”wpl1_litespeed_url_file\”; i:19;s:14:\”wpl1_lockdowns\”;i:20;s:16:\”wpl1_login_fails\”;i:21;s:25:\”wpl1_mailerlite_checkouts\”; i:22;s:12:\”wpl1_ml_data\”;i:23;s:23:\”wpl1_mlw_qm_audit_trail\”;i:24;s:23:\” wpl1_mlw_question_terms\”;i:25;s:18:\”wpl1_mlw_questions\”;i:26;s:30:\”wpl1_mlw_quiz_output_templates\”; i:27;s:28:\”wpl1_mlw_quiz_theme_settings\”;i:28;s:16:\”wpl1_mlw_quizzes\”;i:29; s:16:\”wpl1_mlw_results\”;i:30;s:15:\”wpl1_mlw_themes\”;i:31;s:12:\”wpl1_options\”; i:32;s:13:\”wpl1_postmeta\”;i:33;s:10:\”wpl1_posts\”;i:34;s:16:\”wpl1_prli_clicks\”; i:35;s:16:\”wpl1_prli_groups\”;i:36;s:20:\”wpl1_prli_link_metas\”;i:37;s:15:\” wpl1_prli_links\”;i:38;s:21:\”wpl1_sgpb_subscribers\”;i:39;s:32:\”wpl1_sgpb_subscription_error_log\”; i:40;s:23:\”wpl1_term_relationships\”;i:41;s:18:\”wpl1_term_taxonomy\”;i:42;s: 13:\”wpl1_termmeta\”;i:43;s:10:\”wpl1_terms\”;i:44;s:16:\”wpl1_tm_taskmeta\”; i:45;s:13:\”wpl1_tm_tasks\”;i:46;s:16:\”wpl1_um_metadata\”;i:47;s:13:\”wpl1_usermeta\”; i:48;s:10:\”wpl1_users\”;i:49;s:16:\”wpl1_watu_answer\”;i:50;s:17:\”wpl1_watu_grading\”; i:51;s:16:\”wpl1_watu_master\”;i:52;s:15:\”wpl1_watu_qcats\”;i:53;s:18:\”wpl1_watu_question\”; i:54;s:17:\”wpl1_watu_takings\”;i:55;s:26:\”wpl1_wc_admin_note_actions\”;i:56; s:19:\”wpl1_wc_admin_notes\”;i:57;s:23:\”wpl1_wc_category_lookup\”;i:58;s:23:\” wpl1_wc_customer_lookup\”;i:59;s:20:\”wpl1_wc_download_log\”;i:60;s:23:\”wpl1_wc_order_addresses\”; i:61;s:27:\”wpl1_wc_order_coupon_lookup\”;i:62;s:30:\”wpl1_wc_order_operational_data\”; i:63;s:28:\”wpl1_wc_order_product_lookup\”;i:64;s:19:\”wpl1_wc_order_stats\”; i:65;s:24:\”wpl1_wc_order_tax_lookup\”;i:66;s:14:\”wpl1_wc_orders\”;i:67;s:19:\” wpl1_wc_orders_meta\”;i:68;s:33:\”wpl1_wc_product_attributes_lookup\”;i:69;s: 36:\”wpl1_wc_product_download_directories\”;i:70;s:27:\”wpl1_wc_product_meta_lookup\”; i:71;s:19:\”wpl1_wc_rate_limits\”;i:72;s:22:\”wpl1_wc_reserved_stock\”;i:73;s: 24:\”wpl1_wc_tax_rate_classes\”;i:74;s:16:\”wpl1_wc_webhooks\”;i:75;s:25:\”wpl1_woocommerce_api_keys\”; i:76;s:37:\”wpl1_woocommerce_attribute_taxonomies\”;i:77;s:49:\”wpl1_woocommerce_downloadable_product_permissions\”; i:78;s:20:\”wpl1_woocommerce_log\”;i:79;s:31:\”wpl1_woocommerce_order_itemmeta\”; i:80;s:28:\”wpl1_woocommerce_order_items\”;i:81;s:34:\”wpl1_woocommerce_payment_tokenmeta\”; i:82;s:31:\”wpl1_woocommerce_payment_tokens\”;i:83;s:25:\”wpl1_woocommerce_sessions\”; i:84;s:40:\”wpl1_woocommerce_shipping_zone_locations\”;i:85;s:38:\”wpl1_woocommerce_shipping_zone_methods\”; i:86;s:31:\”wpl1_woocommerce_shipping_zones\”;i:87;s:35:\”wpl1_woocommerce_tax_rate_locations\”; i:88;s:26:\”wpl1_woocommerce_tax_rates\”;i:89;s:17:\”wpl1_wpforms_logs\”;i:90; s:25:\”wpl1_wpforms_payment_meta\”;i:91;s:21:\”wpl1_wpforms_payments\”;i:92;s: 23:\”wpl1_wpforms_tasks_meta\”;i:93;s:23:\”wpl1_wpr_above_the_fold\”;i:94;s:28:\” wpl1_wpr_lazy_render_content\”;i:95;s:36:\”wpl1_wpr_preconnect_external_domains\”; i:96;s:22:\”wpl1_wpr_preload_fonts\”;i:97;s:21:\”wpl1_wpr_rocket_cache\”;i:98; s:23:\”wpl1_wpr_rucss_used_css\”;i:99;s:20:\”wpl1_yoast_indexable\”;i:100;s:30:\” wpl1_yoast_indexable_hierarchy\”;i:101;s:21:\”wpl1_yoast_migrations\”;i:102;s: 23:\”wpl1_yoast_primary_term\”;i:103;s:20:\”wpl1_yoast_seo_links\”;}s:13:\”backup_option\”; s:4:\”none\”;s:22:\”backup_tables_selected\”;a:0:{}s:17:\”post_types_option\”; s:3:\”all\”;s:19:\”post_types_selected\”;a:0:{}s:25:\”advanced_options_selected\”; a:2:{i:0;s:13:\”replace_guids\”;i:1;s:18:\”exclude_transients\”;}s:12:\”profile_name\”; s:14:\”Find & Replace\”;s:25:\”selected_existing_profile\”;N;s:12:\”profile_type\”; N;s:6:\”status\”;s:0:\”\”;s:6:\”stages\”;a:1:{i:0;s:6:\”tables\”;}s:13:\”current_stage\”; s:12:\”find_replace\”;s:15:\”stages_complete\”;a:0:{}s:7:\”running\”;b:1;s:17:\” migration_enabled\”;b:1;s:12:\”migration_id\”;s:36:\”1df1af5a-5240-4523-9681- 82e1eb23b8e6\”;s:13:\”source_prefix\”;s:0:\”\”;s:18:\”destination_prefix\”;s: 0:\”\”;s:7:\”preview\”;b:1;s:19:\”selectedComboOption\”;s:7:\”preview\”;s:13:\” twoMultisites\”;b:0;s:11:\”localSource\”;b:1;s:15:\”databaseEnabled\”;b:1;s:18:\” currentPayloadSize\”;i:0;s:21:\”currentMaxPayloadSize\”;N;s:20:\”fileTransferRequests\”; i:0;s:18:\”payloadSizeHistory\”;a:0:{}s:17:\”fileTransferStats\”;a:0:{}s:29:\” forceHighPerformanceTransfers\”;b:1;s:15:\”fseDumpFilename\”;N;}s:14:\”search_replace\”; a:2:{s:21:\”custom_search_replace\”;a:1:{i:0;a:8:{s:11:\”replace_old\”;s:23:\” https://kendfoster.com/\”;s:11:\”replace_new\”;s:38:\”https://clientwebsitetemplate. com/kdf/\”;s:5:\”focus\”;b:0;s:5:\”regex\”;b:0;s:12:\”isValidRegex\”;N;s:23:\” replace_old_placeholder\”;N;s:23:\”replace_new_placeholder\”;N;s:2:\”id\”;s:36:\” dc24f238-2b8b-4ca6-84dc-9cc0ba21b9b7\”;}}s:27:\”custom_search_domain_locked\”; b:0;}s:6:\”action\”;s:12:\”find_replace\”;s:13:\”select_tables\”;a:104:{i:0;s: 26:\”wpl1_accessibility_checker\”;i:1;s:28:\”wpl1_actionscheduler_actions\”;i: 2;s:27:\”wpl1_actionscheduler_claims\”;i:3;s:27:\”wpl1_actionscheduler_groups\”; i:4;s:25:\”wpl1_actionscheduler_logs\”;i:5;s:16:\”wpl1_commentmeta\”;i:6;s:13:\” wpl1_comments\”;i:7;s:25:\”wpl1_gf_draft_submissions\”;i:8;s:13:\”wpl1_gf_entry\”; i:9;s:18:\”wpl1_gf_entry_meta\”;i:10;s:19:\”wpl1_gf_entry_notes\”;i:11;s:12:\” wpl1_gf_form\”;i:12;s:17:\”wpl1_gf_form_meta\”;i:13;s:22:\”wpl1_gf_form_revisions\”; i:14;s:17:\”wpl1_gf_form_view\”;i:15;s:27:\”wpl1_inf_infusionsoft_stats\”;i:16; s:10:\”wpl1_links\”;i:17;s:18:\”wpl1_litespeed_url\”;i:18;s:23:\”wpl1_litespeed_url_file\”; i:19;s:14:\”wpl1_lockdowns\”;i:20;s:16:\”wpl1_login_fails\”;i:21;s:25:\”wpl1_mailerlite_checkouts\”; i:22;s:12:\”wpl1_ml_data\”;i:23;s:23:\”wpl1_mlw_qm_audit_trail\”;i:24;s:23:\” wpl1_mlw_question_terms\”;i:25;s:18:\”wpl1_mlw_questions\”;i:26;s:30:\”wpl1_mlw_quiz_output_templates\”; i:27;s:28:\”wpl1_mlw_quiz_theme_settings\”;i:28;s:16:\”wpl1_mlw_quizzes\”;i:29; s:16:\”wpl1_mlw_results\”;i:30;s:15:\”wpl1_mlw_themes\”;i:31;s:12:\”wpl1_options\”; i:32;s:13:\”wpl1_postmeta\”;i:33;s:10:\”wpl1_posts\”;i:34;s:16:\”wpl1_prli_clicks\”; i:35;s:16:\”wpl1_prli_groups\”;i:36;s:20:\”wpl1_prli_link_metas\”;i:37;s:15:\” wpl1_prli_links\”;i:38;s:21:\”wpl1_sgpb_subscribers\”;i:39;s:32:\”wpl1_sgpb_subscription_error_log\”; i:40;s:23:\”wpl1_term_relationships\”;i:41;s:18:\”wpl1_term_taxonomy\”;i:42;s: 13:\”wpl1_termmeta\”;i:43;s:10:\”wpl1_terms\”;i:44;s:16:\”wpl1_tm_taskmeta\”; i:45;s:13:\”wpl1_tm_tasks\”;i:46;s:16:\”wpl1_um_metadata\”;i:47;s:13:\”wpl1_usermeta\”; i:48;s:10:\”wpl1_users\”;i:49;s:16:\”wpl1_watu_answer\”;i:50;s:17:\”wpl1_watu_grading\”; i:51;s:16:\”wpl1_watu_master\”;i:52;s:15:\”wpl1_watu_qcats\”;i:53;s:18:\”wpl1_watu_question\”; i:54;s:17:\”wpl1_watu_takings\”;i:55;s:26:\”wpl1_wc_admin_note_actions\”;i:56; s:19:\”wpl1_wc_admin_notes\”;i:57;s:23:\”wpl1_wc_category_lookup\”;i:58;s:23:\” wpl1_wc_customer_lookup\”;i:59;s:20:\”wpl1_wc_download_log\”;i:60;s:23:\”wpl1_wc_order_addresses\”; i:61;s:27:\”wpl1_wc_order_coupon_lookup\”;i:62;s:30:\”wpl1_wc_order_operational_data\”; i:63;s:28:\”wpl1_wc_order_product_lookup\”;i:64;s:19:\”wpl1_wc_order_stats\”; i:65;s:24:\”wpl1_wc_order_tax_lookup\”;i:66;s:14:\”wpl1_wc_orders\”;i:67;s:19:\” wpl1_wc_orders_meta\”;i:68;s:33:\”wpl1_wc_product_attributes_lookup\”;i:69;s: 36:\”wpl1_wc_product_download_directories\”;i:70;s:27:\”wpl1_wc_product_meta_lookup\”; i:71;s:19:\”wpl1_wc_rate_limits\”;i:72;s:22:\”wpl1_wc_reserved_stock\”;i:73;s: 24:\”wpl1_wc_tax_rate_classes\”;i:74;s:16:\”wpl1_wc_webhooks\”;i:75;s:25:\”wpl1_woocommerce_api_keys\”; i:76;s:37:\”wpl1_woocommerce_attribute_taxonomies\”;i:77;s:49:\”wpl1_woocommerce_downloadable_product_permissions\”; i:78;s:20:\”wpl1_woocommerce_log\”;i:79;s:31:\”wpl1_woocommerce_order_itemmeta\”; i:80;s:28:\”wpl1_woocommerce_order_items\”;i:81;s:34:\”wpl1_woocommerce_payment_tokenmeta\”; i:82;s:31:\”wpl1_woocommerce_payment_tokens\”;i:83;s:25:\”wpl1_woocommerce_sessions\”; i:84;s:40:\”wpl1_woocommerce_shipping_zone_locations\”;i:85;s:38:\”wpl1_woocommerce_shipping_zone_methods\”; i:86;s:31:\”wpl1_woocommerce_shipping_zones\”;i:87;s:35:\”wpl1_woocommerce_tax_rate_locations\”; i:88;s:26:\”wpl1_woocommerce_tax_rates\”;i:89;s:17:\”wpl1_wpforms_logs\”;i:90; s:25:\”wpl1_wpforms_payment_meta\”;i:91;s:21:\”wpl1_wpforms_payments\”;i:92;s: 23:\”wpl1_wpforms_tasks_meta\”;i:93;s:23:\”wpl1_wpr_above_the_fold\”;i:94;s:28:\” wpl1_wpr_lazy_render_content\”;i:95;s:36:\”wpl1_wpr_preconnect_external_domains\”; i:96;s:22:\”wpl1_wpr_preload_fonts\”;i:97;s:21:\”wpl1_wpr_rocket_cache\”;i:98; s:23:\”wpl1_wpr_rucss_used_css\”;i:99;s:20:\”wpl1_yoast_indexable\”;i:100;s:30:\” wpl1_yoast_indexable_hierarchy\”;i:101;s:21:\”wpl1_yoast_migrations\”;i:102;s: 23:\”wpl1_yoast_primary_term\”;i:103;s:20:\”wpl1_yoast_seo_links\”;}s:20:\”table_migrate_option\”; s:3:\”all\”;s:13:\”create_backup\”;i:0;s:13:\”backup_option\”;s:4:\”none\”;s: 13:\”select_backup\”;a:0:{}s:17:\”select_post_types\”;a:0:{}s:22:\”exclude_post_revisions\”; s:1:\”0\”;s:13:\”replace_guids\”;s:1:\”1\”;s:25:\”compatibility_older_mysql\”; s:1:\”0\”;s:18:\”exclude_transients\”;s:1:\”1\”;s:12:\”exclude_spam\”;s:1:\”0\”; s:19:\”keep_active_plugins\”;s:1:\”0\”;s:9:\”gzip_file\”;s:1:\”0\”;s:18:\”exclude_post_types\”; s:1:\”0\”;}’, ‘off’ ) made by require(‘wp-blog-header.php’), wp, WP->main, WP- >parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook- >apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server- >dispatch, WP_REST_Server->respond_to_request, DeliciousBrains\WPMDB\Common\Migration\ FinalizeMigration->ajax_finalize_migration, DeliciousBrains\WPMDB\Common\Migration\ FinalizeMigration->finalize_migration, DeliciousBrains\WPMDB\Common\Sql\Table- >process_chunk * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fmigration-failed-60%2F%3Foutput_format%3Dmd&locale=en_US) to see the link]_ Viewing 1 replies (of 1 total) * Plugin Support [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/) * (@dbisupport) * [11 months, 2 weeks ago](https://wordpress.org/support/topic/migration-failed-60/#post-18535123) * Hi there! * WP Migrate Support Team here, Thanks for reaching out! * We understand you’re getting an error when running a find and replace – * ```wp-block-code WordPress database error Column ‘option_id’ cannot be null for query INSERT INTO _mig_wpl1_options ( option_id, option_name, option_value, autoload ) ``` * Could you check for us if your site’s `wp_options` table has a primary key (` option_id`) and does `option_id` have `AUTO_INCREMENT` enabled? Adding those settings to the `wp_options` table should fix the issue. * _We recommend creating a database backup first before making any changes to your site’s database._ * Please let us know how that goes. Viewing 1 replies (of 1 total) The topic ‘MIgration Failed’ is closed to new replies. * ![](https://ps.w.org/wp-migrate-db/assets/icon.svg?rev=2851356) * [WP Migrate Lite - Migration Made Easy](https://wordpress.org/plugins/wp-migrate-db/) * [Frequently Asked Questions](https://wordpress.org/plugins/wp-migrate-db/#faq) * [Support Threads](https://wordpress.org/support/plugin/wp-migrate-db/) * [Active Topics](https://wordpress.org/support/plugin/wp-migrate-db/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wp-migrate-db/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wp-migrate-db/reviews/) * 1 reply * 2 participants * Last reply from: [Delicious Brains Support](https://wordpress.org/support/users/dbisupport/) * Last activity: [11 months, 2 weeks ago](https://wordpress.org/support/topic/migration-failed-60/#post-18535123) * Status: not resolved