WP 5 upgrade and ALTER TABLE wp_post … post_password

Maybe I’m blind or I’m overlooking something, but…

I don’t see any tickets related to that subject in any of these releases:

I also don’t see any DB operations in code:

So I don’t think that these ALTERS come with WP.

Maybe some plugin (or theme) is responsible for this.

If I were you, I would create a copy of my site, disable all plugins and set the default theme and then run the WP update. And then I would try to find wich plugin is causing these ALTERS.

Another way is to grep code of your site and search for any ALTERs in the code. ALTERs are not so common, so maybe you’ll find something.

Related Posts:

  1. WordPress 3.9 Database Update Infinite Loop
  2. Real automated and unattended wordpress upgrade including plugins
  3. Good methodology for upgrading a large/complex sites?
  4. How can the temporary update directory be changed?
  5. Why does WordPress 4.2.2 require FTP to update?
  6. Why won’t WordPress on localhost find updates?
  7. Upgrading from 3.5.2 to 3.9.1
  8. “The package could not be installed” when updating plugins, themes, and core files on WampServer
  9. Can’t upgrade WP 5.6 to 5.6.1: version-current.php is missing
  10. How much maintenance is required to run a WordPress server?
  11. How does WordPress get the upgrade URL?
  12. How can I upgrade wordpress with manual?
  13. Get rid of Another update is currently in progress
  14. What is your best practice to execute one-time scripts?
  15. No CSS being loaded on backend
  16. Set custom messages for post update/save
  17. Auto-updating WordPress from a local zip file
  18. Permissions to get autoupdate to work
  19. Disable requests to api.wordpress.org
  20. Why can’t I update username through WordPress API?
  21. Does set_transient() overwrite/update transient option with same key?
  22. Permissions to wp-content folder in Windows Server 2012
  23. How to force function to run as the last one when saving the post?
  24. git and local wordpress: how to handle wordpress updates?
  25. Block updates by Server
  26. WordPress 5.5 AutoUpdate schedule
  27. Update exisiting site to 3.5 release candidate
  28. A Way to Auto update plugins using cron?
  29. WordPress Version 5 – Another update is currently in progress
  30. Multisite database upgrade SSL error
  31. register_activation_hook and updating
  32. What are the details for function argument wp_update_plugin()
  33. Prevent changing the length of post_name column on WordPress Update
  34. Changing plugin slug with update
  35. Necessary user, group and permissions for core updates
  36. Update Failed: There has been a critical error on your website
  37. Hook (upgrader_process_complete) running moment
  38. How to notify my plugin users about new version releases?
  39. Deploying Updated or New Plugins That Modify the wp_options Table
  40. Website not updating – no cache plugins active!
  41. Why does One Click Update fail on localhost using FTP with 777 permissions on site files?
  42. Auto backup before automatic WordPress updates
  43. WordPress not showing upgrade to latest version
  44. Updating client websites on a regular basis
  45. How to do an event when any user updates their profile?
  46. Some wp-admin folder file deleted when WordPress upgrade
  47. How to display user’s nickname by default instead of username
  48. Download failed cURL error 7: . Can’t update anything
  49. Check for files and database integrity
  50. Subscribers become Authors after Upgrade? / Mass Update of Users?
  51. Install translation files that should survive updates [duplicate]
  52. Error updating WP-CLI
  53. Fresh new install or keep old version
  54. How to add new theme to running website
  55. Automatic updates and merging manual changes
  56. WordPress curl timing out and saying ‘Moved Permanently’
  57. Cannot update WordPress to 5.2
  58. New version doesn’t show up
  59. Custom theme updater – random string in new theme name
  60. An update has caused my client’s site to be non-existent after new update of WordPress [closed]
  61. Updating a page won’t have any effect
  62. Is the root index.php file part of the Core?
  63. 3.1 update erases customized function page?
  64. theme upgrade failing
  65. cannot update wordpress from 3.4.2 to 3.5
  66. Update to WordPress 4.7 – Fatal error: Maximum execution time of 30 seconds exceeded
  67. How to back up and up date a site to a newer version?
  68. How to automate post update website check?
  69. opcache_reset on plugin/theme/core update
  70. Plugin upgrade failing during unzip
  71. Which directories does WordPress attempt to create when updating core and installing plugins?
  72. Constant for ‘barebones’ update of WordPress
  73. Reliability of WordPress 4 one click update
  74. Can an update corrupt my installation?
  75. Can I Update WordPress 2.9.2. to 3.0.4 from admin
  76. WordPress current version is 5.7.5 but I’m being prompted to “upgrade” to 4.9
  77. Updating wordpress from my Linux distro’s repository
  78. Can not save changes after an edit
  79. Updatable theme developing
  80. Auto Update A WordPress Plugin from within another WordPress Manager Plugin
  81. Can I replace the “Upgrade Network” with SQL query?
  82. How to force an update of WordPress core to a newer minor version, using the Dashboard?
  83. What happend if I update my website?
  84. WordPress Not updating – No Cache Plugins, Admin sees updates
  85. Remote site behind VPN – how to allow core & plugin updates?
  86. Automating svn updates from a server-side cron job
  87. Issue after WordPress update
  88. cannot update ftp credentials even when group owner has write access
  89. WordPress NOT notifying of new update in dashboard
  90. What could have changed all of the ' characters in my content to &#039 strings?
  91. Updating from WordPress 3.5.2 to 3.6 Errors
  92. Autoupdate shows current when I’m on 3.1
  93. Restoring from a Backup after Update
  94. If I place custom files in WordPress root, will they be deleted?
  95. WordPress 4.8.2 redirects back after install and asks to delete/change config
  96. Problem updating from 3.6 to 3.7
  97. Hook or function to check if performing a WP Core update?
  98. cURL error 28: SSL connection timeout while can download the plugin file
  99. WordPress recommending to downgrade instead of upgrade?
  100. WordPress is updating only patch version and not minor