Honestly, I don't know if this should be posted here, or at the Amazon associate tools issues page (perhaps I'll cross post if that isn't a breach of etiquette).

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

eaton’s picture

Status: Active » Postponed

VotingAPI 1.x's views integration is rather jacked up, inherently. I'm very hesitant to pour more work into it as 2.x only fixes the issues by relying on more flexible Views 2 API features.

If anyone's interested in working on a backport of some of the new approaches from the Drupal 6 version, or in working on a 'better' implementation of Views integration for Drupal 5, please contact me directly; I'm interested in a co-maintainer.

eaton’s picture

Status: Postponed » Closed (won't fix)

Support for the 5.x branch of VotingAPI has ended with the release of Drupal 7 and the upcoming release of VotingAPI 7.x-2.4.