2014-01-30, 17:37
Hi all,
I currently use mysql to serve my media to several xbmc pcs in my flat. I noticed that a couple of tv shows were doubling episodes as I added them (e.g. two copies of S01E01 etc).
So, I took inspiration from this thread: http://forum.xbmc.org/showthread.php?tid=153878 and ran the following MySQL commands:
use myvideos75;
delete from path where strContent != '"';
Now all of the doubled episodes have gone, however update library no longer works. If I select update library, it runs and instantly finishes (having added no new media).
Does anyone have any advice for getting me out of my own stupid situation?
I currently use mysql to serve my media to several xbmc pcs in my flat. I noticed that a couple of tv shows were doubling episodes as I added them (e.g. two copies of S01E01 etc).
So, I took inspiration from this thread: http://forum.xbmc.org/showthread.php?tid=153878 and ran the following MySQL commands:
use myvideos75;
delete from path where strContent != '"';
Now all of the doubled episodes have gone, however update library no longer works. If I select update library, it runs and instantly finishes (having added no new media).
Does anyone have any advice for getting me out of my own stupid situation?
