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. Allow user to select a theme to install when they signup
  31. What’s the difference between get_site_option and get_blog_option?
  32. Multisite Domain Mapping with SSL
  33. Basic Multisite Question – Managing Content Centrally
  34. Multisite – Keep users logged in only to their site
  35. Is there an easy way to separate themes on network?
  36. How to use WordPress multisite with mixed HTTP and HTTPS sites?
  37. Multisite with Different Domains
  38. Weird Issue with load balanced WP 3.0 setup
  39. Removing orphan users in WordPress Multisite
  40. Sharding BLOGUPLOADDIR
  41. NGinx + WordPress Subdomain Multi with core in Subdirectory
  42. Hook filter to change wp_upload_dir() path in multisite
  43. Multisite wordpress and subdomain URL collisions
  44. WordPress Multisite: Automatically run importer upon creating new site
  45. Add Rewrite Rule to point to a file on the server
  46. Multisite WordPress nginx uploaded files throw 404
  47. subdomain mulitsite on localhost in a subfolder
  48. Exclude main blog from get_blogs_of_user
  49. WordPress Network for regional company websites
  50. How to do Domain Mapping to Subdirectories?
  51. Why can’t I delete original user in multisite? Options for manual removal
  52. Media library not loading after switching the main site of multisite
  53. Multisite media library uploads broken images
  54. Any downsides on using Multisite for many look-alike-websites?
  55. WordPress Images Not Showing When FTP
  56. How to run a subdirectory multisite install under a subdomain
  57. How do I list multisite users for the current site only
  58. Using Two Themes – One for Main Site, One for Ecommerce
  59. WordPress Multisite – configuring a local development copy
  60. Multilanguage site with two domains
  61. Site not found using subdomains
  62. Is it possible to install BuddyPress with blogs installed on several servers? [closed]
  63. All wordpress network subfolder sites being redirected to main site
  64. Get current Blog ID in Tinymce Plugin Dialog Window in WPMU
  65. Grandchild themes and optimal network architecture
  66. Multisite – Change Add user to Blog notification email
  67. URL without www redirect directly with submission page – Multiwordpress install
  68. How can I tell if a wordpress site is running on multisite?
  69. Adding hreflang to multisite with no plugin?
  70. Obtaining user table for one site on multisite set up
  71. possible to combine sites that have lots of content, into multisite?
  72. How to autologin users after creating a new site (multisite)? [duplicate]
  73. Does a single theme license work on multisite? [closed]
  74. WP Multisite – Additional subdomain on the site for API purposes
  75. Old Website Address Still Showing
  76. Multisite configuration for multiple domains
  77. Multisite adjust uploads like (/upload/%alphanumeric_id%/%file_type%/%blog_ID%)
  78. How long is “as long as possible” in wp_cache_set()?
  79. Changing from localhost:8888 to localhost
  80. WordPress multilingual site to work with other plugins
  81. What’s the best way to get posts from one multisite blog into another?
  82. Error after changing multisite URL
  83. Multisite Dashboard Always Redirects to Main Dashboard
  84. WP Multisite child theme: get_template_directory_uri() seeks it’s own subdirectory instead of directory of parent theme
  85. Rewriting request to another site
  86. Multi-Network without plugin
  87. How install wordpress in another wordpress folder?
  88. All Multisites are working as one site
  89. WordPress Multisite header img src is lost from staging to production
  90. Blog broken after changing Site/Home URL
  91. Autoblog posts in wpms(network) into main site including featured images
  92. Cron job disappering without notice?
  93. WP Multisite .htaccess interferes with cgi-bin
  94. Redirect all users, except network administrators, from the main site to a subsite
  95. Apply Lazy loading/Infinite scroll on array data
  96. load styles and scripts in network admin not working
  97. How to redirect author subdomain pages to each author pages on www
  98. Set static page as default front page on newly created sites in multisite
  99. WordPress shows death white screen on multisite
  100. Multisite website configure Domain issue

Leave a Comment