Despite using vclean regularly there are a huge number of records in both the path and files tables in the database that no longer exist. I can see these when I view my database with mysql.
This is particularly prevalent in my “Unsorted” folder where I keep freshly downloaded stuff before sorting it into my preferred file structure where it will be scanned to the library. these folders have often long since disapeered and are not exspected to re-emerge
So for example
in paths i have things like
Code:
mysql> select idPath,strPath from path where strPath like "%Unsorted%" limit 600;
|
| 3265 | /media/media3/Unsorted-Downloads/Movie.2015.HC.HDRip.XViD.AC3-juggs[ETRG]/
| 3282 | /media/media3/Unsorted-Downloads/Other_Movie.2015.1080p.BluRay.x264-SPARKS[rarbg]/Technically these are not in the library as there is no record in movies or tvshows.
Could we clear this cruft as part of the database clean?