Hi

When I call the rating/nodes view I've got...

Unknown column 'votingapi_vote.currentuservoted' in 'field list' query: SELECT DISTINCT(node.nid), node.title AS node_title, node.changed AS node_changed, votingapi_cache.value AS votingapi_cache_value, votingapi_cache.value_type AS votingapi_cache_value_type, votingapi_cache.tag AS votingapi_cache_tag, votingapi_cache.function AS votingapi_cache_function, votingapi_cache.content_type AS votingapi_cache_content_type, votingapi_cache.content_id AS votingapi_cache_content_id, votingapi_vote.currentuservoted AS votingapi_vote_currentuservoted FROM node node LEFT JOIN votingapi_cache votingapi_cache ON node.nid = votingapi_cache.content_id AND votingapi_cache.content_type = 'node' LEFT JOIN votingapi_vote votingapi_vote ON node.nid = votingapi_vote.content_id AND votingapi_vote.content_type = 'node' WHERE (node.status = '1') AND (votingapi_cache.value_type = 'percent') AND (votingapi_cache.tag = 'rating') AND (votingapi_cache.function = ' in database.mysql.inc on line 120.

voteapi, jquery are installed

What can I do ???

Thanks

Comments

stevecrozz’s picture

I have the same issue, when I enable the jrating module in drupal 4.7.4 I get that same error inside rating/nodes:

user warning: Unknown column 'votingapi_vote.currentuservoted' in 'field list' query: SELECT DISTINCT(node.nid), votingapi_cache.value AS votingapi_cache_value, node.title AS node_title, node.changed AS node_changed, votingapi_cache.value_type AS votingapi_cache_value_type, votingapi_cache.tag AS votingapi_cache_tag, votingapi_cache.function AS votingapi_cache_function, votingapi_cache.content_type AS votingapi_cache_content_type, votingapi_cache.content_id AS votingapi_cache_content_id, votingapi_vote.currentuservoted AS votingapi_vote_currentuservoted FROM node node LEFT JOIN votingapi_cache votingapi_cache ON node.nid = votingapi_cache.content_id AND votingapi_cache.content_type = 'node' LEFT JOIN votingapi_vote votingapi_vote ON node.nid = votingapi_vote.content_id AND votingapi_vote.content_type = 'node' WHERE (node.status = '1') AND (votingapi_cache.value_type = 'percent') AND (votingapi_cache.tag = 'rating') AND (votingapi_cache.function = 'average') GROUP BY node.nid ORDER BY votingapi_cache_value DESC LIMIT 0, 20 in /nm/sw/drupal/drupal-4.7.4/includes/database.mysql.inc on line 121.

At the same time, if I go to the home page its entirely blank, which may be a theme issue (I'm using after-death theme). But if I disable jrating module the front page is visible again. There are no events in the error log for this one.

--Stephen

stevecrozz’s picture

ah, it helps to read the README.txt; My blank page was the result of a lacking jquery module, and the DB error came from not following the instructions on replaceing votingapi_views.inc. I just get going so fast on projects sometimes I forget to read :(.

Just follow the instructions, then disable and reenable the related modules and it works now.

hickory’s picture

Status: Active » Closed (fixed)