Upload Error

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:

“Failed to scan 1 backup zips, the zips can be corrupted during creation or download process. Please check the zips.”

I went back and looked at the export log, which ended with the following:
[2022-09-28 12:11:18][notice]Backup completed.
[2022-09-28 12:11:18][notice]Backup succeeded.

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.”

However, WordPress prompts “Database Update Required” right after which ends with the following errors:

WordPress database error: [Table '[mydomain].wp_categories' doesn't exist]
SELECT cat_ID, cat_name, category_nicename FROM wp_categories

WordPress database error: [Table '[mydomain].wp_post2cat' doesn't exist]
SELECT DISTINCT post_id FROM wp_post2cat

WordPress database error: [Unknown column 'post_category' in 'field list']
SELECT ID, post_category FROM wp_posts WHERE post_category != '0'

WordPress database error: [Table '[mydomain].wp_categories' doesn't exist]
ALTER TABLE <code>wp_categories</code> ADD INDEX ( <code>category_nicename</code> )

WordPress database error: [Key column 'link_category' doesn't exist in table]
ALTER TABLE <code>wp_links</code> ADD INDEX ( <code>link_category</code> )

WordPress database error: [Unknown column 'user_nickname' in 'field list']
SELECT ID, user_nickname, user_nicename FROM wp_users

WordPress database error: [Table '[mydomain].wp_categories' doesn't exist]
SELECT * FROM wp_categories ORDER BY cat_ID

WordPress database error: [Table '[mydomain].wp_post2cat' doesn't exist]
SELECT post_id, category_id FROM wp_post2cat GROUP BY post_id, category_id

WordPress database error: [Table '[mydomain].wp_linkcategories' doesn't exist]
SELECT cat_id, cat_name FROM wp_linkcategories

WordPress database error: [Unknown column 'link_category' in 'field list']
SELECT link_id, link_category FROM wp_links

After 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.

Any help is appreciated.