Use the phpMyAdmin app (usually accessed through your hosting control panel) to find and examine the data with such 0 values. The specific rows might be unimportant to you and can be deleted. If you’re not sure, determine the next available increment value from the more>operations>table options tab and assign that value instead of 0. Increase the value in table options as well. Be sure to backup affected tables before making any changes.
When you assign a value this way, the related data will probably remain useless to WP as nothing relates to the value, but at least the errors are resolved and the data is not completely lost.
Oops forgot to resolve this – what happened for reference if anyone is using UpDraftPlus
There was a misconfiguration between the demo site and live site with UpdraftPlus. After going through each backup from them we found the one that had all the info we needed. Best 4 hours of my life.
