New Page/Post Screen Opens an Existing Post

Turns out that a previously-modified line in the Yoast SEO source code had been reverted, so this error came back in debug.log: 1Uncaught TypeError: Argument 2 passed to WPSEO_Link_Watcher::save_post() must be an instance of WP_Post, null given.

Disabling Yoast resolved the New Page/Post error, however I believe the root cause was that the database has been around for a few versions of WordPress and needs to be rebuilt soon for better stability (just like re-installing Windows after a couple years).

EDIT: So the root cause was that at some point wp_posts lost its primary key and had auto-increment disabled on ID, so new DB entries were all getting an ID of 0. Then, when we tried to restore the backup of that database snapshot, we received import errors because of the duplicate ID entries, causing an incomplete database restore. Once we removed the extra ID 0 entries we were able to properly import our database backup and get the site to its former glory.

Related Posts:

  1. How to disable page delete
  2. Backup the Database and Restore from the Backup?
  3. Editing the Number at the end of Page URLs / Editing Page Slugs
  4. Pagination Help on Crazy Custom Authors Page
  5. Can I use $wpdb for my custom tables in the WordPress database?
  6. Create subpage /user/ or /my-profile/ like /author/ with additional query like /user/user123
  7. Hide page title in WordPress 3.0
  8. What Is The Difference Between suppress_errors() And hide_errors() in $wpdb?
  9. Prevent WordPress from loading comments
  10. Selecting An image from the Media LIbrary on the frontend
  11. Custom protected password page with ACF
  12. Suggestions for WPMU Migration (advanced)
  13. Page load requires a trailing “/” [closed]
  14. Retrieve and display data from custom db table in admin area?
  15. Custom search page and search by title, content and tag
  16. Virtual Pages plugins
  17. Programmatically add a custom page/path/url/route to WordPress
  18. What is the most idiomatic way to let clients edit phrases in HTML?
  19. How to merge all my pages into one, while keeping a menu bar?
  20. How to change URL Custom Page?
  21. redirect product-category to a custom page
  22. What’s the proper way to use a custom table? [closed]
  23. How to retrieve the value stored in a multi-dimensional array and SUM the entries?
  24. custom headers for static home page and posts page
  25. Adding a Table to the wordpress database
  26. Creating user relationships
  27. Show posts on a page based on a category and tag(s)
  28. WP Northwind for Theme Development?
  29. Split Conference WordPress Page in different years
  30. Add google org chart to wordpress page
  31. Fastest way to get the comment and ping total count for a post
  32. How to get custom page template being edited in gutenberg editor
  33. Control Content On Non-Blog Pages
  34. custom meta box for page default template
  35. $wpdb->replace: WHERE?
  36. Best practice – pages – ACF or inline coding
  37. How to hook up search results page to a back-end page?
  38. How to use default WP form elements to interact with custom DB table?
  39. How to structure model showcase
  40. How to customize
  41. Your thoughts on the interaction with one custom database table from WP?
  42. Add a searchbox to the body of a page
  43. Create page as a file in my theme?
  44. Featured Image If Else Condition
  45. Applying WP-cli Search & Replace to Static SQL Dump File
  46. Insert menu with a custom walker into page / post body using shortcode?
  47. How to create “custom page types” with different custom fields in them?
  48. How to create custom search page
  49. Setup database structure with books, authors, languages etc. for publishing house [closed]
  50. Add table to WordPress database
  51. Creating php pages in wordpress and assigning them to wordpress pages
  52. How to display page ids as page slug names?
  53. How to create custom layouts and static pages in themes for clients
  54. How to make the Pages in WordPress Customized?
  55. Creating custom page template
  56. Change Site Logo or Menu Logo Per Page
  57. change top banner content on specific page
  58. How to add page content into another page
  59. Custom Database Table and foreach
  60. Display a specified content on a Page and all its child pages
  61. Use a custom page with dynamic content as a user profile page
  62. What is my error trying to create a new table in the database?
  63. I want to embed mystream video in my wordpress site
  64. Swap home page based on user role, Elementor layout breaking
  65. Migrating my site to a new domain does not keep any changes made in customizer
  66. Taxonomy template is not reading
  67. Static Page, need Last and Next links at the bottom
  68. How can I create a Custom Page? (not a page template!!)
  69. Advice on how to structure a custom plugin
  70. How to have differents sites share the same tables of DB?
  71. wordpress custom posts page not showing
  72. How to serve an already coded html page in a WP page, to assign a simpler url
  73. Custom Form Input not saving to Database
  74. Accountless password generation
  75. Admin menu disable new/delete page
  76. Show different pages on site depending on user choice
  77. WordPress post submit page
  78. Redirect Every Instance of The Author Template Pages to Custom Author Pages
  79. Add several fields from different tables to post, fields per post are in same row of table
  80. Allow arbitrary text after page URL
  81. Where should I put this custom data?
  82. Show WP content on different PHP Sites
  83. Best way to create a page outside of the pages list
  84. Database custom table issues – incorrect result displayed
  85. Changing starting number of User ID
  86. Want home page to click through to two different page types
  87. Custom single page based on which custom page template is selected
  88. How to duplicate “Pages” section in the control panel?
  89. Page template with custom html fields inside a content
  90. Accessing + retrieving custom database in WordPress
  91. Pass query param to custom page
  92. Is there a way to have information on one page automatically feed into another? [closed]
  93. how to add a page
  94. Create a plugin to create a new page in wordpress for each time a record is added into the database
  95. How to apply styles to the custom page template
  96. How can I make a search term redirect to a page
  97. Advice how to connect custom database with WordPress, change data in WordPress and finaly use this data
  98. Custom CSS working on home page but not on NEW created PAGE
  99. Changes to code not displaying
  100. Create a page for each database table entries