Migration from opensuse

philippeg

@jonas hI,
The of the db under the 1.0.11 is the double of the size under 1.0.14 .. i now for sure some folders of flac recors that miss under the 14, but not all ; i can send you the db under 1.0.11 and the db under 1.0.14 but a practical question hors i send to you theses informations ?

rajm

@jonas Maybe I'm confusing the issue, but it seems that this issue https://forum.strawberrymusicplayer.org/topic/963/collection-search-not-always-working/3?_=1676367650199 which I reported is similar?

jonas

@philippeg
If the songs disappear from disk, they are normally marked unavailable, not immediately removed from database, unless you have unchecked that option in the settings. So I can't explain why the size decreased. Did you run an integrity check of the DB? https://wiki.strawberrymusicplayer.org/wiki/Database_integrity_check

I suggest to check if the song is in the database and not marked unavailable, if it's not in the database, or marked unavailable, than the problem isn't the model/query, but elsewhere.
See: https://wiki.strawberrymusicplayer.org/wiki/Accessing_the_database

select url, unavailable from songs where title like '%example%';

Replace "example" with something in the song title that would match the song you are looking for. Or replace title with album to check for a specific album.

jonas

@rajm
I don't know. Can you also manually query the DB and see if the songs are there or not.

philippeg

@rajm no i don't think so .. i have all teh checks and it is all good .. and i can access with the 1.0.11 version

philippeg

@jonas a bit complicated for me i am not a dev at all

philippeg

@jonas you proposed i sent you the db and informations on records missing and my question was how i am dooing that , sending you these informations ?

philippeg

@jonas I just did the following test: I generated the database with 1.0.11; I have all my recordings; I used exactly the same base but with 1.0.14 and there I am missing records...

jonas

@philippeg
You can put the file in dropbox or a similar service and send me the link in private message here.

rajm

@jonas In my case I think it's something to do with the grouping, I've set it to group by album and nothing is shown, if I change it to group by Album artist/Album tracks appear - I notice you ask about group settings above, am I misunderstanding the function of this setting?

jonas

Is this possibly same as https://github.com/strawberrymusicplayer/strawberry/issues/1140

jonas

The issue with compilation albums missing if the first group by is set to other than artist or album artist is fixed. I don't know if this is the same issue, as you didn't answer my question what group by is in use.
If possible test with the latest from https://builds.strawberrymusicplayer.org/

philippeg

@jonas with this latest build I find all my recordings; I erased the database and rebuilt from the musical recordings folders; I had already tried to delete the database and rebuild it with the previous version of 14 but without effect, it seems that this time it worked; the grouping used is genre, album, artist

jonas

@philippeg
The problem was the model/query (querying songs from the database, not updating the database), so there is no need to start with a new database at all.

philippeg

@jonas Yes i tested the last buid on another computer where i don't deleted the db and it is working also