Subsonic Forum

I reorganized some music and moved a 2 CD set from two separate directories into one directory for all the tracks and renamed that album directory. This new album shows up fine but the old directory with [2 CD] in the name still displays in subsonic web interface. If I click on it there is nothing listed. The directory has been deleted from the file system and I've run a scan and a clean up but it is still sticking around.

Ideas?

Try refreshing your browser... ctrl + F5

Does not help.

It also shows up in both my Dsub installs.

Settings, Media Folders, Clean-up database (Subsonic stores information about all media files ever encountered. By cleaning up the database, information about files that are no longer in your media collection is permanently removed.)

This should work.

I've clicked this yesterday a couple times. But I'm trying it again right now.

What should it say in the log when it completes this? I have it doing a media scan daily and it seems like it should remove missing things then too.

Code: Select all

[4/22/15 3:00:00 AM CDT]   INFO   MediaScannerService   Starting to scan media library.
[4/22/15 3:00:11 AM CDT]   INFO   MediaScannerService   Scanned media library with 250 entries.
[4/22/15 3:00:14 AM CDT]   INFO   MediaScannerService   Scanned media library with 500 entries.
[4/22/15 3:00:16 AM CDT]   INFO   MediaScannerService   Scanned media library with 750 entries.
[4/22/15 3:00:19 AM CDT]   INFO   MediaScannerService   Scanned media library with 1000 entries.
[4/22/15 3:00:23 AM CDT]   INFO   MediaScannerService   Scanned media library with 1250 entries.
[4/22/15 3:00:25 AM CDT]   INFO   MediaScannerService   Scanned media library with 1500 entries.
[4/22/15 3:00:28 AM CDT]   INFO   MediaScannerService   Scanned media library with 1750 entries.
[4/22/15 3:00:31 AM CDT]   INFO   MediaScannerService   Scanned media library with 2000 entries.
[4/22/15 3:00:35 AM CDT]   INFO   MediaScannerService   Scanned media library with 2250 entries.
[4/22/15 3:00:35 AM CDT]   INFO   MediaScannerService   Scanned media library with 2262 entries.
[4/22/15 3:00:35 AM CDT]   INFO   MediaScannerService   Marking non-present files.
[4/22/15 3:00:35 AM CDT]   INFO   MediaScannerService   Marking non-present artists.
[4/22/15 3:00:35 AM CDT]   INFO   MediaScannerService   Marking non-present albums.
[4/22/15 3:00:35 AM CDT]   INFO   MediaScannerService   Completed media library scan.

Clicked clean up and waited. No lines in the log about it.

Clicked scan and it did it's thing. No change. empty link still there.

I still have not gotten this old deleted directory to disappear from subsonic.

How can I just delete my entire subsonic database and rescan from scratch?

Will this wipe out user play statistics? If not how do I do that?

I just did this right now... I've "Scan media folders now" and then i did "Clean-up database" and the dead links/tracks were removed.

P.S. when you click "Clean-up database" wait for the web page to completely reload before you browse again.

I ended up doing this

http://luke.carrier.im/2013/12/fixing-a ... -database/

I've been making changes and deleting things since and no problems.

Cool, nice to hear that It works.

This is killing me! It happens a lot in this release.

Here is how I have been fixing it:

Problem - You rename a folder from "Counting Crows" to "2014--Counting Crows". Now subsonic sees both no matter how many times you clean up database and rescan folder.

Fix - Recreate the stupid directory in addition to the newly named one. So I create a folder called "Counting Crows" and copy any random mp3 into it. Then hit the Clean Database button followed by Rescan Database. You will have 2 folders at this point. Now delete the old "Counting Crows" and viola.

That is such a waste of time and hope that bug gets address in the next point release.

-MH

Guys, this gentleman's page, which I and others have referenced often to clean up database issues, is now off the net...did anyone happen to capture a screenshot or something of the page and instructions beforehand? I am kicking myself that I did not...it was the page at:

http://luke.carrier.im/2013/12/fixing-a ... -database/

Thanks to anyone who can help with the db.view commands that used to be on that site.

Would this help?

http://wiki.cementhorizon.com/display/C ... c+database

It helps a bit, yes, and I had seen that page, but the page I am referring to had the exact SQL statements to use to specifically clear out things like Genres, Playlists, etc. so that you could retain ALL your other settings, including podcast selections, users, settings, players, etc. but get rid of just the table data that you care to. It was a brilliant one page screen grab. Like an idiot I did not screenshot it.