this in Stack Overflow<\/a> which gave me a clue. I didn’t follow the steps outlined here but did scan my database tables and found all of the ID’s that are supposed to be unique numbers for each record and set to auto_increment were not in fact set that way. A few were but most were not. Looking at the records I found all of the ID’s were set to ‘0’. Apparently there is some sort of “option” when importing database tables that ignores setting auto_increment. I’ve never run into this before and find that very odd you would ever want that option for any reason. I’ve not taken the time yet to research it out so it’s possible it was a bug somewhere as well. BUT the required fix was to edit each database table and change the unique ID records to auto_increment. After which the database properly renumbered all of the ID’s to sequential order and things now seem to be operating as expected. I may yet run into a problem later if a record points to the wrong ID number now, that remains to be seen. I may opt to re-import the entire database again and pay close attention whether auto_increment is being properly set. That would at least help insure there won’t be future errors with incorrect ID references.<\/p>\nAnyway, this was my experience. If you recently moved to a different server I suggest checking this possibility. If this is the case for you as well, try doing another import on you database first rather than manually editing each table.<\/p>\n
Good luck!<\/p>\n","protected":false},"excerpt":{"rendered":"
Are you seeing this message when you try to add a new post to your WordPress site? Have you recently moved to a new server? If the answer to BOTH questions is yes this might be the solution.<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,30,41],"tags":[92,44,31],"class_list":["post-962","post","type-post","status-publish","format-standard","hentry","category-technology","category-web-development","category-wordpress","tag-database","tag-mysql","tag-wordpress"],"views":1604,"_links":{"self":[{"href":"https:\/\/tech.creed3.com\/index.php?rest_route=\/wp\/v2\/posts\/962","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech.creed3.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech.creed3.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech.creed3.com\/index.php?rest_route=\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/tech.creed3.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=962"}],"version-history":[{"count":1,"href":"https:\/\/tech.creed3.com\/index.php?rest_route=\/wp\/v2\/posts\/962\/revisions"}],"predecessor-version":[{"id":963,"href":"https:\/\/tech.creed3.com\/index.php?rest_route=\/wp\/v2\/posts\/962\/revisions\/963"}],"wp:attachment":[{"href":"https:\/\/tech.creed3.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech.creed3.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech.creed3.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"images\/stories\/wordpress-logo-simplified-rgb.png\"){kind=logo}
Are you seeing this message when you try to add a new post to your WordPress site? Have you recently moved to a new server? If the answer to BOTH questions is yes this might be the solution.<\/p>\n