I just created a competition, added a competition entry and when I click on the Competition Entry Standings link at the bottom of the competition, the following error appears (not that the date field doesn't work (other issue), in case it could be related):

user warning: Table 'rawvegan_rawvegan.votingapi_vote' doesn't exist query: SELECT node.nid, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, (SELECT COUNT(value) AS votes FROM votingapi_vote WHERE value = node.nid) AS versus_votes FROM rv_node node INNER JOIN rv_users users ON node.uid = users.uid WHERE (node.status = '1') AND (node.type = 'competition_entry') AND ((SELECT IF((SELECT field_competition_entry_comp_nid FROM rv_content_type_competition_entry WHERE nid = node.nid), (SELECT field_competition_entry_comp_nid FROM rv_content_type_competition_entry WHERE nid = node.nid), (SELECT field_competition_entry_comp_nid FROM rv_content_type_competition_entry WHERE nid = (SELECT parent_nid FROM rv_relativity WHERE nid = node.nid)))) = 424) ORDER BY versus_votes DESC LIMIT 0, 100 in /home/rawvegan/public_html/raw-vegan.org/includes/database.mysql.inc on line 172.

Thanks for the module, I would be glad with any insight you could provide me!

Comments

dorien’s picture

dorien commented

Some extra information: the tabel rv_votingapi_vote does exist. It seems like the query omits the table prefix.

I don't have problems with other content types wich use fivestar with votingapi. Only the competition standings

So it might have something to do with the way I use versus. There is no knows bug like this in versus. So maybe I just forgot some install instruction? Is there anything special you can recommend I look for?

colan’s picture

colan
he/him
Primary language English
Location Toronto 🇨🇦
commented

If it's missing the table prefix, then it could be that some squiggly brackets are missing from the table name in the code somewhere. (That's all I can suggest with what little time I've got these days.) You may want to try grepping through the code in Competition and Versus (and possible Voting API) to see if this is the problem. Let us know what you find!

dorien’s picture

dorien commented

Thank you for your response.

I have decided to not use competitions for the moment. I think it is probably the Versus module, I posted it there too, in case.

So for me it is solved for the moment.

natemow’s picture

natemow commented
Issue summary: View changes
Status: Active » Closed (outdated)

Closing out all legacy 5.x, 6.x issues.