Page 1 of 1

Favorites Lost

PostPosted: Mon Apr 01, 2019 7:29 pm
by Immanuel
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 :)

Re: Favorites Lost

PostPosted: Thu Apr 04, 2019 2:42 am
by Jägs
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: ... 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.

Re: Favorites Lost

PostPosted: Thu Apr 04, 2019 5:35 pm
by Immanuel
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 :)