I’ve started using WPvivid to backup client websites and it has worked on most. The largest website, however, shows the following error message after uploading the backup .zip files to my local WordPress installation:<\/p>\n
“Failed to scan 1 backup zips, the zips can be corrupted during creation or download process. Please check the zips.”<\/p>\n
I went back and looked at the export log, which ended with the following:
\n[2022-09-28 12:11:18][notice]Backup completed.
\n[2022-09-28 12:11:18][notice]Backup succeeded.<\/p>\n
I’ve been able to download all files without issue and can’t figure out which is causing the problem. Even with the error message, my local installation shows the “Uploaded Backup” and is able to restore with “Restore completed successfully.”<\/p>\n
However, WordPress prompts “Database Update Required” right after which ends with the following errors:<\/p>\n
WordPress database error: [Table '[mydomain].wp_categories' doesn't exist]\nSELECT cat_ID, cat_name, category_nicename FROM wp_categories\n\nWordPress database error: [Table '[mydomain].wp_post2cat' doesn't exist]\nSELECT DISTINCT post_id FROM wp_post2cat\n\nWordPress database error: [Unknown column 'post_category' in 'field list']\nSELECT ID, post_category FROM wp_posts WHERE post_category != '0'\n\nWordPress database error: [Table '[mydomain].wp_categories' doesn't exist]\nALTER TABLE <code>wp_categories<\/code> ADD INDEX ( <code>category_nicename<\/code> )\n\nWordPress database error: [Key column 'link_category' doesn't exist in table]\nALTER TABLE <code>wp_links<\/code> ADD INDEX ( <code>link_category<\/code> )\n\nWordPress database error: [Unknown column 'user_nickname' in 'field list']\nSELECT ID, user_nickname, user_nicename FROM wp_users\n\nWordPress database error: [Table '[mydomain].wp_categories' doesn't exist]\nSELECT * FROM wp_categories ORDER BY cat_ID\n\nWordPress database error: [Table '[mydomain].wp_post2cat' doesn't exist]\nSELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id\n\nWordPress database error: [Table '[mydomain].wp_linkcategories' doesn't exist]\nSELECT cat_id, cat_name FROM wp_linkcategories\n\nWordPress database error: [Unknown column 'link_category' in 'field list']\nSELECT link_id, link_category FROM wp_links<\/code><\/pre>\nAfter that, I am not able to log in to the website. I can access \/wp-login.php and it will show that my user exists, but the password (which I still use on my live site) isn’t being accepted. On the frontend, I can see that some\/most of the posts have been inserted, but the theme and styles are not working and it is simply using the 2022 theme.<\/p>\n
Any help is appreciated. <\/p>\n","protected":false},"template":"","class_list":["post-16051150","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16051150","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/16051150\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=16051150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}