I posted this in the Voting API issues, but thought perhaps it might be more appropriate here.

I am running Voting API, Five Star, and Amazon Associate Tools, and Views. The website is set up for book, cd, and dvd reviews. Each item (book, cd, or dvd) allows a Five Star vote. Each item also allows the user to add a "Related Amazon.com product id".

For each content type, there is a table View that lists all the books (or CDs or DVDs) in the database, along with their Five Star average.

For some reason, everything works fine, as long as the user has remembered to enter the Related Amazon.com product id. If they do not, and they enter a product without a product id, all users will receive the following error the next time they attempt to view one of the above mentioned table views:

user warning: Unknown column 'votingapi_cache_vote_percent_average.value' in 'field list' query: SELECT DISTINCT(node.nid), node.changed AS node_changed_changed, amazonitem.smallimageurl AS amazonitem_smallimageurl, amazonitem.title AS amazonitem_title, amazonitem.detailpageurl AS amazonitem_detailpageurl, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, votingapi_cache_vote_percent_average.value AS votingapi_cache_vote_percent_average_value FROM node node LEFT JOIN amazonnode amazonnode ON node.nid = amazonnode.nid LEFT JOIN amazonitem amazonitem ON amazonnode.asin = amazonitem.asin INNER JOIN users users ON node.uid = users.uid INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'forum_access') OR (na.gid = 3 AND na.realm = 'forum_access'))) AND ( (node.type IN ('review_music')) ) ORDER BY node_changed_changed DESC LIMIT 0, 10 in /home/teameigw/public_html/includes/database.mysql.inc on line 172.

I'm not astute enough to understand precisely what this error message means. Can anyone help me interpret what's going on?

Thanks!

-David

Comments

wayland76’s picture

Status: Active » Closed (fixed)

No, you were right, it belongs with the votingAPI people.