2.9 - Average Rating not displaying
 

showproduct.php

My average rating always shows "None Indicated" despite ratings and comments being placed.

Recommended By Average Price Average Rating
100% of reviewers $250.00 None indicated

--------------------------

Also on showcat.php it always shows "No Reviews" despite reviews being placed.
---
Usergroups are set, they can post ratings and comments, nothing in the moderation or review que.
---
Comments display ok on the product page itself.

Front page correctly shows the last reviews, highest rated does not show however.

Thanks for your assistance.
Al

INSERT INTO settings VALUES (100,'Allow members to rate products?','allowrate','','yes',20,5)

add this query to your settings table of reviewpost. I beleive it is missing from the install file

Thanks Chuck. That fixed the Average Ratings. They now work.

Al

the showcat page still says no reviews though.

I don't think a rating without a text review counts as a "review".

The "Allow members to rate products?" DB insert fixed the problem for me.

Hi Tom1234, my reviews are also full text reviews, I test quite thoroughly before posting here and spend considerable time trying to make sure it's not an error on my end. To date most things have turned out to need fixing. eg, I had a couple hours into this first question before posting it here others could use their resolution.

Are the number of reviews showing up in your showcat.php pages?

Wish I had a solution. Something isn't right with mine.
thanks.. Al

I think you are right. The existing number of reviews I had in those categories are showing up in showcat display, but I added a new review in RP 2.9 and it did not seem to increment the total reviews counter which gets displayed in showcat.php. This appears to be a bug.

Actually, showproduct.php is displaying the proper number of reviews. showcat.php is not if any reviews have been added with RP 2.9. That's odd. I'd expect them to be reading the same value from the DB or counting all the review rows in the same way.

bless you Tom! I"m coming a bit unglued here. My showproduct is working fine, but the showcat is not.

Thanks for the quick fix, Chuck! :)

I'm not having the aforementioned showcat problem, but would running the "Check here to recalculate product/post numbers and check children." do anything to fix this?

Okay, I am having this bug now. Review counts are not updating with new reviews since I've installed 2.9. Running the DB check that I suggested above does not fix this issue. Help! :)

Can we get some help on this one?

Glad I saw this. I will try fix for average when it's not 1am.
I just noticed my rating is not displayed in the post either, is this related? I just have "Review Date: March 20, 2005 Recommend? yes | Price paid: Not Indicated"

Yes this is why they do not show the query is missing on a new install

Yes I also have the review count problem with 2.9.

My review counts don't agree either. After doing this query it fixed the Average Rating & Average Price at least, but the review counts are still screwed up.

I have correct review count at showproduct.php
I have NO REVIEWS at showcat.php for all products (incorrect)
I have correct review count at index.php

Have you dont a recount in admin and see if they appear?

Hi Chuck, Yes I did. No it didn't help.

There are reviews on the second and fourth product on this page, but no reviews show in this category report:
http://www.pspfreaks.com/reviews/showcat.php/cat/7

And yes I had this problem BEFORE I modified the template.

Regards,

Matt

Chuck do you have any other suggestions? You can see a the link above there is an average rating, but "no reviews"

Regards,

Matt

Your sure your using the correct files? There is no issue with reviews showing on showcat screen. It works fine.

numreviews is pulled in the query and then defined as $comcount

in the showcat.php script is this line

$gallery['comline'][$count] = $comline;

In the showcat.tmpl is this

$gallery['comline'][$x]

which is correct and I display review counts on showcat

I am using the files that were in the zip.

both DlWebmaestro and wacnstac above also report the same problem above
http://www.photopost.com/members/for...3&postcount=10
http://www.photopost.com/members/for...2&postcount=14

So I don't think it's ME. Maybe a misunderstanding of how the settings are supposed to work. For some reason reviews always go into moderation. I don't know how to turn that off. But I have approved them and did a recount in Admin, and as you can see if you follow the link 3 posts above, I have reviews contributing to an average, it just isn't showing as a numeric total in showcat, although the product level and main index level seem okay.

Regards,

Matt