Rebuild rp_products.numreviews ?

[Arnie]

Is there any way to rebuild the stats in the product table? For example the numbers in rp_products.numreviews and the rating averages for the products?

For some reason mine aren't right. For example I have a product that have 2 reviews, yet in the category listings it shows "3" because the that's what's in the rp_products table.

When you go to see the product itself the stats are all right.

I think that when the some old reviews were deleted the relevant product stats weren't updated. No idea why, could be down to using beta test code ages ago.


----

Edit: Hmm interesting (just tried something).

If you add a review, then delete it, the product's ratings are updated in the product table, however the number of reviews recorded against that product (again in the product table) is reduced by one.

Would it be better upon deletion or addition of a new/old review to calculate the number of reviews, rather than increasing or decreasing numreviews by one?

[Chuck S]

You can run like the 2.8-2.9 upgrade

[Arnie]

Cheers Chuck, any chance that that code (the while loop that updates/checks the product data) could be added to teh tool list in future versions?

I know that it shouldn't happen, but incase the data does get out of sync it's a handy tool.

I was thinking about it. Is it possible that two moderators have approved the same review at the same time? I didn't see a check in the approve code that checks to see if a review is already approved if the approve routine is run?

Say two people view the approvals page (which would be generated with approval links before a review is approved), one approves a review, and the other does the same, would that account for "ghost" reviews appearing?

[Chuck S]

I do not see anything out of sorts but will check. This is a feature that was added to the product before I began developing it so I never did anything to this