### Adding clearart for a TV Show...
02:00:35 T:140119186765568 DEBUG: JSONRPC: Incoming request: {"jsonrpc": "2.0", "method": "VideoLibrary.SetTVShowDetails", "params": { "tvshowid": 38, "art": { "clearart": "http://assets.fanart.tv/fanart/tv/82459/hdclearart/the-mentalist-50f67c3422e93.png" }}, "id": 1 }
02:00:35 T:140119186765568 DEBUG: JSONRPC: Calling videolibrary.settvshowdetails
02:00:35 T:140119186765568 DEBUG: JSONRPC: Type mismatch in type
02:00:35 T:140119186765568 DEBUG: Mysql execute: DELETE FROM taglinks WHERE idMedia=38 AND media_type='tvshow'
02:00:35 T:140119186765568 DEBUG: Mysql Start transaction
02:00:35 T:140119186765568 DEBUG: Mysql execute: delete from genrelinktvshow where idShow=38
02:00:35 T:140119186765568 DEBUG: Mysql execute: delete from actorlinktvshow where idShow=38
02:00:35 T:140119186765568 DEBUG: Mysql execute: delete from directorlinktvshow where idShow=38
02:00:35 T:140119186765568 DEBUG: Mysql execute: delete from studiolinktvshow where idShow=38
02:00:36 T:140119186765568 DEBUG: Mysql execute: update tvshow set c00=NULL,c01=NULL,c02=NULL,c03=NULL,c04=NULL,c05=NULL,c06=NULL,c07=NULL,c08=NULL,c09=NULL,c10=NULL,c11=NULL,c12=NULL,c13=NULL,c14=NULL,c15=NULL,c16=NULL,c17=NULL where idShow=38
02:00:36 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/77784.jpg' where idActor=25124
02:00:36 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/77784.jpg' where art_id=11440
02:00:36 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(25124,38,'Patrick Jane',0)
02:00:36 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/77783.jpg' where idActor=5633
02:00:36 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/77783.jpg' where art_id=14309
02:00:36 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(5633,38,'Teresa Lisbon',1)
02:00:36 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/77787.jpg' where idActor=32770
02:00:36 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/77787.jpg' where art_id=14310
02:00:36 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(32770,38,'Wayne Rigsby',2)
02:00:36 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/92431.jpg' where idActor=9689
02:00:36 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/92431.jpg' where art_id=3604
02:00:36 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(9689,38,'Grace van Pelt',3)
02:00:36 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/77786.jpg' where idActor=32771
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/77786.jpg' where art_id=14311
02:00:37 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(32771,38,'Kimball Cho',4)
02:00:37 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/292104.jpg' where idActor=4322
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/292104.jpg' where art_id=4212
02:00:37 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(4322,38,'J.J. LaRoche',5)
02:00:37 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/220031.jpg' where idActor=32772
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/220031.jpg' where art_id=14312
02:00:37 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(32772,38,'Madeleine Hightower',6)
02:00:37 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/144111.jpg' where idActor=4510
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/144111.jpg' where art_id=12280
02:00:37 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(4510,38,'Virgil Minelli',7)
02:00:37 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/143921.jpg' where idActor=32773
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/143921.jpg' where art_id=14313
02:00:37 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(32773,38,'Sam Bosco',8)
02:00:37 T:140119186765568 DEBUG: Mysql execute: insert into genrelinktvshow (idGenre,idShow) values(4,38)
02:00:37 T:140119186765568 DEBUG: Mysql execute: insert into studiolinktvshow (idStudio,idShow) values(16,38)
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/banner.jpg' where art_id=14314
02:00:37 T:140119186765568 DEBUG: Mysql execute: INSERT INTO art(media_id, media_type, type, url) VALUES (38, 'tvshow', 'clearart', 'http://assets.fanart.tv/fanart/tv/82459/hdclearart/the-mentalist-50f67c3422e93.png')
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/fanart.jpg' where art_id=14315
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/folder.jpg' where art_id=14316
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season-all-poster.jpg' where art_id=14317
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season-specials-poster.jpg' where art_id=14318
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season01-poster.jpg' where art_id=14319
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season02-poster.jpg' where art_id=14320
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season03-poster.jpg' where art_id=14321
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season04-poster.jpg' where art_id=14322
02:00:37 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season05-poster.jpg' where art_id=14323
02:00:37 T:140119186765568 DEBUG: Mysql execute: update tvshow set c00='The Mentalist',c01='When mentalist Patrick Jane insults a vengeful serial killer, Red John, his loved ones are brutally killed. Faced with the horrifying consequences of misusing his gift for observation and misdirection, Jane lends his skills to the California Bureau of Investigation, all the while hoping that his connections within the CBI will give him the opportunity to track down and revenge himself upon Red John.',c02='',c03='',c04='8.700000',c05='2008-09-23',c06='',c07='',c08='Drama',c09='',c10='http://www.thetvdb.com/api/9DAF49C96CBF8DAC/series/82459/all/en.zip',c11='',c12='82459',c13='TV-14',c14='CBS',c15='',c16='/storage/freenas/media/Video/TVShows/The Mentalist/',c17='9' where idShow=38
02:00:37 T:140119186765568 DEBUG: Mysql commit transaction
### Adding clearlogo for the same TV Show...
02:00:37 T:140119186765568 DEBUG: JSONRPC: Incoming request: {"jsonrpc": "2.0", "method": "VideoLibrary.SetTVShowDetails", "params": { "tvshowid": 38, "art": { "clearlogo": "http://assets.fanart.tv/fanart/tv/82459/hdtvlogo/the-mentalist-5050d7dbcc461.png" }}, "id": 1 }
02:00:37 T:140119186765568 DEBUG: JSONRPC: Calling videolibrary.settvshowdetails
02:00:37 T:140119186765568 DEBUG: JSONRPC: Type mismatch in type
02:00:37 T:140119186765568 DEBUG: Mysql execute: DELETE FROM taglinks WHERE idMedia=38 AND media_type='tvshow'
02:00:37 T:140119186765568 DEBUG: Mysql Start transaction
02:00:37 T:140119186765568 DEBUG: Mysql execute: delete from genrelinktvshow where idShow=38
02:00:37 T:140119186765568 DEBUG: Mysql execute: delete from actorlinktvshow where idShow=38
02:00:37 T:140119186765568 DEBUG: Mysql execute: delete from directorlinktvshow where idShow=38
02:00:37 T:140119186765568 DEBUG: Mysql execute: delete from studiolinktvshow where idShow=38
02:00:37 T:140119186765568 DEBUG: Mysql execute: update tvshow set c00=NULL,c01=NULL,c02=NULL,c03=NULL,c04=NULL,c05=NULL,c06=NULL,c07=NULL,c08=NULL,c09=NULL,c10=NULL,c11=NULL,c12=NULL,c13=NULL,c14=NULL,c15=NULL,c16=NULL,c17=NULL where idShow=38
02:00:38 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/77784.jpg' where idActor=25124
02:00:38 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/77784.jpg' where art_id=11440
02:00:38 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(25124,38,'Patrick Jane',0)
02:00:38 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/77783.jpg' where idActor=5633
02:00:38 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/77783.jpg' where art_id=14309
02:00:38 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(5633,38,'Teresa Lisbon',1)
02:00:38 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/77787.jpg' where idActor=32770
02:00:38 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/77787.jpg' where art_id=14310
02:00:38 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(32770,38,'Wayne Rigsby',2)
02:00:38 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/92431.jpg' where idActor=9689
02:00:38 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/92431.jpg' where art_id=3604
02:00:38 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(9689,38,'Grace van Pelt',3)
02:00:38 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/77786.jpg' where idActor=32771
02:00:38 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/77786.jpg' where art_id=14311
02:00:38 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(32771,38,'Kimball Cho',4)
02:00:38 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/292104.jpg' where idActor=4322
02:00:38 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/292104.jpg' where art_id=4212
02:00:38 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(4322,38,'J.J. LaRoche',5)
02:00:38 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/220031.jpg' where idActor=32772
02:00:38 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/220031.jpg' where art_id=14312
02:00:38 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(32772,38,'Madeleine Hightower',6)
02:00:39 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/144111.jpg' where idActor=4510
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/144111.jpg' where art_id=12280
02:00:39 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(4510,38,'Virgil Minelli',7)
02:00:39 T:140119186765568 DEBUG: Mysql execute: update actors set strThumb='http://thetvdb.com/banners/actors/143921.jpg' where idActor=32773
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://thetvdb.com/banners/actors/143921.jpg' where art_id=14313
02:00:39 T:140119186765568 DEBUG: Mysql execute: insert into actorlinktvshow (idActor, idShow, strRole, iOrder) values(32773,38,'Sam Bosco',8)
02:00:39 T:140119186765568 DEBUG: Mysql execute: insert into genrelinktvshow (idGenre,idShow) values(4,38)
02:00:39 T:140119186765568 DEBUG: Mysql execute: insert into studiolinktvshow (idStudio,idShow) values(16,38)
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/banner.jpg' where art_id=14314
### Here's the clearart that was inserted previously...
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='http://assets.fanart.tv/fanart/tv/82459/hdclearart/the-mentalist-50f67c3422e93.png' where art_id=15991
### And now our new item
02:00:39 T:140119186765568 DEBUG: Mysql execute: INSERT INTO art(media_id, media_type, type, url) VALUES (38, 'tvshow', 'clearlogo', 'http://assets.fanart.tv/fanart/tv/82459/hdtvlogo/the-mentalist-5050d7dbcc461.png')
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/fanart.jpg' where art_id=14315
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/folder.jpg' where art_id=14316
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season-all-poster.jpg' where art_id=14317
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season-specials-poster.jpg' where art_id=14318
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season01-poster.jpg' where art_id=14319
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season02-poster.jpg' where art_id=14320
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season03-poster.jpg' where art_id=14321
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season04-poster.jpg' where art_id=14322
02:00:39 T:140119186765568 DEBUG: Mysql execute: UPDATE art SET url='/storage/freenas/media/Video/TVShows/The Mentalist/season05-poster.jpg' where art_id=14323
02:00:39 T:140119186765568 DEBUG: Mysql execute: update tvshow set c00='The Mentalist',c01='When mentalist Patrick Jane insults a vengeful serial killer, Red John, his loved ones are brutally killed. Faced with the horrifying consequences of misusing his gift for observation and misdirection, Jane lends his skills to the California Bureau of Investigation, all the while hoping that his connections within the CBI will give him the opportunity to track down and revenge himself upon Red John.',c02='',c03='',c04='8.700000',c05='2008-09-23',c06='',c07='',c08='Drama',c09='',c10='http://www.thetvdb.com/api/9DAF49C96CBF8DAC/series/82459/all/en.zip',c11='',c12='82459',c13='TV-14',c14='CBS',c15='',c16='/storage/freenas/media/Video/TVShows/The Mentalist/',c17='9' where idShow=38
02:00:39 T:140119186765568 DEBUG: Mysql commit transaction