504 on Duplicated Post Meta count

  • Resolved Etienne

    (@epipo)


    1 year, 2 months ago

    Hi,

    Thanks for your plugin! I have an issue with the Duplicated Post Meta function: it returns a 504 error when trying to count the entries (I have checked the call response in the console) so I get “The reply sent by the server is broken” message.

    Here are some helpful information:

    • I am testing it on a local install
    • I have tried increasing the delay to 2000ms but it doesn’t solve the issue
    • I should have around 50 000 duplicated entries

    Thanks for your help!

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Jordy Meow

    (@tigroumeow)

    Hi,

    This is going to be a bit difficult ?? Actually, that query is not complex but a bit heavy to run (compared to others), and there is no alternative. Believe me, I really tried. This is why, by default, Duplicated Post Meta is not set to “Auto” by default.

    Can you try to create an index in your database? Do you know how to do it? You can run this:

    CREATE INDEX idx_postmeta_postid_metakey ON wp_postmeta(post_id, meta_key)

    Then you can try again to refresh the count. That will definitely make the request faster.

    Have you check your Network tab in your Developer Tools (Chrome)? After how long the request breaks? If it’s 30s or so, then it might be a limit of your PHP configuration, you can extend this time: https://stackoverflow.com/questions/16171132/how-to-increase-maximum-execution-time-in-php

    Thread Starter Etienne

    (@epipo)

    You rock!

    Creating an index made the count much faster.

    Thanks again for your great work!

    Plugin Author Jordy Meow

    (@tigroumeow)

    Awesome! I will add a button in the next release to easily create those indexes, and another button to remove them ?? Thank you and don’t hesitate to leave a little review to Database Cleaner. Happy weekend ahead!

    @gingrr I have removed your comment to this old thread, which I’m also closing for further comments.
    If you want to comment on your situation, please start a new post instead.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘504 on Duplicated Post Meta count’ is closed to new replies.