2.9 - Average Rating not displaying

rastacat · March 20th, 2005, 11:49 AM

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

Chuck S · March 20th, 2005, 11:58 AM

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

rastacat · March 20th, 2005, 01:00 PM

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

Al

the showcat page still says no reviews though.

Tom1234 · March 21st, 2005, 10:00 AM

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.

rastacat · March 21st, 2005, 10:14 PM

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

Tom1234 · March 21st, 2005, 10:28 PM

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.

Tom1234 · March 21st, 2005, 10:38 PM

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.

rastacat · March 21st, 2005, 10:52 PM

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

DLWebmaestro · March 22nd, 2005, 03:46 PM

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?

DLWebmaestro · March 23rd, 2005, 09:27 PM

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!

Tom1234 · March 25th, 2005, 02:53 PM

Can we get some help on this one?

caliman · March 30th, 2005, 03:01 AM

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"

Chuck S · March 30th, 2005, 06:20 AM

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

wacnstac · March 31st, 2005, 07:03 PM

Yes I also have the review count problem with 2.9.

memobug · April 7th, 2005, 05:25 PM

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

Chuck S · April 7th, 2005, 06:38 PM

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

memobug · April 7th, 2005, 07:38 PM

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

memobug · April 15th, 2005, 07:46 AM

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

Regards,

Matt

Chuck S · April 15th, 2005, 08:00 AM

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

memobug · April 15th, 2005, 09:38 AM

I am using the files that were in the zip.

both DlWebmaestro and wacnstac above also report the same problem above
2.9 - Average Rating not displaying
2.9 - Average Rating not displaying

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