Cleanup library.db

[syralk 13]

 

What will be the best SQLITE command to remove all the files associations in the database to force a re-scan of the library without removing the Root folders,  playlist / users and watched status?
a little bit the same way if I would do a restore backup from a empty system.

thanks

 

Edited November 25, 2020 by syralk

[Luke 42083]

Hi, there isn't one. The server has it's own cleanup routines. The only waste you might have might be entries caused by defects in older server versions.

[syralk 13]

9 hours ago, Luke said:

Hi, there isn't one. The server has it's own cleanup routines. The only waste you might have might be entries caused by defects in older server versions.

I see once in a while the server stop updating a path for some reason, even if I try to remove it and add it back it seem to not work

this is why I ask for this

[Luke 42083]

Right unfortunately we don't have a magic formula to locate these records. If we did we'd just clean them up automatically. The good news is that with newer server versions it shouldn't happen with new records going forward.

[syralk 13]

6 hours ago, Luke said:

Right unfortunately we don't have a magic formula to locate these records. If we did we'd just clean them up automatically. The good news is that with newer server versions it shouldn't happen with new records going forward.

thanks