Posts: 6
Joined: Feb 2015
Reputation:
0
II recently changed out one of my HTPC to Windows 10. This particular machine is the one I use to scan for new media and put it into the database that resides on my server.
When i first set it up, I used the host name instead of the IP by mistake. smb://TD2/...... vs smb://192.168.1.112.... I realize i probably typed the smb starting part wrong, going off memory.
Anyhow, when i realized it, I changed it to how i wanted it.
The problem is now that I've fixed it, whenever it scans a new movie, it adds it to the database with both paths and it shows up twice. If I go into the the database and delete the one with the host name, it leaves it alone mostly. The episodes occasionally rescan the entire library and it all shows up again there with both.
I've searched the sources.xml file and there isn't anything there. i'm at a dead end.
Anyone know how to fix this short of deleting kodi from the machine and starting over?
Posts: 51
Joined: Aug 2013
Reputation:
1
Have you tried running the video database cleanup?
Bill
Posts: 3,575
Joined: Mar 2011
Reputation:
194
2016-01-08, 19:20
(This post was last modified: 2016-01-08, 19:22 by trogggy.)
It (the unwanted source) doesn't need to be in sources.xml to be in the database - but you can't remove it from the database (via the gui) until it's back in sources.xml.
Add the original source again (ie using host name).
If you right click / hit c (or however you get the context menu up) on the unwanted source you should see 'change content' rather than 'set content' come up in the options.
Change content to 'none', clean library, remove the source.
... will probably work.
Posts: 6
Joined: Feb 2015
Reputation:
0
Mrfattbill,
I don't understand how that would help? Its an external mysql database and I've purged it of the wrong path. What would running a cleanup do?
trogggy,
I'll try that in a bit and see if it helps. When I fixed my mistake, I just changed the path, not remove it like that.
Posts: 191
Joined: Jan 2014
Reputation:
4
2016-01-08, 23:14
(This post was last modified: 2016-01-08, 23:16 by Jdiesel.)
I've had this happen before. Easy fix for me was to:
1. Export the library as individual files
2. Drop the MySQL video database
3. Rescan the library
The rescan should be very quick as it will scan the local xml's rather than rescrape the metadata.
Posts: 6
Joined: Feb 2015
Reputation:
0
jdiesel,
thank you for the idea. I don't think this matches up with my issue.
I have a server running mysql and I have bout 8 kodi clients. They all talk to it fine and use it fine.
The only problem is when the one computer I mentioned above scans for changes. It is the one computer that is responsible for updating the database. the other just read the database. As said above, when it scans for new files and it sees a new file it adds it to the database twice. I do not have an issue with how to purge the database of the double files. I go in and manually do that just fine. Its just annoying.
The fix I'm looking for is how to make the one computer that scans, keep from doing it twice. Hoping Troggy's solution works when i try it.
Posts: 6
Joined: Feb 2015
Reputation:
0
Looks like trogggy's plan was the ticket. I'll have to add a few more movies to make sure, but it seems to be working. Thanks a bunch.
Posts: 449
Joined: May 2015
Reputation:
10
Remember that you only set content on one front end when using MySQL. You can also skip adding sources to the other front ends if you don't need them.
I really have no idea what I am talking about. Proceed with caution. I confuse easily. And drink. A lot.
Posts: 6
Joined: Feb 2015
Reputation:
0
that is how i've set it up. Been doing this for about 5 years know and have some pretty advanced setup. I upgraded that one machine to windows 10 and just couldn't figure out why it kept double adding stuff.
