High number of entries in wp_postmeta table

  • Hi,
    I have +3.000.000 rows in my database created by YITH WooCommerce Advanced Reviews. Can anyone please let me know how can I remove these entries after uninstalling the plugin? The meta keys are:
    ‘_ywar_review_author_IP’, ‘_ywar_review_author’, ‘_ywar_review_author_email’, ‘_ywar_review_author’, ‘_ywar_review_user_id’, ‘_ywar_stop_reply’, ‘_ywar_featured’, ‘_ywar_inappropriate_count’, ‘_ywar_inappropriate_list’, ‘_ywar_votes’, ‘_ywar_downvotes_count’, ‘_ywar_upvotes_count’, ‘_ywar_thumb_ids’, ‘_ywar_comment_id’, ‘_ywar_product_id’, ‘_ywar_approved’, ‘_ywar_rating’

    Thank you

    • This topic was modified 5 years, 10 months ago by gandreius.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author YITHEMES

    (@yithemes)

    Hi there,
    hope you are doing well and sorry for the late reply! ??

    You can make a query on the wp_postmeta table to delete all the entries where the meta_key start on ‘_ywar’.

    First, I suggest you to make a SELECT to take a look of the data you want to delete and also make a backup of the database to avoid any problem.

    SELECT * FROM wp_postmeta WHERE meta_key LIKE '_ywar%'

    Then you can make the DELETE query.

    DELETE * FROM wp_postmeta WHERE meta_key LIKE '_ywar%'

    Could you check it and let us know any news, please?

    Have a nice day!

    • This reply was modified 5 years, 9 months ago by YITHEMES.

    I’m using this post because I have the same problem and have done what you suggest for the wp_postmeta table.

    However 20,000 reviews still remain and are located in wp_posts, post type is “ywar_reviews”

    What to do here?

    Please assist, thank you, John

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘High number of entries in wp_postmeta table’ is closed to new replies.