RE: Topic Ratings Problem?

Ryan Healey — Thu, 21 Jul 2005 05:24:27 GMT

[quote][b]DigiChaos (7/20/2005)[/b][hr]I am seeing a problem in the display of the Topic Rating stars.

I have many topics where there only two people have rated it. One user rates it 5, another user rates it 4. But on the topic list page it shows that the topic has 2 stars??

How does (5+4) / 2 = 2?

I have reproduced this on this topic http://support.instantasp.co.uk/Topic7696-17-1.aspx.

The topic had 3 stars based on 1 vote. I voted 5, and now it shows 2 stars on the topic list.[/quote]

Hi Digi,

Many thanks. This has been identified as a bug and has now been resolved. The fix will be available with the next release candidate. If you wish to update now you will need to change the MAX aggregate select statement to a SUM aggregate for the TotalRatings variable within the if_sp_UpdateTopicRatingMeanNumber stored procedure. So it would read...

SET @intTotalRating = (SELECT SUM(InstantForum_TopicRatings.TopicRating) FROM InstantForum_TopicRatings (nolock) WHERE (InstantForum_TopicRatings.TopicID = @intTopicID))

Well spotted ;)

Topic Ratings Problem?

DigiChaos — Wed, 20 Jul 2005 08:25:37 GMT

I am seeing a problem in the display of the Topic Rating stars.

I have many topics where there only two people have rated it. One user rates it 5, another user rates it 4. But on the topic list page it shows that the topic has 2 stars??

How does (5+4) / 2 = 2?

I have reproduced this on this topic http://support.instantasp.co.uk/Topic7696-17-1.aspx.

The topic had 3 stars based on 1 vote. I voted 5, and now it shows 2 stars on the topic list.

InstantASP Community Forums / Old Forums / InstantForum.NET 4.x / Bug Reports / Closed Issues / Topic Ratings Problem? / Latest Posts

RE: Topic Ratings Problem?

Topic Ratings Problem?