Librelec - Stang issue adding episodes twice to SQL
#1
I was a few nightly librelec release behind but during the last week i have experienced an issue where 2 epsiode entries were added to my SQL DB for the same episode. This meant my library was showing 2 entries for the same file. The folder shows nothing out of line or different from previous episodes, ie just a single episode but in kodi its showing as if i have 2 episode files. Both entries point to the same file. Cleaning and rescanning my library fails to do anything

Having a quick look at MyPHPadmin i can see 2 entries in there, removing one and cleaning my library fixes the issue

Anyone else had these issue?
All my clients are now running #513 Librelec so this might now be resolved

Thanks
Nick
Reply
#2
Image
Reply
#3
Running #509 and not seeing it in MySQL.
I do see a double entry in SSH using texturecache, but it does not double populate the DB.

Image
Reply
#4
Can't see the path in your image, as that's likely to be the issue (different source?) Dump the tvshow metadata with "texturecache.py jd tvshows <show-name> I pastebinit" and paste the link (replace <show-name> with a partial show name, eg. "custody" if this is "24 Hours in Police Custody").
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
#5
Thanks for the reply

http://pastebin.com/jJVK0zUV

Theres my paste bin, i only took a few of the episodes otherwise it would have been huge
quick look here:
"label": "4x08. The Magic of David Copperfield V: The Statue of Libe rty Disappears"
},
{
"art": {
"season.fanart": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/season04-fanart.jpg/",
"season.poster": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/season04-poster.jpg/",
"season.thumb": "image://nfs://192.168.1.200/volume1/Media/TVSHOWS /The Americans (2013)/season04.tbn/",
"tvshow.banner": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/banner.jpg/",
"tvshow.characterart": "image://http://assets.fanart.tv/fanart/tv/ 261690/characterart/the-americans-2013-5185c85f4e267.png/",
"tvshow.clearart": "image://http://assets.fanart.tv/fanart/tv/2616 90/hdclearart/the-americans-2013-51b3a336f11c7.png/",
"tvshow.clearlogo": "image://http://assets.fanart.tv/fanart/tv/261 690/hdtvlogo/the-americans-2013-51019deb5b075.png/",
"tvshow.fanart": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/fanart.jpg/",
"tvshow.landscape": "image://http://assets.fanart.tv/fanart/tv/261 690/tvthumb/the-americans-2013-510cb9bb8d3da.jpg/",
"tvshow.poster": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/poster.jpg/",
"tvshow.thumb": "image://nfs://192.168.1.200/volume1/Media/TVSHOWS /The Americans (2013)/folder.jpg/"
},
"episodeid": 20979,
"file": "nfs://192.168.1.200/volume1/Media/TVSHOWS/The Americans (20 13)/Season 4/S04E09-The Day After.mkv",
"label": "4x09. The Day After"
},
{
"art": {
"season.fanart": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/season04-fanart.jpg/",
"season.poster": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/season04-poster.jpg/",
"season.thumb": "image://nfs://192.168.1.200/volume1/Media/TVSHOWS /The Americans (2013)/season04.tbn/",
"tvshow.banner": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/banner.jpg/",
"tvshow.characterart": "image://http://assets.fanart.tv/fanart/tv/ 261690/characterart/the-americans-2013-5185c85f4e267.png/",
"tvshow.clearart": "image://http://assets.fanart.tv/fanart/tv/2616 90/hdclearart/the-americans-2013-51b3a336f11c7.png/",
"tvshow.clearlogo": "image://http://assets.fanart.tv/fanart/tv/261 690/hdtvlogo/the-americans-2013-51019deb5b075.png/",
"tvshow.fanart": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/fanart.jpg/",
"tvshow.landscape": "image://http://assets.fanart.tv/fanart/tv/261 690/tvthumb/the-americans-2013-510cb9bb8d3da.jpg/",
"tvshow.poster": "image://nfs://192.168.1.200/volume1/Media/TVSHOW S/The Americans (2013)/poster.jpg/",
"tvshow.thumb": "image://nfs://192.168.1.200/volume1/Media/TVSHOWS /The Americans (2013)/folder.jpg/"
},
"episodeid": 20980,
"file": "nfs://192.168.1.200/volume1/Media/TVSHOWS/The Americans (20 13)/Season 4/S04E09-The Day After.mkv",
"label": "4x09. The Day After"
Reply
#6
(2016-05-15, 10:41)nick w Wrote: Theres my paste bin, i only took a few of the episodes otherwise it would have been huge

That's why I asked you to generate it for a specific tvshow. As it is, the data you've uploaded is a mess and not directly from Kodi - I'm assuming you've scraped it from the screen and then pasted it, which is no good to anyone.

Use the pastebinit command as requested. You started off talking about an episode called "One Punch" then post details for something else entirely. As it is, the data is so mangled it's impossible to tell whether the errors in the metadata have been added by you or were there originally.
Texture Cache Maintenance Utility: Preload your texture cache for optimal UI performance. Remotely manage media libraries. Purge unused artwork to free up space. Find missing media. Configurable QA check to highlight metadata issues. Aid in diagnosis of library and cache related problems.
Reply
#7
Sorry Millhouse.

I will double check it tonight to check if the issue is still there, i will report back later

Thanks
nick
Reply

Logout Mark Read Team Forum Stats Members Help
Librelec - Stang issue adding episodes twice to SQL0