Site migration doesn’t work

[Saurav AgarwalParticipant]

After site migration getting below error

2020/03/22 13:14:12 [error] 25401#25401: *780 FastCGI sent in stderr: “PHP message: WordPress database error Key ‘PRIMARY’ doesn’t exist in table ‘wp_revslider_slides_bkp’ for query SELECT COUNT(*) FROM wp_revslider_slides_bkp USE INDEX (PRIMARY) made by do_action(‘wp_ajax_updraft_ajaxrestore’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Admin->updraft_ajaxrestore, UpdraftPlus_Admin->prepare_restore, UpdraftPlus_Admin->restore_backup, Updraft_Restorer->perform_restore, Updraft_Restorer->restore_backup, Updraft_Restorer->restore_backup_db, Updraft_Restorer->restored_table, do_action(‘updraftplus_restored_db_table’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Addons_Migrator->updraftplus_restored_db_table, UpdraftPlus_Addons_Migrator->_migrator_icit_srdb_replacer” while reading upstream, client: 148.64.6.46, server: 165.22.218.80, request: “POST /wp-admin/admin-ajax.php HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php/php7.3-fpm.sock:”, host: “165.22.218.80”, referrer: “https://165.22.218.80/wp-admin/options-general.php?page=updraftplus”
2020/03/22 13:14:12 [error] 25401#25401: *780 FastCGI sent in stderr: “PHP message: WordPress database error Key ‘PRIMARY’ doesn’t exist in table ‘wp_revslider_static_slides’ for query SELECT COUNT(*) FROM wp_revslider_static_slides USE INDEX (PRIMARY) made by do_action(‘wp_ajax_updraft_ajaxrestore’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Admin->updraft_ajaxrestore, UpdraftPlus_Admin->prepare_restore, UpdraftPlus_Admin->restore_backup, Updraft_Restorer->perform_restore, Updraft_Restorer->restore_backup, Updraft_Restorer->restore_backup_db, Updraft_Restorer->restored_table, do_action(‘updraftplus_restored_db_table’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Addons_Migrator->updraftplus_restored_db_table, UpdraftPlus_Addons_Migrator->_migrator_icit_srdb_replacer” while reading upstream, client: 148.64.6.46, server: 165.22.218.80, request: “POST /wp-admin/admin-ajax.php HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php/php7.3-fpm.sock:”, host: “165.22.218.80”, referrer: “https://165.22.218.80/wp-admin/options-general.php?page=updraftplus”
2020/03/22 13:14:12 [error] 25401#25401: *780 FastCGI sent in stderr: “PHP message: WordPress database error Key ‘PRIMARY’ doesn’t exist in table ‘wp_revslider_static_slides_bkp’ for query SELECT COUNT(*) FROM wp_revslider_static_slides_bkp USE INDEX (PRIMARY) made by do_action(‘wp_ajax_updraft_ajaxrestore’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Admin->updraft_ajaxrestore, UpdraftPlus_Admin->prepare_restore, UpdraftPlus_Admin->restore_backup, Updraft_Restorer->perform_restore, Updraft_Restorer->restore_backup, Updraft_Restorer->restore_backup_db, Updraft_Restorer->restored_table, do_action(‘updraftplus_restored_db_table’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Addons_Migrator->updraftplus_restored_db_table, UpdraftPlus_Addons_Migrator->_migrator_icit_srdb_replacer” while reading upstream, client: 148.64.6.46, server: 165.22.218.80, request: “POST /wp-admin/admin-ajax.php HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php/php7.3-fpm.sock:”, host: “165.22.218.80”, referrer: “https://165.22.218.80/wp-admin/options-general.php?page=updraftplus”
2020/03/22 13:14:12 [error] 25401#25401: *780 FastCGI sent in stderr: “PHP message: WordPress database error Key ‘PRIMARY’ doesn’t exist in table ‘wp_smush_dir_images’ for query SELECT COUNT(*) FROM wp_smush_dir_images USE INDEX (PRIMARY) made by do_action(‘wp_ajax_updraft_ajaxrestore’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Admin->updraft_ajaxrestore, UpdraftPlus_Admin->prepare_restore, UpdraftPlus_Admin->restore_backup, Updraft_Restorer->perform_restore, Updraft_Restorer->restore_backup, Updraft_Restorer->restore_backup_db, Updraft_Restorer->restored_table, do_action(‘updraftplus_restored_db_table’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Addons_Migrator->updraftplus_restored_db_table, UpdraftPlus_Addons_Migrator->_migrator_icit_srdb_replacer” while reading upstream, client: 148.64.6.46, server: 165.22.218.80, request: “POST /wp-admin/admin-ajax.php HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php/php7.3-fpm.sock:”, host: “165.22.218.80”, referrer: “https://165.22.218.80/wp-admin/options-general.php?page=updraftplus”
2020/03/22 13:14:22 [error] 25401#25401: *780 FastCGI sent in stderr: “PHP message: WordPress database error Key ‘PRIMARY’ doesn’t exist in table ‘wp_yoast_seo_meta’ for query SELECT COUNT(*) FROM wp_yoast_seo_meta USE INDEX (PRIMARY) made by do_action(‘wp_ajax_updraft_ajaxrestore’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Admin->updraft_ajaxrestore, UpdraftPlus_Admin->prepare_restore, UpdraftPlus_Admin->restore_backup, Updraft_Restorer->perform_restore, Updraft_Restorer->restore_backup, Updraft_Restorer->restore_backup_db, Updraft_Restorer->restored_table, do_action(‘updraftplus_restored_db_table’), WP_Hook->do_action, WP_Hook->apply_filters, UpdraftPlus_Addons_Migrator->updraftplus_restored_db_table, UpdraftPlus_Addons_Migrator->_migrator_icit_srdb_replacer” while reading upstream, client: 148.64.6.46, server: 165.22.218.80, request: “POST /wp-admin/admin-ajax.php HTTP/1.1”, upstream: “fastcgi://unix:/var/run/php/php7.3-fpm.sock:”, host: “165.22.218.80”, referrer: “https://165.22.218.80/wp-admin/options-general.php?page=updraftplus”
root@debian-s-1vcpu-2gb-blr1-01:/var/log/nginx# ^C
root@debian-s-1vcpu-2gb-blr1-01:/var/log/nginx#

The Updraft migration logs can be found here

https://pastebin.com/raw/RE9wdvti

[Bryle CroduaModerator]

Hi,

May I know where you exactly get the error message? Is it in the front-end or back-end of your website?

Regards,
Bryle

[Saurav AgarwalParticipant]

It is in the nginx server logs /var/logs/nginx/error.log

[Author]

Posts