• 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
    home_url(): 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.33
    WP Memory Limit: ……………. 1024M
    PHP Time Limit: …………….. 360
    Blocked External HTTP Requests: None
    fsockopen: …………………. Enabled
    OpenSSL: …………………… OpenSSL 1.1.1w 11 Sep 2023
    cURL: ……………………… Enabled
    Enable SSL verification setting: No
    Opcache Enabled: ……………. Enabled

    MySQL: ………………. 5.5.5-10.6.22-MariaDB
    ext/mysqli: ………….. yes
    WP Locale: …………… en
    DB Charset: ………….. utf8
    WPMDB_STRIP_INVALID_TEXT: No

    Debug Mode: … Yes
    Debug Log: …. Yes
    Debug Display: No
    Script Debug: No
    PHP 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: …. Yes
    Delay Between Requests: 0

    WP_HOME: ……. https://clientwebsitetemplate.com/kdf
    WP_SITEURL: …. https://clientwebsitetemplate.com/kdf
    WP_CONTENT_URL: https://clientwebsitetemplate.com/kdf/wp-content
    WP_CONTENT_DIR: /home/webuildy/public_html/clientwebsitetemplate.com/kdf/wp-content
    WP_PLUGIN_DIR: /home/webuildy/public_html/clientwebsitetemplate.com/kdf/wp-content/plugins
    WP_PLUGIN_URL: https://clientwebsitetemplate.com/kdf/wp-content/plugins

    Media Uploads
    Transfer Bottleneck: …… 256 MB
    Upload Folder Permissions: 755

    Themes & Plugins
    Transfer Bottleneck: ……… 256 MB
    Themes Permissions: ………. 755
    Plugins Permissions: ……… 755
    Must-Use Plugins Permissions: 755
    WP-Content Permissions: …… 755
    WP-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 to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Support Delicious Brains Support

    (@dbisupport)

    Hi there!

    WP Migrate Support Team here, Thanks for reaching out!

    We understand you’re getting an error when running a find and replace –

    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.