This thread originated in #wordpress on Pantheon Community Slack
@skerichards: So this might be a little crazy, but does anyone what the site stability implications are for making the team edit ONLY in Test, and pushing the database up to Live on a weekly (or bi-weekly) schedule? I know this isn’t normal practice, but I have a very large team that want to make edits, and about half of them can’t be relied on to catch layout issues after they hit publish. Opinions???
@sparklingrobots: It would work but during the DB clone operation you could see some downtime or instability
@sparklingrobots: But it would be quite limited. Really depends on what your need for stability is.
@sparklingrobots: I also don’t love it because you don’t really get a test run for the new DB — I could see things going sideways with a workflow like that.
@sparklingrobots: What about instituting a moderation workflow on live?
@skerichards: yeah, i would expect some DB issues… not ideal though. I come from the old school blue/green DNS switch release schedule, with a controlled user set.
@skerichards: how would i be able to do moderation? from what i’ve read, once content is published, an update immediately goes live. (edited)
@sparklingrobots: This is me porting some Drupalisms to WP but I’d think maybe using roles to restrict publication ability
@sparklingrobots: Haven’t tried this but https://wordpress.com/forums/topic/send-new-posts-to-admin-for-moderation/
Topic: Send new posts to admin for moderation | WordPress.com Forums
@sparklingrobots: @John Richards II — do you have any recs for editorial workflow kinds of plugins in WP?
@JohnRichardsII: I’ve had some success with Edit Flow in the past: https://wordpress.org/plugins/edit-flow/
The talented @danielbachhuber is a contributor to it.
@skerichards: thanks, I’ll look into that one. Yeah, I used to use Drupal too, so finding out about that limitation in WP was disappointing.
@sparklingrobots: @skerichards you wouldn’t be the first customer to do something like this, but I mostly encountered people with this workflow in support
@sparklingrobots: And our support team is great but ain’t nobody want to be needing support all the time
@skerichards: hahaha yeah, I hear you there, I don’t want that either
@skerichards: @John Richards II That plugin looks useful, but it’s set up to handle unpublished content. The issue I’m seeing is content owners updating existing published pages and breaking them. I know a lot of it is training, but it’s literally our entire marketing team. :((
@JohnRichardsII: Oof, yeah once a page is published there are a lot less options.You might check out PublishPress and their Revision’s plugin: https://publishpress.com/revisions/I think it does what you are looking for by enabling a way for users to submit page revisions that then have to be approved.
PublishPress Revisions is the plugin to manage WordPress revisions
@skerichards: That one looked so promising! But looks like it’s not compatible with WP Bakery, which is unfortunately the current page editor. Bah, I’ve worked myself into a corner
@doug_pantheon: there are a couple other options here, WP-Migrate-DB pro can selectively migrate tables between sites, so for example you could just move posts between test/live (or a multidev) and that way comments would be preserved.we have also setup Blue/Green setups for customers using AGCDN, where we can flip a switch between one site and the other and the content updates go live. That doubles your cost since you need two sites, but its an option.
@skerichards: hmmm… well, we aren’t using comments, and i’m trying to avoid storing any user data on the site (our legal team is on the warpath against PII in every possible form they can think up) so there wouldn’t be any new content on live whatsoever.I don’t think I can convince them to double the costs atm, lol - that would be the easiest option though,
@skerichards: I’m not against having to run a migration at some horrible hour of the night (seems to be my lot in life tbh) so maybe WP-Migrate-DB could work, so long as I can accurately identify the tables.
@carlalberto: I’ve seen others use https://wpsitesync.com/ in their workflow to move around specific post to/from different environments, maybe that can also fit your needs
Home - WPSiteSync
@skerichards: hmmm… that could work, possibly. Has anyone used Revisionized? https://wordpress.org/plugins/revisionize/
Draft up revisions of live, published content. The live content doesn’t change until you publish the revision manually or with the scheduling sys …