How do I fix problems with users not being able to publish and only submit for review after upgrade of Multisites installation?

After a full day of investigating the problem I managed to find the culprit and solve the problem.

I localized the problem by following these steps:

  1. Create a new blog and give your user admin or editor privileges.
  2. In MySQL copy all posts from one of the troubled blogs to the new blog.
  3. Now the new blog has the same problem with the publish button being gone.
  4. Find the causing post(s) by using binary search.

The posts causing this behavior turned out to be Auto Draft posts with no content, but not all of them.

By running

delete from wp_NNN_posts where post_status="auto-draft" AND post_content="";

in each and every blog we got rid of the problem.

Related Posts:

  1. How to enable a site administrator to edit users in a WordPress network/ multisite setup?
  2. Restrict Admin Capabilities in MultiSite
  3. Possible to make custom role in multisite that can add sites?
  4. Multisite database upgrade SSL error
  5. Adding capabilities to super admins
  6. Prevent user creating new users with specific roles
  7. Timeout While Upgrading Network in Multi-site
  8. “Upgrade Network” error: stuck with SSL certificate verification
  9. What are the differences in capabilities between the super-administrator and administrator?
  10. In MultiSite, can some users automatically have Site Admin rights on all sites, without granting them Network Admin access?
  11. Restrict Admin Capabilities in MultiSite
  12. create_users capabilities on a role on multisite
  13. Is there a way to run upgrade.php for one blog?
  14. current_user_can() always returns true if user is super admin
  15. Allow Author on Site A capability to upload files on Site B in Multi Site
  16. Add menu items/actions for multisite users who are registered on the network but do not have a role or capability in any sites
  17. Subsite access without being a member of the subsite in wp multisite network
  18. Restrict Capability of Administrator to Create, Edit and Delete Pages in Multisite
  19. HTTPS Warning and Certificate Error when Updating Network
  20. How to change a user role after registering in multisite?
  21. Allow editors to switch sites (Multisite)
  22. Multisite network admin – User’s role not showing up
  23. How does WP decide how to evaluate database integrity
  24. How can I restrict changing the max nested comment levels option to super admins?
  25. Can I replace the “Upgrade Network” with SQL query?
  26. A different role for each site in a multisite
  27. Multi-site database upgrade claims success, but db_version not updated
  28. Getting 404 after Update in Multisite
  29. How to give “author” user role appropriate capabilities to add PollDaddy polls? WordPress multisite
  30. Non-super-admin users cannot access CPT even though I have explicitly added the capabilities to the user role
  31. Moving a WP Multisite to a subdirectory
  32. $wpdb->base_prefix not get parent site prefix in multisite
  33. what are pmxi tables? [closed]
  34. Issue with Custom Roles in Multisite
  35. Force plugin to be activated only from multisite network dashboard [duplicate]
  36. Delete sites in wordpress multisite (not suspend)
  37. Multisite 404 errors and non-www redirecting to home page
  38. Get first_name and last_name on user_register hook
  39. User registration on subsite in multisite configuration
  40. Multisite, turn off “create new site”
  41. subdomain archiving
  42. Full Domain Mapping with WP3 in Multiuser Mode
  43. Copy site from one multisite to another
  44. add_rewrite_rule not registering on Multisite
  45. How to combine multiple sites to WordPress MU
  46. how do I configure nginx for wordpress multisite, it occurs ERR_TOO_MANY_REDIRECTS
  47. How to change the database prefix in multisite (WPMU) install
  48. Getting blank thumbnails in media library?
  49. WP MU – Accessing ‘Domain-Mapped’ WP-Admin with a subdomain
  50. Accessing multiple sites via FTP
  51. Multiple homes for multiple languages [closed]
  52. multisite custom directory
  53. You do not have permission to edit this user
  54. Multi-site: removing /blog from posts
  55. Multiple install for multilanguage. How to?
  56. Query users by capability – uninstall/deactivate callback
  57. Cannot access my first sub-site in a multisite [closed]
  58. How to detect the context of homepage for a wordpress mu sub-blog
  59. Multsite redirecting to the main site
  60. Multisite setup help – plain domain/subsite always redirects to domain with subdir multisite
  61. Auto creation of multisite blog on user registration
  62. How to make a php script(app) accessible to all wordpress subdomains in a wordpress multisite configuration?
  63. Multisite with 220+ sites painfully slow
  64. Issues with Multisite installation and 403 error for REST API request
  65. Efficient way to handle translations with Multisite WordPress installation
  66. How to disable wordpress cron jobs for a subsite?
  67. WordPress Mulitisite – Unable to create directory
  68. Navigation menu not being assigned Theme Location
  69. How do I remove the “http://” from network_site_url?
  70. is_main_site() Always Returns True
  71. Mass Update Broken Links
  72. Permalink with a Category and then a Post
  73. Performance disadvantge of second installation instead multisite feature?
  74. What is the simplest way to disable multisite leaving one of the sites only?
  75. What does multi-site WordPress application mean?
  76. Create website with a switch between private and business [closed]
  77. How much resources are good enough for 3.9.2
  78. Forward and mask a WordPress website
  79. Subdomain is not working
  80. How to automatically create an index of child sites at the root url for a multisite installation?
  81. Migration: previous URL redirection after migrating
  82. how to convert a wp multisite into a single site with content from subsites
  83. Getting stylesheet error after setting subdomain to false in multisite
  84. URLs for (MultiSite) link images are always relative
  85. Add radio button on theme at the select of the theme the same theme should be activated after generation of new site in multi site
  86. Moving wordpress multisite to new domain
  87. How to allow mixed case characters in multisite site name?
  88. Which action hook to update custom field at network/site-info.php in multisite on update site info
  89. multisite shared settings
  90. Multi Site Translate Strings
  91. How To Change the URL of a WordPress Multisite
  92. Can’t import posts in multisite
  93. User registration problem on multisites web
  94. Multi site and media uploader
  95. There is no featured image in my post in wordpress multisite theme [closed]
  96. Subdomain add comment redirect to 404 not found page iis server
  97. 404 error in dashboard of subdomain of multisite
  98. WordPress Multisites
  99. How do I test my WordPress subdomains on AWS during migration?
  100. Access website using hosts due to expired domain [closed]

Leave a Comment