Subsonic Forum

I am running 4.6 (build 2583) on Win08 R2.

Just curious if there is a way to clear the "Most Played" albums section for it to reset and start over? I just wanted to clear it with the start of 2012. Thanks for any help!

If you want to reset your all your album play counts to 0 then you can do this easily via db.view.
See viewtopic.php?f=2&t=7857&p=31452&hilit=database#p31452
for more info but basically you need to issue "update music_file_info set play_count=0"

BKKKPewsey wrote:If you want to reset your all your album play counts to 0 then you can do this easily via db.view.
See viewtopic.php?f=2&t=7857&p=31452&hilit=database#p31452
for more info but basically you need to issue "update music_file_info set play_count=0"

Ahhh thanks! That worked perfectly, all reset now

Great tip! Just had to use this today. That db.view is cool, very cool!

Just note that in order for the changes to be saved permanently, you have to do a soft shutdown the next time your restart. If you pull the plug, when you start it up again, things may not be the way they are supposed to. Just saying.

ytechie wrote:If you pull the plug, when you start it up again, things may not be the way they are supposed to. Just saying.

From experience if you just "pull the plug" nothing may be the way they are supposed to be, SS included

Greetings

I'm also trying to reset "Most played" albums.

I'm running ss 4.9 on a Mac (OS X 10.8.5)

I can access ss at

https://localhost:4443

no problem. But when I try to access

https://localhost:4443/contextpath/db.view

I get this:

HTTP ERROR: 404

EDIT:

OK, I figured it out. This works in ss 4.9 on a Mac. ss is on https, port 4443.

Log in as admin. Go to https://ss_server_address:4443/db.view

Enter this in the text box:

update media_file set play_count=0

and click the [OK] button. This resets all the play counts to zero. Clicking the [Most played] button in ss gives a blank result.

Also can do this: enter this in the text box:

update media_file set last_played=''

This deletes all the last_played values. Clicking the [Recently played] button in ss shows all dates to be 1/1/70.

Note that the media_file_info table has been renamed to media_file.