Incompatibility: Optimize Database after Deleting Revisions

  • I’ve found an incompatibility using both Optimize Database after Deleting Revisions (OPDADR) & the WP Cloudflare Super Page Cache (WPCSPC) plugin.

    I also use the WP plugin “Clean Options” which shows an actual count of the existing WP options in the Tool menu. This is how I know there is an issue with OPDADR & WPCSPC. When I click on the Optimize DB (1 click) button without WPCSPC running I can see how many options are deleted by OPDADR in the Clean Options menu item because the actual number of options is updated after every OPDADR use. It’s a great combo. But when WPCSPC is running & I click on the Optimize DB (1 click) button I can see the current admin page reload, but I don’t know if OPDADR did anything because the options count does not update like it use to.

    Any chance you can work out this incompatibility with the OPDADR author? I will also post this on that WP support page as well.

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Contributor iSaumya

    (@isaumya)

    @butisitart Just to be safe side, have you checked the network panel of the browser dev tools to see that your main admin page header has cf cache status as BYPASS? Asking this to ensure that the admin pages are being bypassed and not being served from Cloudflare cache. First, check this.

    You should get an output like this for all the admin pages: https://i.imgur.com/0Q3Lud1.png

    If you see that admin pages are being Bypassed, then we can jump onto the next step to see what’s causing this. And also when you say that the page reloads but doesn’t show the number of options it deleted, try clicking on the button by opening the browser console, just to see if any errors are being logged in the browser console when this happens or not.

    Thread Starter Joe Streno

    (@butisitart)

    @isaumya Thanks for your reply.

    I checked the main admin page & I do see the BYPASS status. But when I go to tools.php page for OPDADR by clicking on its WP admin menubar link/button (which should run the script/utility), this is what I see in Console: https://imgur.com/a/7ZdLr1s . The Console page is empty. Though the page itself draws correctly the Console is empty except for the tool page link for OPDADR.

    If I click the OPDADR button a second time, or refresh the page, this is what I see: https://imgur.com/a/NNNo4WC . The Console updates & I see the BYPASS status for the page as you said I should.

    I get no errors, no warnings — nothing.

    BTW … this is still happening & I have updated WP Cloudflare Super Page Cache to v4.2.7 before running all these tests.

    Any ideas? What’s next?

    • This reply was modified 4 years, 4 months ago by Joe Streno.
    Plugin Contributor iSaumya

    (@isaumya)

    @butisitart Super wired. The BYPASS means the page is loading from your server and not from CF cache. Then there is no error in console means no 404 or JS errors. Did you check your server error logs? Maybe you can find something there?

    • This reply was modified 4 years, 4 months ago by iSaumya.
    Thread Starter Joe Streno

    (@butisitart)

    @isaumya Checked for error logs via FTP at domain root, public_html, and my theme level. I also checked for error logs on my cPanel page. No errors anywhere. ˉ\_(ツ)_/ˉ

    The strange thing is, this was all working previous to the last 2 updates to your plugin.

    Also … I’ll throw this in for good measure: I am also running Fast Velocity Minify. I see you have settings for use of other caching plugins, there’s nothing for this one. Though I guess it technically doesn’t cache. I also don’t have Cloudflare set to minify, because FVM is doing that job.

    Plugin Contributor iSaumya

    (@isaumya)

    Hi @butisitart,
    In that case, only Salvatore can dig into the matter and see what’s happening. I got no clue.

    Plugin Contributor Salvatore Fresta

    (@salvatorefresta)

    Hi,
    I see you are using Litespeed Server. Please disable the option Overwrite the cache-control header for WordPress’s pages using web server rules, then purge the cache and try again.

    With Litespeed server I recommend to use the workers mode (added on last 4.2.x release) if the page caching is not working with the standard page rule due to other plugins conflicts.

    Let me know

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Incompatibility: Optimize Database after Deleting Revisions’ is closed to new replies.