Hi,
I think this may have been mentioned elsewhere but I cant find where. When using fivestar comments I cannot get the Views integration working properly.

For example, I have a view which displays the node titles, the comment counts, and the average comment rating.

Work fine when the node is rated by adding a node: vote results relationship, but when trying to add a comment: vote results relationship it doesnt function and returns a zero. Also, simply adding the relationship causes duplicate entries - one for each rated comment. This is sorted by using 'distinct' but Im guessing not the intended behaviour.

Any help much appreciated,

Thanks for a great module, Joe

Comments

grasmash’s picture

grasmash commented

I'm running into a similar problem. I'd like to create a view that is basically an alternate to the Drupal default comments.tpl.php template.

I've easily set it up so that each comment for the current node is displayed in a table, but I cannot get the "Comment: Vote results" relationship to work at all. Attempting to show the rating that was given for each individual comment simply returns 0. By contrast, the "Node: Vote Results" relationship does work, but using that will merely give me the average rating for the parent node, NOT the rating for each comment. This functionality is present in the comment.tpl.php, but it does not seem that it can be duplicated in Views.

Any help would be appreciated!

Generated SQL statement is:

SELECT comments.cid AS cid,
   comments.name AS comments_name,
   comments.uid AS comments_uid,
   comments.homepage AS comments_homepage,
   comments.timestamp AS comments_timestamp,
   votingapi_cache_comments_percent_price_average.value AS votingapi_cache_comments_percent_price_average_value,
   comments.comment AS comments_comment,
   comments.format AS comments_format
 FROM comments comments 
 LEFT JOIN node node_comments ON comments.nid = node_comments.nid
 LEFT JOIN votingapi_cache votingapi_cache_comments_percent_price_average ON comments.cid = votingapi_cache_comments_percent_price_average.content_id AND (votingapi_cache_comments_percent_price_average.content_type = 'comment' AND votingapi_cache_comments_percent_price_average.value_type = 'percent' AND votingapi_cache_comments_percent_price_average.tag = 'price' AND votingapi_cache_comments_percent_price_average.function = 'average')
 WHERE node_comments.nid = 116
   ORDER BY comments_timestamp DESC
loparr’s picture

loparr commented

did you ever solve this?

dpearcefl’s picture

dpearcefl commented

Did anything ever happen with this?

whiteph’s picture

whiteph commented
Issue summary: View changes
Status: Active » Closed (won't fix)

We can no longer support the Drupal 6 version of Fivestar. It is in security maintenance mode only. When the Drupal 8 version of Fivestar is released, the Drupal 6 version will be officially deprecated.

whiteph’s picture

whiteph commented

See Help testing Drupal 6 patches.