[wp-meta] [Making WordPress.org] #4275: Reviews that are moderated, do not keep their ratings

[Making WordPress.org]

#4275: Reviews that are moderated, do not keep their ratings
----------------------------+--------------------
 Reporter:  dd32            |      Owner:  (none)
     Type:  defect          |     Status:  new
 Priority:  normal          |  Milestone:
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.

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/4275>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org