Manually Edit Number Of Plays

[st2llmatic]

Long time payed user, is there a way to manually edit the number of plays for an album? Basically, I had an artist's first single in a folder called "Unreleased Songs" for that artist. When the official full album came out, I deleted this single from Unreleased Songs due to it now being a part of the released album and am wondering if there's any way manually edit the number of plays to update the album to reflect the plays received previously on the other folder.

Thanks!

[hakko]

Yup. If your port number is 4040, go to http://localhost:4040/db.view

Type select * from music_file_info and press OK

Look for the id (first column) matching the path to the album you'd like to update.

Say the id is 42 and the play count you'd like to have is 100 (you listened to it a lot)

Then go to db.view again and type

update music_file_info set play_count = 100 where id = 42

Press OK and that should be it!

[hakko]

(Or I did this on Subsonic 4.6 and it worked. If you wanna play it safe, make a backup of your subsonic settings folder before issuing any SQL command in db.view as it could erase all your statistics, if you get it wrong.)

[st2llmatic]

Thank you so much! This worked flawlessly for me. I made a backup as mentioned also. Thanks for the quick reply!

[tycoonbob]

Just browsing the forum like I do on a weekly basis, and came across this. Geezus, this is so cool...I had no idea that we had a builtin database editor! Time to start playing around!