I'm trying to make a view where a user can see its pending nodes to vote.

So I add an 'Current user has voted' or any 'Individual...(what ever)...' filter en I get this error.

Unknown column 'votingapi_vote.uid' in 'where clause' query: SELECT node.nid, users.name AS users_name, users.uid AS users_uid, node.title AS node_title, node.changed AS node_changed, node.nid AS node_nid FROM node node LEFT JOIN users users ON node.uid = users.uid WHERE (votingapi_vote.uid = '1') ORDER BY node.created ASC LIMIT 0, 25

The table votingapi_vote is missing in the querry...

Is it a code error or I missing something?

Thanks

Comments

fsimo’s picture

fsimo commented

...I already try the cvs version.

marcoBauli’s picture

marcoBauli commented

similar warning here (and no results displayed):

* user warning: Unknown table 'votingapi_vote' in where clause query: SELECT count(node.nid) FROM node node WHERE (node.status = '1') AND (votingapi_vote.uid = '1') in /includes/database.mysql.inc on line 120.
* user warning: Unknown table 'votingapi_vote' in where clause query: SELECT node.nid FROM node node WHERE (node.status = '1') AND (votingapi_vote.uid = '1') ORDER BY node.created DESC LIMIT 0, 15 in /includes/database.mysql.inc on line 120.

eaton’s picture

eaton commented
Status: Active » Fixed

As of this evening at 2:06 AM, views integration for VotingAPI has been rewritten from scratch. All hail views! The good news? It should actually work. The bad news? You'll need to remove and re-add any VotingAPI fields that you had on existing Views. This shouldn't be problematic, as the old views integration was completely broken anyhow.

Caveats: Output formatting of vote results, etc is still being finished. In addition, much more testing is needed before it can be said that the new integration code is 'ready for prime time.' But it's definitely much better. I'm going to be closing the existing threads regarding VotingAPI and Views because all of them point to known issues with the *old* versions of the code. Those interested in testing the new code can download the latest VotingAPI from: http://drupal.org/node/128605

Thanks for your patience!

Anonymous’s picture

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