995305 - Firefox OS app user rating not showing up

Status: VERIFIED FIXED

(Marketplace Graveyard :: Consumer Pages, defect, P2)

Description

[Frédéric Harper]

One developer I'm working with report to me he got a review on his Firefox OS application [1], but it's not listed on the application page [2], neither in the reviews listing his application [3]. Is this review lost somewhere in the system?

It would be important to find the problem as rating help (or not) developers get more visibility for their applications.

[1] https://marketplace.firefox.com/app/zhongwen-garden/ratings/570672
[2] https://marketplace.firefox.com/app/zhongwen-garden/ratings/570672
[3] https://marketplace.firefox.com/app/zhongwen-garden/ratings/570672

Comment 1

[Wil Clouser [:clouserw]]

https://marketplace.firefox.com/app/zhongwen-garden does say "App not yet rated".  There is only one version of this app so they aren't for an old version or anything.

Comment 2

[Frédéric Harper]

Good point, forgot to add this to my bug report, thanks Wil.

Comment 3

[Mathieu Pillard [:mat]]

We denormalize the app reviews count & rating in a task, and use the denormalized values later to check if there are reviews to show. In this case:

mysql> SELECT totalreviews, averagerating FROM addons WHERE app_slug='zhongwen-garden';
+--------------+---------------+
| totalreviews | averagerating |
+--------------+---------------+
|            0 |             0 |
+--------------+---------------+
1 row in set (0.24 sec)

So, either the task didn't kick off, or it is buggy for some reason. I'll investigate a bit.

Comment 4

[Mathieu Pillard [:mat]]

I manually fixed the app by submitting a review and immediately deleting it, that seems to have done the trick.

I fixed the underlying problem, or what I think is the underlying problem, in https://github.com/mozilla/zamboni/commit/acd2881c1f3d4beeed0fe4dd066448d6fd39abcc


QA:
The original problem is difficult to reproduce, but at least make sure that the following still works:
- Submit an user review for an app with no reviews
- Open a new, separate browser and look at the app detail page, you should see the review in the list

Comment 5

[Madalin Cotetiu]

Verified as fixed in FF36(Win7) in marketplace-dev.allizom.org
Postfix screencast: http://screencast.com/t/zjUAkZ4cW