Looks like solution was very simple: * DELETE FROM songs WHERE unavailable = 1* And then compact DB. In my case more than 20000 entries was removed from this table.
Komzar czwartek, 10 grudnia 2020 o 08:36:16 UTC Kamil Konarczak napisał(a): > > Hi. My DB is quite big and I found out there is a lot of entries in table > 'songs' related to not existing files. Most probably files moved or > manually deleted over the years. > Because Clementine do not have a DB clean up option i will like to > remove this entries "manually". > Can someone help me to write a Linux script which will remove from this > DB dead items? I do not have experience with SQLite. > > Komzar > -- You received this message because you are subscribed to the Google Groups "Clementine Music Player" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/clementine-player/91e9b222-e5d2-43ec-bed4-474c7a559a3cn%40googlegroups.com.
