2011-06-01, 23:05
Has anyone had an issue of duplicates?
I have my media (movies and TV) on a WHS, and have two XBMC (Dharma) Win7 machines. I've tried this a handful of times, and it seems like over the course of a few days, duplicate movies and/or TV episodes start displaying.
To start, I remove the sources from both machines, run the Clean Library option, manually empty (truncate) the MySQL tables, and then add the source back to one of the machines. I let it fully add all the items (it still seems to want to scrape info, even though I have .nfo and image files). Anyhow, they display properly, and seem to be in the database correctly. Then, I add the source to the other machine and let it go through its thing. At this point everything seems to be fine. But, a day or two from that, I'll start to get duplicates.
Right now it's my movies, and I have about 300 duplicates listed. I went into the database and looked up a movie that was being listed twice, and the info in the "movie" table is the same, but in the "path" table, one is correct, and the other points to a totally different movie. Something's obviously getting messed up somewhere, and I was wondering if anyone has run into this, or has any suggestions. All paths in the database are in this format:
smb://WHS/DVD/Training.Day(2001)/VIDEO_TS/
I have my media (movies and TV) on a WHS, and have two XBMC (Dharma) Win7 machines. I've tried this a handful of times, and it seems like over the course of a few days, duplicate movies and/or TV episodes start displaying.
To start, I remove the sources from both machines, run the Clean Library option, manually empty (truncate) the MySQL tables, and then add the source back to one of the machines. I let it fully add all the items (it still seems to want to scrape info, even though I have .nfo and image files). Anyhow, they display properly, and seem to be in the database correctly. Then, I add the source to the other machine and let it go through its thing. At this point everything seems to be fine. But, a day or two from that, I'll start to get duplicates.
Right now it's my movies, and I have about 300 duplicates listed. I went into the database and looked up a movie that was being listed twice, and the info in the "movie" table is the same, but in the "path" table, one is correct, and the other points to a totally different movie. Something's obviously getting messed up somewhere, and I was wondering if anyone has run into this, or has any suggestions. All paths in the database are in this format:
smb://WHS/DVD/Training.Day(2001)/VIDEO_TS/