I have a zillion of these in my log:

Table '[database-name].votingapi_vote' doesn't exist query: SELECT vote_id, uid, content_id, content_type FROM votingapi_vote WHERE vote_id < -1 ORDER BY vote_id DESC LIMIT 5 in /home/[myname]/domains/[website]/public_html/[subdomain]/includes/database.mysql.inc on line 172.

The table it wants exists. However, the database name is in the format [myname]_ig9fQdr and the table is named ig9f_votingapi_vote. VotingAPI is apparently looking for the table ig9fQdr_votingapi_vote.

Is this something I can fix, or is it a bug in VotingAPI? I don't know yet if it's actually affecting anything, although I'd imagine that if it can't find the table the votes are stored in it's a pretty big problem.

I'm running D5.7 with Apache/2 using MySQL 5.0.45 and PHP 5.2.5.

CommentFileSizeAuthor
#2 votingapi errorlog.png76.18 KBicecreamyou

Comments

icecreamyou’s picture

icecreamyou commented

Another observation: the content_type column is populated with only "node." I think it should be holding "song" and "playlist" content types.

icecreamyou’s picture

icecreamyou commented
StatusFileSize
new votingapi errorlog.png76.18 KB

See attached - that's just a tiny section of the log (filtered for PHP errors - the votingapi table errors only seem to occur after cron runs).

dorien’s picture

dorien commented
Version: 5.x-1.5 » 5.x-1.6

I have a similar problem.

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.

displays when I use the competition module, but only on the competition standings page. Don't know if it has anything to do with votingapi maybe?

bruseleno’s picture

bruseleno commented

Same here

user warning: Table 'gdb.votingapi_vote' doesn't exist query: SELECT vote_id, uid, content_id, content_type FROM votingapi_vote WHERE vote_id < -1 ORDER BY vote_id DESC LIMIT 5 in /var/www/drupal/includes/database.mysqli.inc on line 154.

I have checked the db and the table exists, but with an underscore: gdb_votingapi_vote

liliplanet’s picture

liliplanet commented

Same here

The table does exist, but I think in the votingapi_views.inc it is not reading the table correctly.

My tables have a prefix with drupal, so would be drupal_votingapi_vote and error shows:

.votingapi_vote' doesn't exist

Please, how do I fix that in votingapi_views.inc?

All the best,
Lilian

eaton’s picture

eaton commented
Status: Active » Closed (won't fix)

Support for the 5.x branch of VotingAPI has ended with the release of Drupal 7 and the upcoming release of VotingAPI 7.x-2.4.