When I look at the votingapi_vote table it's quite clear that there are some spam votes. It's probably some spam / harvesting robots (with China or Brasil IPs usually) which are clicking at exactly first star (vote value 20 from the same IP / 5-20 votes at a time).

This situation rises a question: how to avoid / automoderate (read delete) this kind of bad votes?

Slightly off topic: how to rebuild votingapi_cache table after deleting votes manually?

Comments

quicksketch’s picture

quicksketch
he/him
commented
Project: Fivestar » Voting API
Version: 5.x-1.8 » 5.x-1.x-dev

Seems more like feature that should exist in VotingAPI rather than Fivestar. Maybe a blacklist for registering votes? If desperately needed you can implement this functionality by implementing hook_voting_api and delete the votes as they go in.

eaton’s picture

eaton commented
Status: Active » Closed (fixed)

If you're deleting votes manually using SQL, you'll need to call the votingapi_recalculate_results() function and pass in the content type (node, most likely) and the ID of each node in question.

Any time anonymous voting is enabled, there's a significant risk of spamming.