Comments and ratings lost if folder is moved?

[recked]

Is there any way to retain the comments and ratings when moving a folder?

I've spent a lot of time inputting biographical info and album reviews, but if I ever need to re-organize folder locations, all that data disappears!

I was relieved to find that moving the folder back to its original location did restore the comments and ratings. But is there any way to move folders without losing data?

Also, is there any other data that may be affected by folder moves? Where/how does Subsonic store this info, if I might ask?

Oh, and thanks for creating simply the *best* shared media library in human history.

[recked]

Not to be impatient but I thought I'd bump this back into view as it's kind of critical. I have artists taking time to post info using the comments section as soon as they upload their work.

Is there any way I can avoid losing that info when I move the folder out of Incoming? Where is this data stored?

[recked]

Even if it's to confirm that there's no workaround, any chance I could get a "boo" from a moderator on this thread?

I'm spending lots of time copying and pasting comments whenever I move an upload from Incoming to the alphabetized directory. Is this my best/only remedy?

[steez]

I would like to know this information as well. Comments are useless if you loose the info after you move a folder.

They must be stored in the DB somewhere? Anyone know where?

[Skidd]

I'm not a subsonic mod or developer, but I am a coder.
This "should" help, but it'll require some manual intervention on your part!!

Download and install this little database viewing utility
http://sourceforge.net/projects/jdbview/
(Yes, I wrote it a long time ago )

copy the file
hsqldb-1.8.0.7.jar
from /var/subsonic/jetty/2169/webapp/WEB-INF/lib
Into the folder you installed JDBView

Shutdown Subsonic!
And MAKE A COPY OF THE DIRECTORY
/var/subsonic/db
I repeat COPY THIS DIRECTORY SOMEWHERE!!
It's the Database files. If you mess up, at least you can restore the DB back to how it was.

Launch the JDBView application.

Code: Select all

java -jar JDBView.jar

Or, in windows, you can double click the JDBView.jar file.

Select Menu Item
Database - Connect

Click the "HSQL-DB-File" node

On the right side, leave username and password as they are.
Enter the full path to the database in the "Directory" field
/var/subsonic/db

Enter the Database name
"subsonic"
in the "Database" field.

Click "Connect"

You "hopefully" just opened the database files.
You'll know, because you see a bunch of tabs labeled
sql1, sql2, sql3... etc.
If it failed, you'll see an error message in the "Output Log" tab.
Remember, we're not connecting to a DB Server, but rather opening the small database files up directly.

Now, the fun part, executing some SQL to fix your comment/rating issue.

To see a list of all your music file info enter this into the "sql1" tab and hit "Excecute"

Code: Select all

select * from MUSIC_FILE_INFO

You'll see a long list of all your known music info, including comments and ratings.

Now, depending on your needs, you'll need to run some sql UPDATE commands to fix the changes you've made in your folder structure.

I can help with the commands you'd need, but I'll need to know more about what changes. Did you move ALL your music to a new root location? Or just a couple of artists? If you manage to execute the above query to list all your music files, the "id" and "path" values are the important columns.


When you are done, start subsonic back up.

Shane.

[bushman4]

Even easier...

Go to http://YourSubsonicAddress/db.view

You can perform SQL commands right there.

If you move one folder, the command can be as simple as

Code: Select all

Update Music_File_Info set Path='New Full Path' where path='Old Full Path'

But as Skidd said, if it's not that simple (ie, you moved your whole store or something) then we'd need more info to write the appropriate command.

HTH,

[Skidd]

Beautie!
I didn't even know about that db.view!!
That saves a LOT of extra steps!

[3R3]

thx bushman4! this little db.view is quite undocumented, or the SS DB is. Anyway, this makes recovering lost info so much easier.

[steez]

Thanks! I appreciate the responses.

[bushman4]

Stolen from another post:

Below are the tables I am aware of:
custom_avatar
internet_radio
music_file_info
Music_folder
Player
Player_transcoding
podcast_channel
podcast_episode
role
system_avatar
transcoding
user
user_rating
user_role
user_settings
version

Also info in the wiki:
https://sourceforge.net/apps/mediawiki/ ... e=Database

HTH,