Ratings have doubled?

[sfm_aceman]

I recently upgraded and apprently my ratings have moved from the 1 - 10 scale to 1 - 20 because it's basically added 10 to all ratings within the database. However you can't rate a photo higher then 10 on the gallery.

Can someone please tell me the phpmyadmin (mysql command) to basically subtract 10 from all ratings in the rate ROW of the photo table?

Much appreciated.

Aceman

[Chuck S]

Our rating scale went from 5 to 10 but that was along time ago.

Possibly this would help

UPDATE comments SET rating=rating/2

UPDATE photos SET rating=rating/2

[sfm_aceman]

This fixed my problem thank you!

Aceman