Playlists are not being updated

[raptor7197]

Steps to reproduce the bug

restore the backup songs from a backedup .db file
try to add a random song to a playlist
the song is not added to the playlist when we restore the data from a file
It shows the same songs that were saved in the .db file even after updating the playlist

Expected behavior

the song should be added to the playlist

Actual behavior

It is not being added to the playlist

Screenshots/Screen recordings

No response

Logs

No response

ViMusic version

1.1.1

Android version

Android 14

Additional information

I guess when the app is started it is reading from the .db file everytime , like a loop

[haturatu]

Hmm, that's strange. I tested it on Android 15, but I couldn't reproduce the issue.
Even if it's a database insertion problem, it should operate the same since both Android 14 and 15 run on the same API level.
Does this happen with just one playlist, or does it occur with all playlists?

[raptor7197]

It is occuring with all the playlists

[haturatu]

Hmm, it's possible that the issue arises due to differences in language settings, but verifying everything might be quite challenging. What language was used during your export?

If you're unsure, you can check using the following SQL query

$ sqlite3 ViMusic_backup_20241205202048.db.sqlite 

sqlite> .table
sqlite> SELECT * FROM android_metadata;

and more

sqlite> SELECT * FROM Playlist;

I'm curious about what might be causing this issue.

[haturatu]

Is it possible that this issue occurs with something other than playlists? Could it also happen with favorite artists or albums?

[raptor7197]

no it isnt occuring with favourites and history also isn't affected
it is just with the playlists
artists seems unaffected too

[haturatu]

If possible, could you provide the database? I can share mine database as well for testing purposes. If you prefer not to use GitHub, i can use Signal, Telegram, or email (MyHosting).

[raptor7197]

https://hack.chat/?2ggzbqs9
will share contact details here

[haturatu]

I have investigated, and it turns out your database is not corrupted. Additionally, it worked on my Android 15 device.
I will test it in a virtual environment, so please allow me some more time.
Currently, my Android Studio/build machine has been disassembled due to a move, so I will need to rebuild that environment before continuing the investigation.
Therefore, I will leave this issue open for now.

[raptor7197]

Hey ,
I just have noticed another thing that the names of the playlists that don't have emoji's in they are working fine .
the issue is only with the playlists with emoji's in their names. i have changed a playlists name and i am able to add songs to it now.

[haturatu]

Thank you for the specific information! I’ll test it on my end as well. That does seem like it could cause inconsistencies. I completely overlooked that.