Scheduled Database Maintenance deleting posts

  • Resolved bamboom

    (@bamboom)


    3 years, 2 months ago

    I wanted to flag a potential issue I think we’ve found in the SG Optimiser plugin if you could pass it on to the dev team please.

    We’ve discovered today that a fair few of our sites blog posts have vanished, along with all graphic assets that were part of them. This has happened on multiple sites that are using the SG Optimiser plugin, with the ‘Scheduled Database Maintenance’ option turned on.

    We’re almost certain it’s this option in the plugin, as if something had happened where the posts got deleted, the graphics that were uploaded with them would still be in the system. But they’re not. This is also the only plugin we’re running with permissions to delete anything.

    We’ve simply turned this option off now on all of our sites as we can’t trust that risk on any other sites.

    We’re not sure WHEN they got deleted, as we have posts from back in 2020, and 2019 that have been deleted, but only some of them.

    Just wanted to flag for the devs to look at. Luckily for us we had a staging site we could copy and paste them over from, but for big sites without access to old posts, this could be a major issue!

Viewing 1 replies (of 1 total)
  • Plugin Author Stoyan Georgiev

    (@stoyangeorgiev)

    Hey there @bamboom,

    The Scheduled Database Optimization does the following clean-up of your databases:

    – Deletes all auto-drafts
    – Deletes all revisions of a post
    – Deletes all trashed posts
    – Deletes all spam and trash comments
    – Deletes all expired transients.
    – Performs Database optimization for MyISAM tables.

    Note that if your databases are using the InnoDB storage engine, the database optimization will be done automatically by the storage engine itself.

    No public posts/pages are deleted when the optimization is enabled, simply because that is how the Optimization is developed.

    Also, Database Optimization is not deleting any assets such as images or other post-related files. All that it does is removing the records mentioned above and optimizes the database itself.

    I would suggest checking if you have another plugin that is managing your posts and check its settings because the Optimization provided with our plugin should not be deleting posts that are active.

    Kind regards,
    Stoyan

Viewing 1 replies (of 1 total)
  • The topic ‘Scheduled Database Maintenance deleting posts’ is closed to new replies.