[MsTrMind]

Dear all,

At first, I'm sorry if this is posted in the wrong thread...
Second, I LOVE Kodi/XMBC, been using it for a little over 5 years now!

But, due to my own stupidity, I ran into a problem.
First some small infra-topology:
- cheapo nas (Hostname: NSA325, ip 192.168.0.191) - MySQL server + hosts all my video's
- HTPC (Win10 + Kodi17)

I moved not that long ago, and broke my HTPC on the way to my new house.
Reinstalled it, installed Kodi onthere, copied over my advancedsettings.xml BUT I FORGOT MY SOURCES.XML :'( :'(
So had to add them manually.
I used to be setup as "smb://NSA325/Series/", but due to not paying enough attention, I added "smb://192.168.0.191/Series"

=> result, some of my series got scanned a second time, and written to the MySQL database a second time...
Very annoying, as every episode is listed twice, once with the correct path, once with the incorrect path


I know the basics of SQL commands, relations etc etc etc, but my knowledge does not go far enough to correctly fix my own mistake..

So I would like to ask some help from you guys. What would be the correct approach to drop the duplicate?


Thanks A LOT!


Screenshots that might explain better what I'm experiencing: