2014-05-18, 20:44
I tried this for the 10th time now, with Gotham 13 and 13.1. But I am not able to update the music library correctly.
The first time I start Gotham, it copies the old MySQL Database (v32) and creates the new one (v46). When I enter the music section in XBMC, it tells me to rescan my collection. I let XBMC rescan everything and after a couple of hours (NFS, many files, it is a little bit slow) it finishes. But now I can not see any music at all in XBMC.
Looking into the database I can see that the "songs" table is still populated, with all my songs and ratings, but the "paths" table only contains one entry. This entry is my starting directory (<ip>/mp3s/music). But all other paths (the subdirectories in this folder) are missing.
If I click "update library" again, it takes a couple of hours and my "paths" table is correctly filled. I can see the songs in XBMC, but unfortunately all ratings are gone (they were present after the first rescan).
I have a lot of smart playlists using these rating information, so I need them.
Has anyone experienced the same behavior? How can I transform the ratings from the old database to the new one? Because I will not rescan everything again, it just takes too long. Do I need to write some kind of script to transfer the ratings from the old database to the new one?
The first time I start Gotham, it copies the old MySQL Database (v32) and creates the new one (v46). When I enter the music section in XBMC, it tells me to rescan my collection. I let XBMC rescan everything and after a couple of hours (NFS, many files, it is a little bit slow) it finishes. But now I can not see any music at all in XBMC.
Looking into the database I can see that the "songs" table is still populated, with all my songs and ratings, but the "paths" table only contains one entry. This entry is my starting directory (<ip>/mp3s/music). But all other paths (the subdirectories in this folder) are missing.
If I click "update library" again, it takes a couple of hours and my "paths" table is correctly filled. I can see the songs in XBMC, but unfortunately all ratings are gone (they were present after the first rescan).
I have a lot of smart playlists using these rating information, so I need them.
Has anyone experienced the same behavior? How can I transform the ratings from the old database to the new one? Because I will not rescan everything again, it just takes too long. Do I need to write some kind of script to transfer the ratings from the old database to the new one?