|
|
 Posted 20/07/2005 08:25:37 |
|
|
Junior Member
 
Group: Customers
Last Login: 14/12/2005 15:27:57
Posts: 26,
Visits: 158
|
|
| 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.
|
|
|
|
 Posted 21/07/2005 05:24:27 |
|
|
IF.NET 4.2 Coming Soon
Group: Administrators
Last Login: 2 days ago @ 16:29:04
Posts: 1,956,
Visits: 3,018
|
|
DigiChaos (7/20/2005)
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. 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 
Kindest Regards,
Ryan Healey
Director / Developer
 Explore our products...
http://demos.instantasp.co.uk/
|
|
|
|