Unused Comment Meta

  • Resolved ljmac

    (@ljmac)


    10 months ago

    This is a great, comprehensive plugin. However, one thing it doesn’t appear to clean up is unused comment meta. Can this be added?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author Colin Devroe

    (@cdevroe)

    9 months, 4 weeks ago

    Hello @ljmac thank you for the suggestion.

    Can you describe “unused comment meta”? Would this be metadata on comments that are no longer visible, or where their posts have been marked as unpublished? Let us know precisely what you would like to see here.

    Thank you again!

    Thread Starter ljmac

    (@ljmac)

    9 months, 4 weeks ago

    Any orphaned commentmeta for whatever reason – here’s the relevant MySQL query:

    DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments)

    Plugin Author Colin Devroe

    (@cdevroe)

    9 months, 3 weeks ago

    👍 Thank you!

    Plugin Author NerdPress

    (@nerdpressteam)

    8 months, 1 week ago

    Hi @ljmac,

    Thanks for this suggestion. We’ve logged this as a feature request and I think we’ll be able to get this into a future release.

    Since I haven’t seen Commentmeta used all that extensively, would you be able to share more of your use case? I’m guessing you have something custom on your setup?

    (And I’m going to mark this as “Resolved” since we’ve added it to our to-do list.)

    Thanks!

    Best,
    Andrew

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Unused Comment Meta’ is closed to new replies.