Opened 5 years ago

Last modified 13 months ago

#4275 assigned defect (bug)

Reviews that are moderated, do not keep their ratings

Reported by: dd32's profile dd32 Owned by: dd32's profile dd32
Milestone: Priority: normal
Component: Support Forums Keywords:


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.

Change History (5)

#1 @dd32
5 years ago

An example of where this happened (I've corrected the underlying data) was here:

This ticket was mentioned in Slack in #meta by tellyworth. View the logs.

5 years ago

#3 @tellyworth
5 years ago

  • Owner set to dd32
  • Status changed from new to assigned

This ticket was mentioned in Slack in #forums by dd32. View the logs.

2 years ago

This ticket was mentioned in Slack in #forums by vladytimy. View the logs.

13 months ago

Note: See TracTickets for help on using tickets.