I tired using the views fast search before I knew exactly what it would do. Seemed pretty self explanatory.
Added the field to all of my views, then realized the views were missing once the field was added. So I took off all of the search:fast index fields from every one of my views, and then it seemed to be fine. I disabled the views fast search module and then I got a bunch of errors. So then I re-enabled the module and the errors went away but then the fivestar voting changed to a raw value. I then changed the raw value back to fivestar and then.....
I get this on the front page where I never messed with any of the views:
user warning: Unknown table 'votingapi_cache_vote_percent_average' in field list query: SELECT node.nid, node.created AS node_created_created, node.title AS node_title, node.changed AS node_changed, votingapi_cache_vote_percent_average.value AS votingapi_cache_vote_percent_average_value FROM drupal_node node WHERE (node.type IN ('submission')) ORDER BY node_created_created DESC LIMIT 0, 9 in /home/15889/domains/openecosource.org/html/includes/database.mysql.inc on line 172.
And this on each view:
user warning: Unknown table 'votingapi_cache_vote_percent_average' in field list query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, node.created AS node_created, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, votingapi_cache_vote_percent_average.value AS votingapi_cache_vote_percent_average_value FROM drupal_node node LEFT JOIN drupal_term_node term_node ON node.nid = term_node.nid LEFT JOIN drupal_term_hierarchy term_hierarchy ON term_node.tid = term_hierarchy.tid LEFT JOIN drupal_node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid WHERE (node.type IN ('submission')) AND (term_node.tid IN ('290')) ORDER BY node_created DESC in /home/15889/domains/openecosource.org/html/includes/database.mysql.inc on line 172.
So then what happens is when I deleted the Voting API field from one of the views, all of the views re-appear (no more error message) but then the rating is still displayed as a raw value.
I begin changing the Voting API to display the fivestar instead of the raw value and everyhting seems to be going fine, I can refresh my views and the fivestar rating appears, but then after about four edits of a view the error message comes back again.
Repeat process.
What do you think I should do?
Comments
Comment #1
zokazola commentedOkay,
I don't know why the views fast search affected my VotingAPI settings but I updated to the dev version and tried cleaning everything up and it worked.