Opened 5 years ago
Last modified 9 months ago
#4275 assigned defect (bug)
Reviews that are moderated, do not keep their ratings
Reported by: |
|
Owned by: |
|
---|---|---|---|
Milestone: | Priority: | normal | |
Component: | Support Forums | Keywords: | |
Cc: |
Description
Currently when a review is moderated, the original review is moved to an 'archived' status and a new 'public' status review it put into it's place.
Sometimes this can be for something as trivial as removing a link to the reviewers site.
When that happens, the ratings
data stays attached to the post_id
of the archived
post, and the new public review doesn't have an attached ratings
record.
The public view of the rating will still show the rating (as ratings there are queried by user_id) but a plugin directory review view won't as it'll skip over the rating
record for the archive
'd review.
There's two options here, of which only the first seems like a real fix
- Keep the
ratings
record linked to the correct post_id of the review - Change the plugin directory to query the Support forum threads, and then look up the ratings for each by user_id, instead of the current 'Query all ratings, and pull their associated posts' which is far more performant given the number of reviews vs support posts.
An example of where this happened (I've corrected the underlying data) was here: https://wordpress.slack.com/archives/C02QB8GMM/p1552596311241700