Favorites Lost

[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

[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:

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.

[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