This does not work.
Someone decided to have fun and rate every photo 1 star! I can say a few of them deserved a 1 rating, but most of them didn't. Anyway, is there an easy way to clean up this mess?
I just deleted the data from bx_photos_rating and bx_photos_voting_track
Unfortunately, it looks like the ratings have already be calculated and entered into bx_photos_main.
Other than manually updating each record, does anyone have any other suggestions on how to fix this?
Also, two other questions:
- Shouldn't admin have the ability to delete ratings?
- Shoudn't ratings be deleted when a user is deleted?
