Posts: 26
Joined: Feb 2009
Reputation:
0
2013-05-01, 05:46
(This post was last modified: 2013-05-11, 21:22 by kricker.)
It seems like every other day I have to remove the movies source and readd it, and in turn refresh it, which adds the missing movies back in. After doing this Missing Movie Scanner reports no movies missing.
I am using SQL to sync between three computers. SQL is on a Win7 machine being used as the media server. The Movies source is an SMB share. All three clients are Win7.
Any ideas or thoughts here? I'm a complete newb with SQL, beyond the few steps to get XBMC to sync, and that was because I can follow instructions.
//Afterthoughts.. I think, it might just be my bedroom computer that's dropping movies. Maybe. It happened this evening, and I came to this computer and started XBMC and movies that were missing in the bedroom, were in the library here.
Posts: 31,445
Joined: Jan 2011
MySQL makes all XBMC devices read the same database, so there really isn't a "sync" in the way you are thinking. If one device is different then it is not using the same MySQL DB that the other XBMC devices are. In any case, a
debug log (wiki) would be needed to see what is going on.
Posts: 31,445
Joined: Jan 2011
Can you also upload a debug log from one of the working XBMC machines?
Posts: 31,445
Joined: Jan 2011
hmm, not sure. Debugging wasn't enabled for that log, but even without that additional information, both machines should be showing the same library. Can you upload that second log again, but with debugging enabled? It might give expose errors with the MySQL connection.
Posts: 3,912
Joined: Apr 2004
Reputation:
29
kricker
Team-XBMC QA Specialist
Posts: 3,912
Are you using the clean library option on library updates? If so, and the XBMC running the update can not reach the media (ie the server is off) it will see the items as missing and remove them from the library.
Posts: 3,912
Joined: Apr 2004
Reputation:
29
kricker
Team-XBMC QA Specialist
Posts: 3,912
I have not looked at your log yet, but as I stated earlier, if cleaning is on it will remove items it can not access. So if the server is not on or accessible when the cleaning is called they will get removed
Posts: 26
Joined: Feb 2009
Reputation:
0
2013-05-04, 08:00
(This post was last modified: 2013-05-04, 08:25 by DJ-Anakin.)
ooooooh ok. Gotcha this time. I'll try that. Gotta figure out how to turn the auto clean off.
EDIT: The only setting about cleaning the library automatically that I can see is in the Watchdog add-in. I've turned off "Clean library when files are moved or deleted".
Posts: 3,912
Joined: Apr 2004
Reputation:
29
kricker
Team-XBMC QA Specialist
Posts: 3,912
That may be your issue. There is an advanced setting to clean the library after doing an update. It is done in the advancedsettings.xml. I believe the watchdog add-on was your culprit though.
Posts: 26
Joined: Feb 2009
Reputation:
0
2013-05-06, 01:33
(This post was last modified: 2013-05-06, 01:34 by DJ-Anakin.)
Ya, I think so, too, but, can you point me in the right direction for that setting? I'm not finding anything online.
EDIT: Nevermind..
<cleanonupdate>false</cleanonupdate>
Posts: 26
Joined: Feb 2009
Reputation:
0
Well, that problem is fixed. Thanks for pointing me in the right direction.
Only problem now is that Missing Movie Scanner is still reporting 33 movies missing, only when run on that one computer, and all 33 do show up.
Posts: 3,912
Joined: Apr 2004
Reputation:
29
kricker
Team-XBMC QA Specialist
Posts: 3,912
2013-05-11, 21:21
(This post was last modified: 2013-05-11, 21:21 by kricker.)
I am not familiar with that add-on. Best to talk to the add-on dev.