I need to delete all votes of a specified user (or votes form specified IP adress)?

Im search a lot, but cant find the answer.

Of course im set view to list all votes of user, and all votes from an IP, its ok, but whats next?

Thank for any help!

BR
Janos

Comments

maczkojanos’s picture

maczkojanos commented
Status: Active » Closed (fixed)

Its solved with sql.

funana’s picture

funana commented
Status: Closed (fixed) » Active

It would be very nice if you could post the SQL statements to delete all votes by user or IP.

This should be a feature of the module I think...

marcoka’s picture

marcoka commented

yea, the statement would be nice

pivica’s picture

pivica commented

For user

DELETE FROM votingapi_vote WHERE uid = 127;

For ip

DELETE FROM votingapi_vote WHERE vote_source = '127.0.0.1';

And there is also votingapi_cache, its not easy to erase data from there because we don't have uid or ip data in that table. But cached vote results will be recalculated next time when somebody votes on that content.

And yes I also agree that this functionality need to exist, maybe in votingapi or in some other new module.

legolasbo’s picture

legolasbo
he/him
Primary language Dutch
Location Middelburg
commented
Issue summary: View changes
Status: Active » Closed (won't fix)

Drupal 6 is no longer supported. Closing old issues to clean up the issue queue.

Please reopen and update this issue if this is still an issue in the D7 or D8 version.