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. How can I get all capabilities for a particular user?
  32. How to use WordPress Multisite With Different Domain Names?
  33. How To Add Custom Form Fields To The User Profile Page?
  34. How do I create a custom role capability?
  35. Where are available Roles Defined in the wp_ database?
  36. restore_current_blog() vs switch_to_blog()
  37. Can i merge 2 new WP_Query($variable) ‘s?
  38. How to disable a network enabled plugin for just one site?
  39. How to reliably flush rewrite rules on multisite?
  40. Site Redirecting to wp-signup.php
  41. Moving a WP Multisite to a subdirectory
  42. Cookies in multisite where network sites have their own domain name
  43. Convert a Multisite WordPress install into a Single site
  44. WordPress MultiSite Active Directory integration and site privacy
  45. WordPress Job Interview Preparation
  46. How to add Custom Blog Options to new blog setup form?
  47. How can I trust switch_to_blog()?
  48. Remove the blog slug from WordPress Multisite root node
  49. Why are my roles not visible in a Multi-site/Network?
  50. Site admin in a network install can’t edit users?
  51. How to use same email for multiple users
  52. How to run an activation function when plugin is network activated on multisite?
  53. Specific upload folder for PDFs in custom Post type in WP multisite
  54. What is the correct way to map multiple domains in a WordPress 4.1 multisite install?
  55. Where can I find documentation on what characters are allowed in user names and why?
  56. How to migrate subsite from dev multisite to production multisite
  57. How can I un-reserve a pending username registration?
  58. How do I remove/delete an old super admin user?
  59. DB connection error after copying a WordPress Multisite instance to a second location
  60. Redirect Main Site to Subsite in Multisite WordPress
  61. Is there a is_user_logged_in() for multisite?
  62. Switching MultiSite installation from HTTP to HTTPS
  63. Allow user to select a theme to install when they signup
  64. Setting up a wordpress network with third level domains
  65. Get upload URL by blog ID in multisite
  66. What’s the difference between get_site_option and get_blog_option?
  67. Need help sorting “My Sites” Alphabetically
  68. How to delete post revisions?
  69. Create mobile site with same content just different theme
  70. Add additional Network constants to wp-config.php dynamically
  71. Multisite stuck at 1MB for max file size
  72. How to get blog name, when using WordPress Multisite
  73. What are options are there to implement a multi language site
  74. Switching primary site in WordPress Multisite
  75. Multisite Network Port Num Issues?
  76. Convert existing site to network
  77. Where is the robots.txt stored for a WordPress Multisite install?
  78. Settings API in Multisite – Missing update message
  79. Add WordPress MU Network Admin via Database
  80. How to get current site id? (WPMU)
  81. Multisite on Windows with wildcard subdomains
  82. Why is WordPress Multisite redirecting to wp-signup.php and how to fix it?
  83. Which asset URLs are acceptable in a “vanilla” MU install?
  84. $wpdb->base_prefix not get parent site prefix in multisite
  85. How to tell which database tables belongs to which multisite site
  86. what are pmxi tables? [closed]
  87. Using wp_insert_post() with Networking enabled
  88. Are nested subdomains possible with a subdomain multisite?
  89. Sharing Dynamic Sidebars across Multisite Blogs
  90. I want to develop locally with Multisite, then migrate each site to separate remote WP installs
  91. Password Reset for Users on a Multisite Subsite
  92. Anyone figured out how to use WordPress MultiSite with Domain Mapping & SSL?
  93. Can a multisite’s blogs be accessible from two different sub-domains?
  94. Querying posts from multiple sites in a network?
  95. Plugin for editing options on multisite?
  96. What do I need to do to convert my MultiSite from HTTP to HTTPS?
  97. is_front_page() malfunction?
  98. WP Multisite development with Mamp Pro and wildcard subdomains, not really working for me
  99. How to share WordPress core library
  100. How do I change the Multisite URL?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)