I am having a problem with duplicates in my video library. It started when I used the Library Auto Update addon from the Kodi repository. It happens on SMB shares. Some of the DB entries, as an example, use a path smb://192.168.0.10 and some use smb://102.168.0.10:445. I think this came about from carrying over the DB to fresh installs. The addon seems to have ignored the path with the port and made a ‘duplicate’ using the non-port path. That is, one entry using the path with the port one without the port. I think the first step is to make sure my video sources are corrected (without port?). I am not blaming the addon. I am not even sure it caused the problem. It’s just that it’s the only thing I can connect to the timing of the problem.
What would be the best approach to fixing this problem without recreating the library? I am capable of writing my own DB scrub as long as I know what tables and columns would be affected besides strPATH in table path. Any ideas?
If I have to recreate the DB, is there a way to carry over the episode-watched setting?
I am using Kodi 20.3 on android and X64 and MariaDB 10.3 on a Synology box (Not in docker).
=w=