WordPress.org

Making WordPress.org

Opened 8 months ago

Last modified 7 months ago

#4275 assigned defect

Reviews that are moderated, do not keep their ratings

Reported by: dd32 Owned by: dd32
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.

Change History (3)

#1 @dd32
8 months ago

An example of where this happened (I've corrected the underlying data) was here: https://wordpress.slack.com/archives/C02QB8GMM/p1552596311241700

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


7 months ago

#3 @tellyworth
7 months ago

  • Owner set to dd32
  • Status changed from new to assigned
Note: See TracTickets for help on using tickets.