Favorites Lost

Need help? Post your questions here.

Moderator: moderators

Favorites Lost

Postby Immanuel » Mon Apr 01, 2019 7:29 pm

Hi there,

I am using subsonic for a while and therefore have many favorites.
But unfortunately, all are lost, because i moved the music location to another folder.
How can that happen?!

Is there a solution?
I would be too bad if all is lost.

Any idea how to recover?

Thank you :)
Posts: 12
Joined: Mon Apr 01, 2019 7:22 pm

Re: Favorites Lost

Postby Jägs » Thu Apr 04, 2019 2:42 am

First option (the easy way): move the music back. I may be wrong--and others can correct me--but unless you do a clean database operation, the favorites should still be there, so moving the music back to the original path would bring them back.

Second option (the hard way): go into the DB (http://your url/db.view) and update the paths manually. You MUST very careful when you do this, or you risk screwing up Subsonic.

Here's the DB schema:

https://www.reddit.com/r/subsonic/comme ... le_schema/

So, you'd want to do something like this:

update MEDIA_FILE set PATH = replace (PATH, '/old/path', '/new/path')

Not sure I have the syntax exact, as I do not work much in HSQL, but that should get you started.
Posts: 98
Joined: Wed Apr 06, 2011 9:52 pm

Re: Favorites Lost

Postby Immanuel » Thu Apr 04, 2019 5:35 pm

Thank you for the help :)

ok, I have never done anything with HSQL.
Should it look like this?: update MEDIA_FILE set PATH = replace (PATH, '/E:\Musik', 'E:\Daten\Musik')
Unfortunately i have done a complete rescan because i have not known that it causes this failure.

Thanks :)
Posts: 12
Joined: Mon Apr 01, 2019 7:22 pm

Return to Help

Who is online

Users browsing this forum: No registered users and 12 guests