Multi-axis Review System using Fivestar with Views Implementation for Drupal 6

I am trying to make this work also, but the tutorial assumes that I know more about Drupal than I do.

• For steps #1 & #2 you are creating a node type but to me it makes more sense to call it a content type in this situation
• To me, it seems much clearer if the instructions read
  
  Create a new content type called "Review" and save it. Then under the [Manage Fields] tab, add a node reference field ...
  
  Instead of:
  
  Create a new node type called "Review". Save the node and add a node reference field with the label "Select the product you wish to review" and field name "product_reference". (how did you complete the instructions in the first sentence WITHOUT saving it?)
• This statement is not quite accurate:
  "This tutorial was written based on testing performed in the following environment:"

  If any of the tutorial discusses views, installing it should be a pre-requisite, or at least mentioned.

• Also:
  "Copy node.tpl.php and rename it node-product.tpl.php"

  Might be re-written "Copy node.tpl.php to node-product.tpl.php".

template part works. views all good until creation of relationship - it immediatly returns error

Unknown column 'votingapi_cache_node_percent_overall_overall_average_average.tag_other'

OR .value_type_other. "overall" is tag or axis.

How to set the widget to display current average in text (example:Average: 2.5 (20 votes)) below the stars? I guess node-product.tpl.php should be edited but I don't know how.

i applied the php code to node-product.tpl.php and no widget is appearing on the node display. when i use devel to check, it shows that it is still using the node.tpl.php file with candidate node-product.tpl.php < node.tpl.php, what am i doing wrong? thanks in advance

I want to view the rating of nodes by sum of given votes. In "Add relationships" i choused "Vote results"
Value type: No filtering
Vote tag: No filtering
Aggregation function: Total score

And here is the query:
SELECT nid,
votingapi_cache_node_sum.value AS votingapi_cache_node_sum_value
FROM node node
LEFT JOIN votingapi_cache votingapi_cache_node_sum ON node.nid = votingapi_cache_node_sum.content_id AND (votingapi_cache_node_sum.content_type = 'node' AND votingapi_cache_node_sum.function = 'sum')
ORDER BY votingapi_cache_node_sum_value DESC

But it does not work (((
There is no row with function = sum for any nodes in the table votingapi_cache
It may be the bug of this module (fivestars) or i'm doing something wrong (((
plz, if somebody do something like this, help me ((

ps: sorry for my english )))

I got it almost working the way I want. Thanks for this great tutorial.

But i would like users to be able to vote on the product page itself.

So instead of

and when trying:

Does anybody know if it's possible to vote on the products page?

Great guide, but I've got one problem I can't figure out...
I followed the 4 steps in the guide, but I used 10 stars to rate with, instead of the normal 5, but when I completed the 4th step (Step 4: Build a view that displays all "Product" nodes and the average of each rating given to each "Product" node. Sort views by highest rating in different categories.) it looked strange when it had to display the 10 rating-stars in 'Views'... So I changed it back to 5 stars...
After changing back to 5 stars, 'Views' still displayed 10 stars..! So I deleted the 'View', and made a new by following the guide, but IT STILL DISPLAYS 10 STARS IN THE 'VIEW' ???? How come ??? I tried running a cron-job and I tried refreshing the page, but nothing changes...

Please help...

Thanks,

Marc.

(Add a second Relationship of type "Node: Voting results"). I cannot find the Nodetype "Voting API". How can I solve this?

Anyone had an issue of fivestar allowing multiple votes? I followed the instructions here but a user can vote as many times as they want... dont know why!

Thank you for the great tutorial. Like some others here, I ran into some things I wanted to add/modify with this set up so I thought I would share the results. Note that I've only been using Drupal for about a month and do not have strong PHP skills, so I lean strongly toward the "find a module for it" side of things.

First, for those wanting to take the "selection list" for the node reference field out of the equation, I recommend http://drupal.org/project/nodereference_url The Node Reference URL Widget allows you to: a) auto-enter the node-reference field from the "product" page into your "review" node creation and make it uneditable b) easily add a link to the "product" page to "create a review".

In addition, I really wanted to display the aggregated (average) axis votes and user reviews in separate blocks. I felt this would give me more control over the layout since the solution above buries the display within the content. Again, being new to Drupal, I struggled to get this working because I was missing one integral piece. Since blocks on a page apparently don't automatically know what node is being displayed in the content (or am I missing something), you have to tell the block view what to do if the argument isn't present, ala this post: http://drupal.org/node/928382

This has allowed me to place the reviews in a block below the product content which will hopefully give me better control over formatting through theme and CSS. I'm still trying to determine a way to place the aggregate averages of votes in the layout without hardcoding PHP in the template layer. I'm aware of the Calculated Field module but, again, I don't have strong skills in PHP so I'm seeking something more point any click.

Any suggestions would be appreciated!

Hello,
I've struggled with this tutorial to make it work on drupal 7, and I think I have it now, so here is the thing (assuming you take the same two voting axis) :

Required modules

• Fivestar (dependancies: Voting API) ;
• CCK ;
• Node reference (at the moment there is an issue with the release version when creating a field with node_reference, so make sure to install the dev version) ;
• Views (dependancies: Chaos tools).

Step 1: Create the rating axis

Go to Configuration » Fivestar (admin/config/content/fivestar) and add as many axis you like in the "Voting tags section".

Step 2: Create the Product node type using CCK and create a Product

1. Create a new content type called "Product" (I disabled the comments on the "Comment settings" tab because I want the reviews to replace the comments, but you don't have to).
2. Edit the content type and under the Fivestar voting tab, make sure the "Enable Fivestar rating for the "your_axis" tag" is checked for each axis you need.
   This is important because votes made by the Review content type will not be calculated unless this box is checked.
3. Select "Hidden" under "Teaser Display" and "Full node display".
   This will hide the rating widget on the Product nodes (we don't want the widget on the product nodes, we want it on the Review nodes).
4. Repeat this settings for each axis you need.
5. Save this content type
6. Create a Product node titled "Product A". Note the URL of this node as you will need to come back to it later.

Step 3: Create the Review node type with multiple rating fields using CCK and create a Review node

1. Create a new content type called "Review".
2. Click on Save and add fields.
3. Add a node reference field.
1. Set the label to "Select the product you wish to review".
2. Set field name to "product_reference".
3. Select "Node reference" as the field type.
4. Save the field.
5. Check the "Product" node type under "Content types that can be referenced".
6. Save the field settings.
7. Make the field a required field.
8. Save the field.
4. Add a Fivestar rating field.
1. Set the label "Reliablity Rating".
2. Set field name "reliability".
3. Select "Fivestar rating" as the field type.
4. Save the field.
5. Under "Voting target" select the node reference field "field_product_reference". No need for php code.
6. Under voting tag, choose "reliability".
7. Save the field settings.
8. Make the field a required field.
9. Save the field settings.
5. Add a second Fivestar rating field.
1. Set label to "Value Rating"
2. Set field name "value".
3. Use the same field settings as the "Reliability Rating" field
4. Under voting tag, choose "value".
5. Save the field settings.

Now you can create a Review, enter a title, enter body text (optional), give it a rating, and select "Product A" under "Select the product you wish to review". Submit the review.

Step 4: Display the reviews on the product page

No need with the use of the Views module for php code, here is the trick :

1. Add a new view (admin/structure/views/add).
1. Select the Product type of content under the "Show" option.
2. Uncheck the Page option, go for the "Create a block" option.
3. Name it, say, "Users' review" (or anything you like).
4. Choose an unformatted list of full posts (or a grid or whatever, here I choose an unformatted list, without any links or comments).
5. Set the number of items per page at the desired value.
6. Click on Continue & edit.
7. Add a new Contextual filter.
8. Check "Content: Select the product you wish to review (field_product_reference)" and click on "Add and configure…".
9. Choose "Provide default value", then "Raw value from URL" and then 2 for "Path component".
10. Save by clicking on Apply. This step is useful to tell your block to load only the reviews linked with the product, and not all the other reviews. You *may* have to toy with this option to suit your specific website settings.
11. Save the view.
2. Let's get the reviews displayed ! Go to the block configuration (admin/structure/block).
1. Click on configure on the review block at the bottom of the page.
2. On the Content types tab at the bottom, check Product on "Show block for specific content types".
3. Save block.
4. Move the Reviews block you've just edited at the bottom of the page to the Content region.
5. Save blocks.

There you go, it worked for me, but I'm not sure it will work as well for you. I'm interested to know if that worked for you, and if not, maybe we can figure out why and so have a 7.x tutorial working fine ! Any hints, further (and smarter) settings or feedback welcome !

Hi, I am using Drupal 6.22 and the latest versions of 5 star, Voting API , CCK modules. After embedding the said code in custom node node-product.tpl.php... on the Product page I do see the 5 star widget .. however there are two problems with the widget :
a) It shows no rating whatsoever, all the stars are white (and of course its not possible to rate here)
b) I have submitted multiple user reviews (of different users) yet no average vote is displayed.

In my attempt to trace the issue , I realized that in the code

Please help.

I have something set up very similar but I am having problem if I delete a node with a review... review --> organization. When the review is deleted the vote remains associated with the organization.

Help would be very much appreciated.