Issue with sorting after a review is posted

Hi,

I have an issue that new reviews don’t update the order of the products on the archive page when “sort by average rating” is selected. Products with high rating appear after unrated products. After trying to deactivate all the plugins and trying to figure out the issue, I found that unapproving the review then approving it again solves the issue and puts the products in the expected order.

Any solutions to this issue ?