Subsonic Forum

I backup all the files under the /Library/Application Support/Subsonic/ folder on the Mac Mini I use to run Subsonic every day.

I noticed that after upgrading to 5.0 to 5.1 today, when I log into Subsonic, I no longer see any of the data associated with the " Starred | Top rated | Most played | Recently played" menu items, but all of the albums that were scanned last night are still there. Also, my playlists are still listed, but when opened, they have 0 tracks.

Is there any way for me to restore the "my starred items" data from a backup? I spend A LOT of time curating all of my music in terms of starred items and I DO NOT want to have to do it all over again.

Thanks,
LeMonkey

Update:

I took a look at the current subsonic.script file and it does still contain entries associated with the STARRED_MEDIA_FILE table. This file also has DB script entries to recreate the CDs that have already been scanned but for some reason while the scanned CD data is still available, none of the starred media entries seem to have been restored during the upgrade from 5.0 to 5.1, unless the schema changed possibly?

Update:

I also took a look at the db.view API endpoint and with a simple query I am seeing results for the STARRED_MEDIA_FILE table:

select * from STARRED_MEDIA_FILE
...
2013 25889 psicom 2015-01-04 16:25:32.169
2014 46533 psicom 2015-01-04 16:57:14.608
2015 53088 psicom 2015-01-10 00:45:42.768
2016 20291 psicom 2015-01-16 21:28:13.002

Does anyone know why this data might not be showing up for the user logged into the Subsonic web app with v5.1?

I'm rescanning the library now to see if that fixes things FYI...

FYI Rescanning the library didn't restore the starred items and related data. Bummed.

Hello,
while upgrading from 5.0 to 5.2 i also have lost my starred items. Even more, now with this new interface i can't find the option to star a media. This was very useful when playing series, as much people mark as starred the watched chapters, so we know wich is the following the have to watch.

Is there any solution for this?

Thanks.

I still haven't heard back from anyone about this and am pretty disheartened.

I've been using Subsonic for a significant amount of time, and am serious enough about it to be a paid contributor.

Obviously the longer you use it the more useful trend-based data like frequently played, etc. becomes.

I even went so far as to create a recurring cron job to backup my database as it's that important to me that I don't lose this information.

In the past I have had no significant issues with upgrades, and to be safe I usually wait for the GM release for each instead of chancing it with the betas.

I'm not sure what changed with 5.1, but while my history data is still technically there since I can view it via the API directly, within the Subsonic web app itself I cannot.

Seriously bummed and have stopped using Subsonic as frequently as I once used to.

Welp, there go 1565 entries.

I just upgraded to 5.2.1 and now the db.view doesn't show any entries for starred items with my previous database backup.

At this point I'm starting over..

I tried to insert an entry into the STARRED_MEDIA_FILE table from my backup and I get a constraint violation:

Integrity constraint violation - no parent SYS_FK_141 table: MEDIA_FILE

My guess is that with the upgrade to 5.1, the primary keys for the media files associated with the starred media file entries changed, making it impossible for the starred_media_file table entries in the backup to point to the actual media_file entries, hence causing no more starred items to show up.

Looks like I'm starting from scratch again with the starred items...

What's strange is that the primary keys for the starred_media_file entries still seems to be picking up where I left off when I star a new item with the latest version..

Before 5.1:

select * from STARRED_MEDIA_FILE
...
2013 25889 psicom 2015-01-04 16:25:32.169
2014 46533 psicom 2015-01-04 16:57:14.608
2015 53088 psicom 2015-01-10 00:45:42.768
2016 20291 psicom 2015-01-16 21:28:13.002

After 5.1 (currently 5.2.1):

ID MEDIA_FILE_ID USERNAME CREATED
2018 175016 psicom 2015-04-19 05:19:10.594

Basically what it looks like what has happened is that the IDs for the media files after the upgrade no longer are in sync with those stored for the previous STARRED_MEDIA_FILE table.

select * from media_file where id = 25889 brings up no results even though 25889 exists in my STARRED_MEDIA_FILE table.

select * from media_file where id = 175016 brings up a result since I just starred that item a minute ago.

Holy crap that is bad! Didn't happen to me, but that would be terrible!

Why not allow users to export * lists?
If there is an import playlist, why isn't there an export??