Support » Plugin: YITH WooCommerce Advanced Reviews » 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 2 months, 3 weeks ago by  gandreius.
Viewing 1 replies (of 1 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 1 month, 4 weeks ago by  YITHEMES.
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.