Subsonic Forum

Hi,

I have an album in my collection that says it has been played 11K+ times. The album only has one song and I feel certain it has not been played that much. Is there a way to reset this?

Thanks,

Joe

This info is in the database.
There's no easy way to edit this info in the database.
My best bet would be to remove the album from your mediacollection.
Next perform a folderscan and a databse cleanup to remove old information about this album from the DB.
Then you can move the album back and perform a new folderscan to make the album visible again.
You might also check if the playcount is embedded in de ID-tag from that one song.
The freeware Windowsprogram AHD ID3 Tag Editor is able to edit the playcount tag in MP3 files.

There is a hidden page called db.view (instead of index.view use db.view in the url)

try it out using

Code: Select all

select * from album

this will produce a list of all albums. find the album you would like to reset

then excute

Code: Select all

update album
set play_count = 0
  , last_played = null
where path='/path/to/your/album';
update media_file
set play_count = 0
  , last_played = null
where path like '/path/to/your/album/%' OR path = '/path/to/your/album';


This should reset the count on album and also on the songs.
but be careful.

Yep, like I said:
There's no easy way to edit this info in the database.

Worked like a champ! Thanks!