How to reset the entire rate/reviews for showcase.

By Bob · Jul 6, 2016 ·
  1. Bob
    Wanting to start fresh with ratings and reviews for your showcase items? Just follow the simple steps below.

    Basically you need to do this:

    Truncate table: xf_nflj_showcase_rate_review

    Important Note: TRUNCATE, not DROP!

    Next you will need to run these queries (make sure you run them for the correct version of showcase that you have installed)

    Showcase 1.x series
    UPDATE xf_nflj_showcase_item SET rating = 0
    UPDATE xf_nflj_showcase_item SET vote_count = 0
    UPDATE xf_nflj_showcase_item SET review_count = 0

    Showcase 2.x series
    UPDATE xf_nflj_showcase_item SET rating_count = 0
    UPDATE xf_nflj_showcase_item SET rating_sum = 0
    UPDATE xf_nflj_showcase_item SET rating_avg = 0
    UPDATE xf_nflj_showcase_item SET rating_weighted = 0
    UPDATE xf_nflj_showcase_item SET review_count = 0

    That will clear out all the old ratings so that you can start fresh with the Rate and Review system (in case you want to force Reviews)

    Share This Article

Comments

To make a comment simply sign up and become a member!