Kodi Community Forum

Hi,

Have been using the database cleaner (https://forum.kodi.tv/showthread.php?tid=272112)
and found that I have a single entry left, but do not know how to remove it.

I used sqlite to check, and it is there:

$ sqlite3 /home/derek/.kodi/userdata/Database/MyVideos108.db
sqlite> select * from path where strpath='/';
375|/||||||||||

Guess it is not going to hurt much as I removed the other 703 unused references, but it would be nice to know how to remove it.

I tried doing a replace for the strpath, but it just ended up referencing all others using that new name.

I figure I need to find the actual entry that is using that path and remove it, but the column names of the tables don't help at all

Regards Derek

If your path table now contains many records with strPath as '/', then that Database Cleaner is not doing its job properly IMO.
Removing those path entries may corrupt your video database even further, but here is the simple-and-direct method:
DELETE FROM path WHERE strPath='/';

Thanks.
I was not sure if there would be dependencies.

Strangely a restart of kodi started using MyVideos107.db  So I moved 108 and reran the database clean.
This time it worked perfectly so the issue is moot.
Checking the same query returned no rows

Not even sure how I got a 108, as https://kodi.wiki/view/Databases shows it as 107 for v17