Edit and re-calculate user votes

  • Hi!

    I had some angry clients who messed up some of my ratings. I want to fix this my removing all votes from specific user IDs.

    I can remove this angry user votes from ‘wp_yasr_log’ by Post ID, user ID etc without effort. But the totals in ‘wp_yasr_votes’ seem to be unaffected. Is there any way for these to be re-calculated? Perhaps a SQL query or PHP function?

    Looking forward to your reply. Thanks!

    • This topic was modified 8 years, 2 months ago by Erik Molenaar.
Viewing 1 replies (of 1 total)
  • Plugin Contributor dudo

    (@dudo)

    Hello,
    Like I wrote in the both changelog and Yasr Official Site from version 1.3.6 YAsr doesn’t use the _yasr_votes table anymore.

    You’ve to delete that data from the table _yasr_log. If you don’t see any changes it’s because yasr use a built in caching system; to delete that cache you can:
    -simply rate again the post or page
    -if you’ve a lot of post or page and the solution above is impossible, in the database, open table wp_options and delete all the rows that contains this option_name

    _transient_yasr_visitor_votes_POSTIDHERE

    where POSTIDHERE is a number different for each row.

    Best,
    Dario

    • This reply was modified 8 years, 2 months ago by dudo.
    • This reply was modified 8 years, 2 months ago by dudo.
Viewing 1 replies (of 1 total)
  • The topic ‘Edit and re-calculate user votes’ is closed to new replies.