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.

My site is now offline. What do I do?

Comments

zokazola’s picture

zokazola commented
Priority: Critical » Minor
Status: Active » Fixed

Okay,

I don't know why the fast search affected my VotingAPI settings but I uninstalled fast search, reinstalled VotingAPI dev version and reconfigured all the views and its back to normal.

I don't know if you want to look into that minor bug, as to why it would have effected my other views, but everything is back to normal.

Thanks

puregin’s picture

puregin commented

zokazola, I believe that the issues you are experiencing have to do with VotingAPI, and have essentially nothing to do with views_fastsearch. I have experienced similar issues and have applied patches found in the VotingAPI issues queue to resolve them.

Good luck...

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.