Subsonic Forum

How do you move a folder (album) and retain the play count?

This would require a little bit of manual database manipulation.

Go to the db.view page, which is located at http://ip.address:port/contextpath/db.view

To see a list of all Music File Info, use this command:

Code: Select all

select * from music_file_info

To update the stats for a "moved" folder, use this command:

Code: Select all

update music_file_info set path="\\New\Full\Path" where path="\\Old\Full\Path"

Hope this helps,

Glenn

Note (for me at least on Windoze) I had to be logged in with the admin account to SS 1st.
else you get an Access Denied message

This command works: select * from music_file_info

When I use this command: update music_file_info set path="C:\\New\Full\Path" where path="C:\Old\Full\Path"

I get this message below:

Error
Column not found: C:\Old\Full\Path

Those were just examples. Replace the "\\old path" with whatever the path of the folder used to be and the "\\new path" with the new folder path.

Maybe you should give more info about where you are moving files from and to and I'll help you write the correct command.

Glenn

I appreciate your assistance and I understand those were examples. It seems pretty straight forward. I'm simply moving the folder one level deeper into my 'archive' folder. I tried several different folders.

update music_file_info set path=replace(path,'C:\Old\Full\Path', 'C:\New\Full\Path')

DimaH wrote:update music_file_info set path=replace(path,'C:\Old\Full\Path', 'C:\New\Full\Path')

Success! Thank you.