Subsonic Forum

An album in my collection had a problem with it's title. I used a tag editor to fix it. I ran a scan of media folders and I went back to see my changes to the album in Subsonic, the title was there but all the tracks were gone. The only way I could get them back was to delete the database and scan a new one.

Anyone else seeing this? Any thoughts?

Subsonic is horrible at handling album name changes and is very frustrating when this happens.

Sometimes:
> I am able to move the renamed folder to somewhere that Subsonic doesn't index.
> Run a scan
> Clean database
> Add renamed album/folder back to correct location
> Scan again

This sometimes fixes the problem.
Other times, I pull my hair out, smash my computer against the wall, curse wildly, delete database, and start from scratch.

I have found that if I change the date modified of the folder, Subsonic will treat the album as new and it doesn't disappear.

I have a similar issue with 6.1.1 see viewtopic.php?f=2&t=17158

TL;DR old refreshed albums doesn't get properly updated and won't show up or at least only some tracks. solution is to remove album, scan, clean, readd, scan again... but it's pretty anoying also it's loosing all the stats :/

mason wrote:I have a similar issue with 6.1.1 see viewtopic.php?f=2&t=17158

TL;DR old refreshed albums doesn't get properly updated and won't show up or at least only some tracks. solution is to remove album, scan, clean, readd, scan again... but it's pretty anoying also it's loosing all the stats :/

Simpler solution is to just add/change/remove any file in that subfolder, e.g. renaming cover.jpg to front.jpg.

wendigo wrote:

mason wrote:I have a similar issue with 6.1.1 see viewtopic.php?f=2&t=17158

TL;DR old refreshed albums doesn't get properly updated and won't show up or at least only some tracks. solution is to remove album, scan, clean, readd, scan again... but it's pretty anoying also it's loosing all the stats :/

Simpler solution is to just add/change/remove any file in that subfolder, e.g. renaming cover.jpg to front.jpg.

Thank you so much! That saved me a lot of work. Last time I had this problem, I completely resetup the server. Your solution works like a charm.

That's a nice Workaround but now I've to check every Folder, a lot of uselss work
Please Sindre.-..

Wolke wrote:

wendigo wrote:

mason wrote:I have a similar issue with 6.1.1 see viewtopic.php?f=2&t=17158

TL;DR old refreshed albums doesn't get properly updated and won't show up or at least only some tracks. solution is to remove album, scan, clean, readd, scan again... but it's pretty anoying also it's loosing all the stats :/

Simpler solution is to just add/change/remove any file in that subfolder, e.g. renaming cover.jpg to front.jpg.

Thank you so much! That saved me a lot of work. Last time I had this problem, I completely resetup the server. Your solution works like a charm.

Did you try to open up the url

<UrlOfSubsonic>/db.view

and execute the follwing sql:

Code: Select all

UPDATE MEDIA_FILE
SET children_last_updated = '1970-01-01 01:00:00.0'
WHERE TYPE IN ( 'ALBUM', 'DIRECTORY')
AND PATH LIKE '%YOUR CHANGED PATH%'

then do a rescan of the library.

this helped me to recover 2% of missing songs after the upgrade to 6.1.1. Maybe this is easier than moving files back and forth...

lonesomerider wrote:
Did you try to open up the url

<UrlOfSubsonic>/db.view

and execute the follwing sql:

Code: Select all

UPDATE MEDIA_FILE
SET children_last_updated = '1970-01-01 01:00:00.0'
WHERE TYPE IN ( 'ALBUM', 'DIRECTORY')
AND PATH LIKE '%YOUR CHANGED PATH%'

then do a rescan of the library.

this helped me to recover 2% of missing songs after the upgrade to 6.1.1. Maybe this is easier than moving files back and forth...

Thanks! I run it over all of the folders and got about 6000 songs re-read

I have been able to work around it by creating a CMD file and an "almost" empty TXT file on my server. The TXT file I named UPDATE.TXT and I rotate it between containing a value of 1 or 2 and saving it to update the modification date on the file. The CMD file then proceeds to copy the TXT file into every directory and sub-directory. With this updated TXT file in place, Subsonic seems to re-scan all of the folders.

After making changes to a tags or Album Art, I now just update the TXT file and then run the CMD file and then re-scan the files in Subsonic.

Contents of CMD:

for /r "d:\Music" %%i in (.) do copy /y "c:\update.txt" "%%i"

I noticed this behavior as well. In my case, I was adding album art to mp3 files. I would lose between 50% - 80% of the tracks when the database updated. This started after the update to 6.1 from 6.0.

The solutions mentioned above worked for me.

Is someone able to consistently reproduce this problem, and willing to work with me to troubleshoot it?

That would involve giving me temporary admin rights to your Subsonic server so I can look at the state of the database.

Please contact me on sindre@activeobjects.no if you would like to help out

Thanks
Sindre

sindre_mehus wrote:Is someone able to consistently reproduce this problem, and willing to work with me to troubleshoot it?

That would involve giving me temporary admin rights to your Subsonic server so I can look at the state of the database.

Please contact me on sindre@activeobjects.no if you would like to help out

Thanks
Sindre

I shot you an email on this Sindre. I am willing to work with you to troubleshoot his issue if you are still looking for someone to help.

JamMstrT wrote:

sindre_mehus wrote:Is someone able to consistently reproduce this problem, and willing to work with me to troubleshoot it?

That would involve giving me temporary admin rights to your Subsonic server so I can look at the state of the database.

Please contact me on sindre@activeobjects.no if you would like to help out

Thanks
Sindre

I shot you an email on this Sindre. I am willing to work with you to troubleshoot his issue if you are still looking for someone to help.

Brilliant, thanks! I replied to your email, did you get it?

Sindre

sindre_mehus wrote:

JamMstrT wrote:

sindre_mehus wrote:Is someone able to consistently reproduce this problem, and willing to work with me to troubleshoot it?

That would involve giving me temporary admin rights to your Subsonic server so I can look at the state of the database.

Please contact me on sindre@activeobjects.no if you would like to help out

Thanks
Sindre

I shot you an email on this Sindre. I am willing to work with you to troubleshoot his issue if you are still looking for someone to help.

Brilliant, thanks! I replied to your email, did you get it?


Sindre

Just sent you the information.