2026-10-21 21:34:12 . 11 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:34:12 . 12 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:34:12 . 12 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:34:14 . 83 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:34:26 . 88 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:34:27 . 13 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:34:27 . 14 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:34:27 . 14 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 21:34:35 . 31 - SetUserConfiguration - 'LastEpisodeDirectory', '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]', 'Collection Management'
2026-10-21 21:34:35 . 31 - TVEpisodeControl.CheckMove
2026-10-21 21:34:35 . 31 - TVEpisodeControl.CheckMove - File From '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]\11.22.63 [Season 1 Episode 01].iso' to '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]\11.22.63 [Season 1 Episode 01].iso'
2026-10-21 21:34:35 . 32 - TVEpisodeControl.CheckMove - Directory From '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]' to '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]'
2026-10-21 20:34:38 . 91 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:34:39 . 05 - TVEpisodeControl.btnAddEpisode_Click - path set to: \\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]\11.22.63 [Season 1 Episode 01].iso
2026-10-21 21:34:39 . 05 - TVEpisodeControl.btnAddEpisode_Click -  txtFilePathValue: \\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]\11.22.63 [Season 1 Episode 01].iso
2026-10-21 21:34:39 . 05 - TVDatabase.UpdateEpisode
2026-10-21 21:34:39 . 05 - TVDatabase.UpdateEpisode - Open objConn
2026-10-21 21:34:39 . 06 - Language Inserted:
2026-10-21 21:34:39 . 06 - English
2026-10-21 21:34:39 . 06 - TVDatabase.LookupLanguageGuidFromLanguage - Language 'English' - Transaction: 'True'
2026-10-21 21:34:39 . 06 - TVDatabase.LookupCountryGrid - Country Name 'United States', Transaction: 'True'
2026-10-21 21:34:39 . 06 - TVDatabase.LookupCountryGrid - Returning 'True' from cache
2026-10-21 21:34:39 . 06 - Common.Database.ExecuteReader - 'SELECT guidEpisode FROM tblEpisodePersonal WITH (NOLOCK) WHERE guidEpisode = '6585dba5-58ac-4370-b3a4-33d5e48b3648''
2026-10-21 21:34:39 . 06 - TVDatabase.UpdateEpisode - personal parameter for sql call: nvcPath = '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]\11.22.63 [Season 1 Episode 01].iso'.
2026-10-21 21:34:39 . 07 - Common.Database.ExecuteNonQuery - 'UPDATE tblEpisodeGlobal SET [nvcOriginalTitle] = @OriginalTitle ,[intSeasonNumber] = @SeasonNumber ,[intEpisodeNumber] = @EpisodeNumber ,[nvcProductionCode] = @ProductionCode ,[intAbsoluteNumber] = @AbsoluteNumber ,[nvcDVDDiscId] = @DVDDiscId ,[nvcDVDSeason] = @DVDSeason ,[nvcDVDEpisodeNumber] = @DVDEpisodeNumber ,[nvcDVDChapter] = @DVDChapter ,[decTVDBRating] = @PublicRating ,[guidSerie] = @SerieGuid ,[intAddType] = @intAddType ,[guidAddId] = @guidAddId ,[datDataChanged] = @globalDataChanged ,[bitEdited] = @IsEdited WHERE guid = @EpisodeGuid DELETE FROM tblEpisodeLanguageSpecific WHERE [guidEpisode] = @EpisodeGuid INSERT INTO tblEpisodeLanguageSpecific([guidEpisode], [guidLanguage], [nvcName], [ntxOverview], [nvcSortName],[datDataChanged],[bitAlternative],[bitEdited])VALUES(@EpisodeGuid, @LanguageGuid, @Name, @Description, @SortName, @languageDataChanged, 1, @LanguageEdited) DELETE FROM tblEpisodeCountrySpecific WHERE [guidEpisode] = @EpisodeGuid INSERT INTO tblEpisodeCountrySpecific([guidEpisode], [guidCountry], [datFirstAired], [datDataChanged], [bitEdited])VALUES(@EpisodeGuid, @CountryGuid, @CountryFirstAired, @CountryDataChanged, @CountryEdited) UPDATE tblEpisodePersonal SET [nvcPath] =  @nvcPath ,[nvcMobileLocationPrimary] =  @nvcMobileLocationPrimary ,[nvcMobileLocationSecondary] =  @nvcMobileLocationSecondary ,[intRating] = @ownRating ,[bitWatched] = @Watched,[datAdded] = @datAdded,[datDataChanged] = @datDataChanged WHERE [guidEpisode] = @EpisodeGuid UPDATE tblEpisodeGlobal SET [lngProgress] = @lngProgress WHERE guid = @EpisodeGuid DELETE FROM tblWatched WHERE guid = '6585dba5-58ac-4370-b3a4-33d5e48b3648'DELETE FROM tblRemoteIDs WHERE guidItem = @EpisodeGuid INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName]) VALUES(@EpisodeGuid,'1138311','TMDB') INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName]) VALUES(@EpisodeGuid,'5387592','TVDB') INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName]) VALUES(@EpisodeGuid,'tt4460418','IMDB') DELETE FROM tblEpisodePersons WHERE guidEpisode = @EpisodeGuid INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Harry Dunning' ,250 ,1 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'George de Mohrenschildt' ,233 ,2 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Christy Epping' ,238 ,3 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Bobby Oswald' ,239 ,4 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Jeanne De Mohrenschildt' ,240 ,5 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Vada Oswald' ,241 ,6 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Kennedy Speech Attendant' ,242 ,7 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Galaxie driver' ,244 ,8 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Doris Dunning' ,255 ,9 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Ellen' ,260 ,10 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Chicken' ,294 ,11 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'School Girl' ,458 ,12 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Kennedy Speech Attendee (uncredited)' ,459 ,13 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Barfly' ,301 ,14 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Yellow Card Man' ,231 ,15 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Marquerite Oswald' ,229 ,16 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Frank Dunning' ,236 ,17 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Johnny Clayton' ,460 ,18 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Executive Producer/Director' ,433 ,1 ,2 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Writer/Teleplay' ,435 ,2 ,2 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Director of Photography' ,456 ,4 ,2 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Editor' ,457 ,6 ,2 ) '
2026-10-21 21:34:39 . 07 - Common.Database.ExecuteReader - 'SELECT nvcPath FROM tblEpisodePersonal WITH (NOLOCK) WHERE nvcPath is not NULL AND guidEpisode IN (SELECT guid FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = '6ecad242-d2eb-4db2-a712-e6513edc6fc2') '
2026-10-21 21:34:39 . 07 - TVDatabase.UpdateSeriePathsByEpisodes - Path '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]\11.22.63 [Season 1 Episode 01].iso'
2026-10-21 21:34:39 . 07 - TVDatabase.SetSeriePaths
2026-10-21 21:34:39 . 08 - Common.Database.ExecuteNonQuery - 'DELETE FROM tblSeriePaths WHERE guidSerie = @SerieGuid INSERT INTO tblSeriePaths([guidSerie],[nvcPath])VALUES(@SerieGuid, '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]') '
2026-10-21 21:34:39 . 08 - TVMetadata.FindAndSetSeriesPath
2026-10-21 21:34:39 . 08 - TVDatabase.GetSeriePaths
2026-10-21 21:34:39 . 08 - Common.Database.ExecuteReader - 'SELECT SP.nvcPath FROM tblSeriePaths SP WHERE SP.guidSerie = '6ecad242-d2eb-4db2-a712-e6513edc6fc2''
2026-10-21 21:34:39 . 08 - TVDatabase.SetSeriesPath - Transaction: 'True'
2026-10-21 21:34:39 . 08 - Common.Database.ExecuteNonQuery - 'UPDATE [tblElementPersonal] SET nvcPath = '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]' WHERE guidElement='6ecad242-d2eb-4db2-a712-e6513edc6fc2' '
2026-10-21 21:34:39 . 09 - Common.QueueElementInfoStorage - Element Id '6585dba5-58ac-4370-b3a4-33d5e48b3648'.
2026-10-21 21:34:39 . 09 - Common.Database.ExecuteReader - 'SELECT guidElement FROM tblTitleInfoStorageQueue WITH (NOLOCK) WHERE nvcType = 'TVEpisode' AND guidElement = '6585dba5-58ac-4370-b3a4-33d5e48b3648''
2026-10-21 21:34:39 . 09 - Common.Database.ExecuteNonQuery - 'INSERT INTO tblTitleInfoStorageQueue (nvcType, intTitle, guidElement) VALUES ('TVEpisode', 0, '6585dba5-58ac-4370-b3a4-33d5e48b3648')'
2026-10-21 21:34:39 . 09 - TVDatabase.GetLocalEpisode episode '6585dba5-58ac-4370-b3a4-33d5e48b3648'
2026-10-21 21:34:39 . 09 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber,EG.intEpisodeNumber,EG.nvcOriginalTitle,EG.nvcProductionCode,EG.intAbsoluteNumber,EG.nvcDVDDiscId,EG.nvcDVDSeason,EG.nvcDVDEpisodeNumber,EG.nvcDVDChapter,EG.decTVDBRating,EG.guidSerie, EG.intAddType, EG.guidAddId,EG.datDataChanged,EG.bitLocked, EG.bitFoundInWebService, EG.bitEdited, EG.bitOnlyLocal, EG.bitOwned ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE L.guid = ELS.guidLanguage) as language,ELS.nvcName, ELS.nvcSortName,ELS.ntxOverview,ELS.datDataChanged, ELS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = ECS.guidCountry) as country,ECS.datFirstAired,ECS.datDataChanged, ECS.bitEdited ,EP.intRating,EP.nvcPath,EP.nvcMobileLocationPrimary,EP.nvcMobileLocationSecondary,EP.bitWatched,EP.datDataChanged,EP.datAdded, EG.[lngProgress], EG.[bitOnlyLocal] FROM tblEpisodeGlobal EG LEFT OUTER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodeCountrySpecific ECS on ECS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodePersonal EP on EP.guidEpisode = EG.[guid] WHERE EG.guid = '6585dba5-58ac-4370-b3a4-33d5e48b3648' ORDER BY ELS.bitAlternative ASC '
2026-10-21 21:34:39 . 10 - Common.Database.ExecuteReader - 'Select [nvcUser] As [User] ,[datDate] As Date ,[bitPriorTo] As Before ,[intState] As State ,[nvcNotes] As Notes ,[nvcHow] As How ,[guidSession] AS Session FROM [tblWatched] WHERE [guid] = '6585dba5-58ac-4370-b3a4-33d5e48b3648' ORDER BY [datDate]'
2026-10-21 21:34:39 . 10 - Common.Database.ExecuteReader - 'SELECT T.nvcLocalTitle, D.nvcLabel FROM tblTitles T INNER JOIN tblDiscs D on D.intTitle = T.intId INNER JOIN tblDiscTitles DT on DT.intDisc = D.intId WHERE DT.guidEpisode = '6585dba5-58ac-4370-b3a4-33d5e48b3648' '
2026-10-21 21:34:39 . 10 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = '6585dba5-58ac-4370-b3a4-33d5e48b3648''
2026-10-21 21:34:39 . 10 - Common.Database.ExecuteReader - 'SELECT EP.intPerson,EP.nvcCharacter,EP.intSort,EP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblEpisodePersons EP INNER JOIN tblPersons P on P.intId = EP.intPerson WHERE EP.guidEpisode = '6585dba5-58ac-4370-b3a4-33d5e48b3648''
2026-10-21 21:34:39 . 11 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[nvcSortName],[ntxOverview],ELS.datDataChanged FROM [My Movies].[dbo].[tblEpisodeGlobal] EG INNER JOIN [tblEpisodeLanguageSpecific] ELS on EG.guid = ELS.guidEpisode WHERE EG.guid = '6585dba5-58ac-4370-b3a4-33d5e48b3648' AND ELS.bitAlternative = 1 '
2026-10-21 21:34:39 . 11 - Common.Database.ExecuteReader - 'SELECT datSynchronized FROM tblDatabase'
2026-10-21 21:34:39 . 11 - TVDatabase.IsEpisodeConnectedToDisc - Transaction: 'True'
2026-10-21 21:34:39 . 11 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN '6585dba5-58ac-4370-b3a4-33d5e48b3648' IN ((SELECT guidEpisode FROM tblDiscTitles) UNION ALL (SELECT guidEpisode FROM tblTitleEpisodes)) THEN 1 ELSE 0 END '
2026-10-21 21:34:39 . 11 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN (SELECT intAddType FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guid = '6585dba5-58ac-4370-b3a4-33d5e48b3648') = 5 THEN 0 ELSE 1 END '
2026-10-21 21:34:39 . 11 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN EXISTS (SELECT guidEpisode FROM tblEpisodePersonal WITH (NOLOCK) WHERE ISNULL(nvcPath, '') <> '') THEN 1 ELSE 0 END '
2026-10-21 21:34:39 . 12 - Common.MediaCenterShared.LoadEpisodePlayOptionsByEpisodeId - ID '6585dba5-58ac-4370-b3a4-33d5e48b3648'
2026-10-21 21:34:39 . 12 - Common.Database.ExecuteReader - 'SELECT TOP 1 nvcName FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = '6585dba5-58ac-4370-b3a4-33d5e48b3648' ORDER BY CASE WHEN nvcName IS NULL THEN 0 ELSE 1 END DESC, bitAlternative ASC'
2026-10-21 21:34:39 . 12 - Common.Database.ExecuteReader - 'SELECT nvcPath FROM tblEpisodePersonal WITH (NOLOCK) WHERE guidEpisode = '6585dba5-58ac-4370-b3a4-33d5e48b3648' AND ISNULL(nvcPath, '') <> '''
2026-10-21 21:34:39 . 12 - Common.MediaCenterShared.LoadEpisodePlayOptionsByEpisodeId - TV Episode path detected.
2026-10-21 21:34:39 . 12 - Common.MediaPlayers.GetEpisodePlayPath - Location is a file. Checking the type of media in it.
2026-10-21 21:34:39 . 12 - Common.MediaPlayers.GetEpisodePlayPath - Title is an image file. Trying to determine type.
2026-10-21 21:34:39 . 12 - Common.MediaPlayers.GetTitlePlayPaths - MediaInfo not found for item.
2026-10-21 21:34:39 . 13 - Common.MediaPlayers.GetEpisodePlayPath - ImageType not found as part of MediaInfo. Trying to determine.
2026-10-21 21:34:41 . 27 - Common.MediaPlayers.GetEpisodePlayPath - Files extracted to 'C:\ProgramData\My Movies\Temp\162884b7-cebe-42a8-98cc-c0b8ad0976d3'.
2026-10-21 21:34:41 . 27 - Common.MediaPlayers.GetEpisodePlayPath - A index.bdmv file existed, the ISO is a Blu-ray.
2026-10-21 21:34:41 . 27 - Common.MediaPlayers.GetEpisodePlayPath - Determining location for path '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\11.22.63\11.22.63 [Season 1]\11.22.63 [Season 1 Episode 01].iso'
2026-10-21 21:34:41 . 27 - Common.MediaPlayers.GetEpisodePlayPath - Location: \\server\Multimedia Library
2026-10-21 21:34:41 . 28 - Common.Database.ExecuteReader - 'SELECT nvcValue FROM tblConfiguration WITH (NOLOCK) WHERE nvcType = 'Server' AND nvcPath = 'ExternalCredentials' AND nvcName = 'UserName-server''
2026-10-21 21:34:41 . 28 - Common.Database.ExecuteReader - 'SELECT nvcValue FROM tblConfiguration WITH (NOLOCK) WHERE nvcType = 'Server' AND nvcPath = 'ExternalCredentials' AND nvcName = 'Password-server''
2026-10-21 21:34:41 . 29 - Common.OnlineService.Calls.ChangeEpisodePersonalData - Calling 'ChangeTVEpisodeInCollectionExtended', attempt 1 of 3.
2026-10-21 21:34:42 . 43 - Common.OnlineService.Calls.ChangeEpisodePersonalData - Calling 'ChangeTVEpisodeInCollectionExtended', attempt 2 of 3.
2026-10-21 21:34:42 . 99 - Common.OnlineService.Calls.ChangeEpisodePersonalData - Calling 'ChangeTVEpisodeInCollectionExtended', attempt 3 of 3.
2026-10-21 21:34:43 . 54 - Common.OnlineService.Calls.ChangeEpisodePersonalData - The online service did not respond.
2026-10-21 21:34:43 . 54 - Common.OnlineService.Calls.ChangeEpisodePersonalData - Returning False.
2026-10-21 21:34:43 . 54 - TVMetadata.InsertSerie - Error! The tv episode could not be updated in the online service 'The online service could not be contacted'
2026-10-21 21:34:43 . 55 - TVMetadata.UpdateEpisode - Close objConn
2026-10-21 21:34:43 . 55 - TVEpisodeControl.btnAddEpisode_Click - update didn't succeed.
2026-10-21 21:34:43 . 59 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:34:43 . 59 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:34:43 . 59 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:34:50 . 95 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:34:58 . 59 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:34:58 . 59 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:34:58 . 59 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:35:03 . 00 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:35:13 . 59 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:35:13 . 59 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:35:13 . 59 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:35:15 . 05 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:35:27 . 09 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:35:28 . 61 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:35:28 . 61 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:35:28 . 61 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:35:39 . 12 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:35:43 . 62 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:35:43 . 62 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:35:43 . 62 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:35:51 . 15 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:35:58 . 62 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:35:58 . 62 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:35:58 . 62 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:36:03 . 21 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:36:13 . 64 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:36:13 . 64 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:36:13 . 64 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:36:15 . 25 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:36:27 . 30 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:36:28 . 65 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:36:28 . 65 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:36:28 . 65 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 21:36:37 . 56 - Common.Database.ExecuteReader - '(SELECT 'TVSerie' As nvcType, 0 AS intId, SG.guid As nvcWebServiceId ,(SELECT TOP 1 nvcName FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid ORDER BY CASE WHEN nvcName is null then 0 else 1 end desc, bitAlternative ASC) As nvcTitle , (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = SG.guid) AS intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete , (SELECT TOP 1 nvcName FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid ORDER BY CASE WHEN nvcName is null then 0 else 1 end desc, bitAlternative ASC) As nvcSortTitle , SG.bitPersonal, (SELECT COUNT(guid) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = SG.guid) AS intSubItems, 1 as bitDataDownloaded , 1 as bitFileSet, -1 as intSeasonNumber, -1 as intEpisodeNumber, SG.bitFoundInWebService, 1 as bolOnDisc, 0 As bitWorksAsTVSeries , (SELECT CASE WHEN '00000000-0000-0000-0000-000000000000' IN (SELECT guidLanguage FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid) THEN 1 ELSE 0 END) as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'TVSeries' as discType , NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblSeriesGlobal SG WITH (NOLOCK) INNER JOIN tblTitles T on T.nvcTVWebServiceId = CAST(SG.guid AS NVARCHAR(MAX)) WHERE T.intId = 1) UNION ALL (SELECT 'DiscTitle' As nvcType, intId, CASE WHEN nvcWebServiceId = '' THEN NULL ELSE nvcWebServiceId END , ISNULL(tblTitlePersonal.nvcTitle, tblTitles.nvcLocalTitle) As nvcTitle , tblTitlePersonal.intCollectionNumber, nvcDataProvider, nvcUPC, intComplete , ISNULL(tblTitlePersonal.nvcSortTitle, tblTitles.nvcSortTitle) As nvcSortTitle, tblTitles.bitPersonal , (SELECT COUNT(intTitleSerie) FROM tblTitleSeries WITH (NOLOCK) WHERE intTitle = tblTitles.intId) As intSubItems , 1 as bitDataDownloaded, 1 as bitFileSet, 0 As intSeasonNumber, 0 As intEpisodeNumber, 1 As bitFoundInWebService, 0 as bolOnDisc, bitWorksAsTVSeries, 0 as bitErroneous , bitMovieConnected, guidMovie , (SELECT nvcName FROM tblTypes WITH (NOLOCK) WHERE intId = tblTitles.intType) as discType , nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblTitles WITH (NOLOCK), tblTitlePersonal WITH (NOLOCK) WHERE tblTitlePersonal.intTitle = tblTitles.intId AND tblTitles.intId IN (SELECT intTitleSerie FROM tblTitleSeries WITH (NOLOCK) WHERE intTitle = 1))'
2026-10-21 21:36:37 . 57 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:36:38 . 54 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:36:38 . 58 - CollectionManagement.ChangeSelectedTitle - Row found
2026-10-21 21:36:38 . 66 - CollectionManagement.TVSerieControl.LoadSerieData
2026-10-21 21:36:38 . 66 - TVDatabase.GetLocalSerie - serie 'd8167137-fb5f-4357-a57c-c33f8b32a3d6'
2026-10-21 21:36:38 . 66 - TVDatabase.GetLocalSerie - Open objConn
2026-10-21 21:36:38 . 66 - Common.Database.ExecuteReader - 'SELECT [intOriginalRunningTime],(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = [guidOriginalCountry]) as originalCountry,nvcOriginalTitle,[intDiscRunningTime],[nvcOriginalNetwork],[decRating], (SELECT S.nvcName FROM tblTVStatus S WITH (NOLOCK) WHERE S.guid = [guidOriginalStatus]) as OriginalStatus,SG.[datFirstAired],[timOriginalAirTime], SG.intAddType, SG.guidAddId, SG.datDataChanged, SG.bitLocked, SG.bitFoundInWebService, SG.bitEdited, SG.bitOnlyLocal , (SELECT COUNT(*) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = SG.guid) as intEpisodes ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[ntxOverview],[nvcSortName],nvcYouTubeTrailerId, SLS.datDataChanged, SLS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = [guidCountry]) as country,[nvcNetwork],(SELECT S.nvcName FROM tblTVStatus S WITH (NOLOCK) WHERE S.guid = [guidStatus]) as status, SCS.[datFirstAired],[intAirDay],[timAirTime],[intRunningTime],[intParentalRating], SCS.datDataChanged, SCS.bitEdited , EP.[intGroup], EP.[intRating], EP.[intCollectionNumber], EP.[datDataChanged] , EP.[datAdded] , EP.[guidElementType] , (SELECT [nvcName] FROM tblElementTypes WITH (NOLOCK) WHERE guid = EP.[guidElementType]) as elementName , EP.[nvcTitle] , EP.[nvcSortTitle] , EP.[nvcNotes] , EP.[nvcTags] , EP.[bitExcludeOnlineCollection] , EP.[bitExcludeMobileSoftware] , EP.[bitInvisibleToFriends] , EP.[nvcLocalTrailer] , SG.[bitOnlyLocal] FROM [My Movies].[dbo].[tblSeriesGlobal] SG LEFT OUTER JOIN [tblSeriesLanguageSpecific] SLS on SG.guid = SLS.guidSeries LEFT OUTER JOIN [tblSeriesCountrySpecific] SCS on SG.guid = SCS.guidSeries LEFT OUTER JOIN [tblElementPersonal] EP on SG.guid = EP.guidElement WHERE SG.guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY SLS.bitAlternative ASC, SCS.bitAlternative ASC '
2026-10-21 21:36:38 . 71 - TVDatabase.GetLocalSerie - Getting Serie Paths
2026-10-21 21:36:38 . 71 - TVDatabase.GetSeriePaths
2026-10-21 21:36:38 . 71 - Common.Database.ExecuteReader - 'SELECT SP.nvcPath FROM tblSeriePaths SP WHERE SP.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:38 . 71 - Common.Database.ExecuteReader - 'SELECT SG.intGenre FROM tblSerieGenres SG WHERE SG.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:38 . 71 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:38 . 72 - Common.Database.ExecuteReader - 'SELECT SP.intId,SP.nvcRole,SP.nvcImage,SP.intImageWidth,SP.intImageHeight,SP.intSort,SP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblSeriePersons SP INNER JOIN tblPersons P on P.intId = SP.intId WHERE SP.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:38 . 73 - Common.Database.ExecuteReader - 'SELECT [intCategory] FROM tblSerieCategory WHERE [guidSerie] = @SerieGuid '
2026-10-21 21:36:38 . 74 - Common.Database.ExecuteReader - 'SELECT DISTINCT [intSeasonNumber] FROM tblEpisodeGlobal WHERE [guidSerie] = @SerieGuid  AND bitOwned = 1 '
2026-10-21 21:36:38 . 74 - Common.Database.ExecuteReader - 'SELECT DISTINCT [intSeasonNumber] FROM tblEpisodeGlobal WHERE [guidSerie] = @SerieGuid '
2026-10-21 21:36:38 . 74 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[ntxOverview],[nvcSortName], nvcYouTubeTrailerId, SLS.datDataChanged FROM [My Movies].[dbo].[tblSeriesGlobal] SG INNER JOIN [tblSeriesLanguageSpecific] SLS on SG.guid = SLS.guidSeries WHERE SG.guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' AND SLS.bitAlternative = 1 '
2026-10-21 21:36:38 . 75 - Common.Database.ExecuteReader - 'SELECT (SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = [guidCountry]) as country,[nvcNetwork],(SELECT S.nvcName FROM tblTVStatus S WITH (NOLOCK) WHERE S.guid = [guidStatus]) as status, SCS.[datFirstAired],[intAirDay],[timAirTime],[intRunningTime],[intParentalRating],SCS.datDataChanged FROM [My Movies].[dbo].[tblSeriesGlobal] SG INNER JOIN [tblSeriesCountrySpecific] SCS on SG.guid = SCS.guidSeries WHERE SG.guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' AND SCS.bitAlternative = 1 '
2026-10-21 21:36:38 . 77 - TVDatabase.GetAllSerieGuids - Close objConn
2026-10-21 21:36:38 . 80 - PopulateCmbParentalRating - Done adding TV only
2026-10-21 21:36:38 . 81 - CollectionManagement.TVSerieControl.LoadSerieData - Setting Sort Name to Standard 'Tulsa King', setting box black
2026-10-21 21:36:38 . 81 - CollectionManagement.TVSerieControl.txtSortTitle_TextChanged - Sort Title is Nothing, setting box black.
2026-10-21 21:36:38 . 84 - Common.GetImageFromDatabase - 'TVBanners\d8167137-fb5f-4357-a57c-c33f8b32a3d6_new.jpg'
2026-10-21 21:36:38 . 84 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:36:38 . 84 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVBanners\d8167137-fb5f-4357-a57c-c33f8b32a3d6_new.jpg''
2026-10-21 21:36:38 . 85 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:36:38 . 85 - Common.GetImageFromDatabase - 'TVBanners\d8167137-fb5f-4357-a57c-c33f8b32a3d6.jpg'
2026-10-21 21:36:38 . 85 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:36:38 . 85 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVBanners\d8167137-fb5f-4357-a57c-c33f8b32a3d6.jpg''
2026-10-21 21:36:38 . 86 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:36:38 . 87 - Common.GetImageFromDatabase - 'TVBackdrops\d8167137-fb5f-4357-a57c-c33f8b32a3d6_new.jpg'
2026-10-21 21:36:38 . 87 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:36:38 . 87 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVBackdrops\d8167137-fb5f-4357-a57c-c33f8b32a3d6_new.jpg''
2026-10-21 21:36:38 . 87 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:36:38 . 88 - Common.GetImageFromDatabase - 'TVBackdrops\d8167137-fb5f-4357-a57c-c33f8b32a3d6.jpg'
2026-10-21 21:36:38 . 88 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:36:38 . 88 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVBackdrops\d8167137-fb5f-4357-a57c-c33f8b32a3d6.jpg''
2026-10-21 21:36:38 . 90 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:36:38 . 90 - Common.GetImageFromDatabase - 'TVPosters\d8167137-fb5f-4357-a57c-c33f8b32a3d6_new.jpg'
2026-10-21 21:36:38 . 90 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:36:38 . 90 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVPosters\d8167137-fb5f-4357-a57c-c33f8b32a3d6_new.jpg''
2026-10-21 21:36:38 . 91 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:36:38 . 91 - Common.GetImageFromDatabase - 'TVPosters\d8167137-fb5f-4357-a57c-c33f8b32a3d6.jpg'
2026-10-21 21:36:38 . 91 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:36:38 . 91 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVPosters\d8167137-fb5f-4357-a57c-c33f8b32a3d6.jpg''
2026-10-21 21:36:38 . 93 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:36:38 . 99 - Common.Database.ExecuteReader - 'SELECT nvcName FROM tblCountries ORDER BY nvcName'
2026-10-21 20:36:39 . 34 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:36:39 . 52 - TVDatabase.EnsureWebServiceHandShake
2026-10-21 21:36:40 . 59 - TVService - Calling 'GetSeriesCompletePercentage'
2026-10-21 21:36:40 . 92 - TVService - Returned
2026-10-21 21:36:40 . 92 - CollectionManagement.TVSerieControl.LoadSerieData - Reverting First Load.
2026-10-21 21:36:40 . 94 - DiscTitleControl.LoadDisc
2026-10-21 21:36:40 . 96 - DiscTitleControl.CheckCompleteAgainstServer
2026-10-21 21:36:40 . 96 - DiscTitleControl.CheckCompleteAgainstServer - end
2026-10-21 21:36:40 . 96 - CollectionManagement.ChangeSelectedTitle - END
2026-10-21 21:36:40 . 97 - Common.Database.ExecuteReader - 'SELECT 'TVSeason' As nvcType, intSeasonNumber AS intId, guidSerie As nvcWebServiceId, ('Season ' + CAST(intSeasonNumber AS NVARCHAR(255))) As nvcTitle, -1 As intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete, ('Season ' + CAST(intSeasonNumber AS NVARCHAR(255))) As nvcSortTitle, 0 As bitPersonal, 1 AS intSubItems , (CASE WHEN (SELECT COUNT(*) FROM tblEpisodeGlobal EG WITH (NOLOCK) WHERE EG.intSeasonNumber = tblEpisodeGlobal.intSeasonNumber AND tblEpisodeGlobal.guidSerie = EG.guidSerie and EG.bitOwned = 1) > 0 THEN 1 ELSE 0 END) as bitDataDownloaded , 1 as bitFileSet, intSeasonNumber, intEpisodeNumber, (CASE WHEN (SELECT COUNT(*) FROM tblEpisodeGlobal EG WITH (NOLOCK) WHERE EG.intSeasonNumber = tblEpisodeGlobal.intSeasonNumber AND tblEpisodeGlobal.guidSerie = EG.guidSerie and EG.bitFoundInWebService = 1) > 0 THEN 1 ELSE 0 END) as bitFoundInWebService , 0 as bolOnDisc, 0 As bitWorksAsTVSeries, 0 as bitErroneous, 0 as bitMovieConnected, NULL as guidMovie, 'TVSeason' as discType, NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guid IN (SELECT DISTINCT (SELECT TOP 1 guid FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' AND intSeasonNumber = tblEpisodeGlobal1.intSeasonNumber AND bitOwned = 1 AND (guid IN (SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) INNER JOIN tblDiscs D WITH (NOLOCK) on D.intId = DT.intDisc WHERE DT.guidEpisode is not NULL AND D.intTitle = 1 ) OR guid IN (SELECT guidEpisode FROM tblTitleEpisodes WITH (NOLOCK) WHERE intTitle = 1 ))  ORDER BY intEpisodeNumber) As guid FROM tblEpisodeGlobal tblEpisodeGlobal1 WITH (NOLOCK) WHERE tblEpisodeGlobal1.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6') ORDER BY intSeasonNumber'
2026-10-21 21:36:40 . 99 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:36:41 . 07 - DiscTitleControl.CheckCompleteAgainstServer - DoWork running
2026-10-21 21:36:41 . 07 - Common.Database.ExecuteScalar - 'SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE intId = (SELECT intCountry FROM tblTitles WITH (NOLOCK) WHERE intId = 2)'
2026-10-21 21:36:41 . 07 - DiscTitleControl.CheckCompleteAgainstServer - WebService Id '4bd7501b-a936-415e-96eb-d55bb5abf834'
2026-10-21 21:36:41 . 16 - Common.OnlineService.Calls.LoadDiscTitleInformation - Calling 'LoadDiscTitleInformation', attempt 1 of 3.
2026-10-21 21:36:41 . 16 - Common.OnlineService.Calls.HandShake - Calling 'CreateHandShake', attempt 1 of 3.
2026-10-21 21:36:41 . 78 - Common.OnlineService.Calls.HandShake - Called.
2026-10-21 21:36:41 . 78 - Common.OnlineService.Calls.HandShake - Returning Handshake.
2026-10-21 21:36:41 . 99 - Common.Database.ExecuteReader - 'SELECT 'TVEpisode' As nvcType, 0 AS intId, guid As nvcWebServiceId , ISNULL(ISNULL((SELECT TOP 1 NULLIF(nvcName, '') FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid  ORDER BY CASE WHEN nvcName IS NULL THEN 0 ELSE 1 END DESC, bitAlternative ASC), nvcOriginalTitle), 'Episode ' + CAST(intEpisodeNumber AS NVARCHAR(MAX))) As nvcTitle , -1 As intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete , (SELECT TOP 1 nvcName FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid) As nvcSortTitle , 0 As bitPersonal, 0 AS intSubItems , bitOwned as bitDataDownloaded , (CASE WHEN (SELECT COUNT(*) FROM tblEpisodePersonal EP WITH (NOLOCK) WHERE EP.guidEpisode = tblEpisodeGlobal.guid and EP.nvcPath is not null) > 0 THEN 1 ELSE 0 END) as bitFileSet, intSeasonNumber, intEpisodeNumber, bitFoundInWebService , (CASE WHEN (guid IN ((SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) WHERE DT.guidEpisode IS NOT NULL) UNION ALL (SELECT ET.guidEpisode FROM tblTitleEpisodes ET WITH (NOLOCK) WHERE ET.guidEpisode IS NOT NULL))) THEN 1 ELSE 0 END) as bolOnDisc, 0 As bitWorksAsTVSeries, 0 as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'TVEpisode' as discType, NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, CASE WHEN ISNULL((SELECT TOP 1 NULLIF(nvcName, '') FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid  ORDER BY CASE WHEN nvcName IS NULL THEN 0 ELSE 1 END DESC, bitAlternative ASC), nvcOriginalTitle) IS NULL THEN 0 ELSE 1 END As bitContainsTitle FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' AND intSeasonNumber = '1' AND bitOwned = 1 AND (guid IN (SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) INNER JOIN tblDiscs D WITH (NOLOCK) on D.intId = DT.intDisc WHERE DT.guidEpisode is not NULL AND D.intTitle = 1) OR guid IN (SELECT guidEpisode FROM tblTitleEpisodes WITH (NOLOCK) WHERE intTitle = 1))  ORDER BY intEpisodeNumber'
2026-10-21 21:36:42 . 02 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:36:42 . 11 - Common.OnlineService.Calls.LoadDiscTitleInformation - Returning retrieved node.
2026-10-21 21:36:42 . 11 - DiscTitleControl.CheckCompleteAgainstServer - DoWork end
2026-10-21 21:36:42 . 11 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted running
2026-10-21 21:36:42 . 11 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted done
2026-10-21 21:36:43 . 67 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:36:43 . 68 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:36:43 . 68 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 21:36:43 . 98 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:36:44 . 01 - CollectionManagement.TVSerieControl - Parental Rating Changed
2026-10-21 21:36:47 . 68 - CollectionManagement.TVSerieControl.btnAddSerie_Click
2026-10-21 21:36:48 . 05 - CollectionManagement.TVSerieControl.btnAddSerie_Click - 3
2026-10-21 21:36:48 . 10 - TVDatabase.UpdateSerie - ID 'd8167137-fb5f-4357-a57c-c33f8b32a3d6', Register Change 'True'
2026-10-21 21:36:48 . 10 - TVDatabase.UpdateSerie - Open objConn
2026-10-21 21:36:48 . 11 - TVDatabase.LookupCountryGrid - Country Name 'United States', Transaction: 'True'
2026-10-21 21:36:48 . 11 - TVDatabase.LookupCountryGrid - Returning 'True' from cache
2026-10-21 21:36:48 . 11 - TVDatabase.LookupStatusGuid - Transaction: 'True'
2026-10-21 21:36:48 . 11 - Language Inserted:
2026-10-21 21:36:48 . 11 - English
2026-10-21 21:36:48 . 11 - TVDatabase.LookupLanguageGuidFromLanguage - Language 'English' - Transaction: 'True'
2026-10-21 21:36:48 . 11 - TVDatabase.UpdateSerie - Country 'United States'
2026-10-21 21:36:48 . 11 - TVDatabase.LookupCountryGrid - Country Name 'United States', Transaction: 'True'
2026-10-21 21:36:48 . 12 - TVDatabase.LookupCountryGrid - Returning 'True' from cache
2026-10-21 21:36:48 . 12 - TVDatabase.LookupStatusGuid - Transaction: 'True'
2026-10-21 21:36:48 . 12 - TVDatabase.UpdateSerie - Alternative Country 'Neutral'
2026-10-21 21:36:48 . 12 - TVDatabase.LookupCountryGrid - Country Name 'Neutral', Transaction: 'True'
2026-10-21 21:36:48 . 12 - TVDatabase.LookupCountryGrid - Returning 'True' from cache
2026-10-21 21:36:48 . 12 - TVDatabase.LookupStatusGuid - Transaction: 'True'
2026-10-21 21:36:48 . 12 - Common.Database.ExecuteNonQuery - 'UPDATE tblSeriesGlobal SET [guidOriginalCountry] = @guidOriginalCountry ,[nvcOriginalTitle] = @OriginalTitle ,[intOriginalRunningTime] = @OriginalRunningTime ,[intDiscRunningTime] = @DiscRunningTime ,[nvcOriginalNetwork] = @OriginalNetwork ,[decRating] = @Rating ,[guidOriginalStatus] =  @OriginalStatusGuid ,[datFirstAired] = @FirstAired ,[timOriginalAirTime] = @OriginalAirTime ,[intAddType] = @intAddType ,[guidAddId] = @guidAddId ,[datDataChanged] = @globalDataChanged ,[bitEdited] = @IsEdited WHERE guid = @SerieGuid DELETE FROM tblSeriesLanguageSpecific WHERE [guidSeries] = @SerieGuid INSERT INTO tblSeriesLanguageSpecific([guidSeries], [guidLanguage], [nvcName], [ntxOverview], [nvcSortName],[nvcYouTubeTrailerId],[datDataChanged],[bitAlternative],[bitEdited])VALUES(@SerieGuid, @LanguageGuid, @Name, @Description, @SortName, @YouTubeTrailerId, @dataChanged, 1, @LanguageEdited) DELETE FROM tblSeriesCountrySpecific WHERE [guidSeries] = @SerieGuid and bitAlternative = 0 DELETE FROM tblSeriesCountrySpecific WHERE [guidSeries] = @SerieGuid and bitAlternative = @CountryBitAlternative INSERT INTO tblSeriesCountrySpecific([guidSeries], [guidCountry], [nvcNetwork], [guidStatus], [datFirstAired], [intAirDay], [timAirTime], [intRunningTime], [intParentalRating], [bitAlternative],[datDataChanged],[bitEdited])VALUES(@SerieGuid, @CountryGuid, @CountryNetwork, @CountryStatusGuid, @CountryFirstAired, @CountryAirDay, @CountryAirTime, @CountryRunningTime, @CountryParentalRating, @CountryBitAlternative, @CountryDataChanged,@CountryEdited) DELETE FROM tblSeriesCountrySpecific WHERE [guidSeries] = @SerieGuid and bitAlternative = @NeutralCountryBitAlternative INSERT INTO tblSeriesCountrySpecific([guidSeries], [guidCountry], [nvcNetwork], [guidStatus], [datFirstAired], [intAirDay], [timAirTime], [intRunningTime], [intParentalRating], [bitAlternative],[datDataChanged])VALUES(@SerieGuid, @NeutralCountryGuid, @NeutralCountryNetwork, @NeutralCountryStatusGuid, @NeutralCountryFirstAired, @NeutralCountryAirDay, @NeutralCountryAirTime, @NeutralCountryRunningTime, @NeutralCountryParentalRating, @NeutralCountryBitAlternative, @NeutralCountryDataChanged) UPDATE tblElementPersonal SET [intRating] = @OwnRating , [intCollectionNumber] = @CollectionNumber , [datDataChanged] = @datPersonalDataChanged , [guidElementType] = @guidElementType , [bitExcludeOnlineCollection] = @bitExcludeOnlineCollection , [bitExcludeMobileSoftware] = @bitExcludeMobileSoftware , [bitInvisibleToFriends] = @bitInvisibleToFriends , [nvcTitle] = @nvcTitle , [nvcSortTitle] = @nvcSortTitle , [nvcNotes] = @nvcNotes , [nvcTags] = @nvcTags , [nvcLocalTrailer] = @nvcLocalTrailer , [intGroup] = @intGroup , [datAdded] = @datAdded  WHERE [guidElement] = @SerieGuid DELETE FROM tblSerieCategory WHERE guidSerie = @SerieGuid DELETE FROM tblSeriePaths WHERE guidSerie = @SerieGuid DELETE FROM tblSerieGenres WHERE guidSerie = @SerieGuid INSERT INTO tblSerieGenres([guidSerie],[intGenre])VALUES(@SerieGuid, 10) INSERT INTO tblSerieGenres([guidSerie],[intGenre])VALUES(@SerieGuid, 12) DELETE FROM tblRemoteIDs WHERE guidItem = @SerieGuid INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName])VALUES(@SerieGuid,'tt16358384','IMDB') INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName])VALUES(@SerieGuid,'413215','TVDB') INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName])VALUES(@SerieGuid,'153312','TMDB') INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName])VALUES(@SerieGuid,'TulsaKingTV','Facebook') INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName])VALUES(@SerieGuid,'tulsaking','Instagram') INSERT INTO tblRemoteIDs([guidItem],[nvcRemoteId],[nvcRemoteName])VALUES(@SerieGuid,'TulsaKing','Twitter') DELETE FROM tblSeriePersons WHERE guidSerie = @SerieGuid INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,1 ,N'Dwight ''The General'' Manfredi' ,'',0 ,0 ,1 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,3 ,N'Lawrence ''Bodhi'' Geigerman' ,'',0 ,0 ,2 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,4 ,N'Tyson Mitchell' ,'',0 ,0 ,3 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,26 ,N'Joanne' ,'',0 ,0 ,4 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,7 ,N'Vince Antonacci' ,'',0 ,0 ,4 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,5 ,N'Armand Truisi' ,'',0 ,0 ,4 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,11 ,N'Goodie Carangi' ,'',0 ,0 ,5 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,16 ,N'Grace' ,'',0 ,0 ,6 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,8 ,N'Pete ''The Rock'' Invernizzi' ,'',0 ,0 ,6 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,190 ,N'Bigfoot' ,'',0 ,0 ,7 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,9 ,N'Mitch Keller' ,'',0 ,0 ,7 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,15 ,N'Tina' ,'',0 ,0 ,7 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,195 ,N'Bill Bevilaqua' ,'',0 ,0 ,8 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,10 ,N'Margaret Devereaux' ,'',0 ,0 ,8 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,191 ,N'Jeremiah Dunmire' ,'',0 ,0 ,8 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,6 ,N'Charles ''Chickie'' Invernizzi' ,'',0 ,0 ,9 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,198 ,N'Cal Thresher' ,'',0 ,0 ,9 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,201 ,N'Cole Dunmire' ,'',0 ,0 ,9 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,205 ,N'Quiet Ray Renzetti' ,'',0 ,0 ,10 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,202 ,N'Special Agent Musso' ,'',0 ,0 ,10 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,2 ,N'Stacy Beale' ,'',0 ,0 ,10 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,210 ,N'Cleo Montague' ,'',0 ,0 ,12 ,1 ) INSERT INTO tblSeriePersons([guidSerie],[intId],[nvcRole],[nvcImage],[intImageWidth],[intImageHeight],[intSort],[intType])VALUES(@SerieGuid ,217 ,N'Amanda Clark' ,'',0 ,0 ,15 ,1 ) '
2026-10-21 21:36:48 . 25 - Common.QueueElementInfoStorage - Element Id 'd8167137-fb5f-4357-a57c-c33f8b32a3d6'.
2026-10-21 21:36:48 . 26 - Common.Database.ExecuteReader - 'SELECT guidElement FROM tblTitleInfoStorageQueue WITH (NOLOCK) WHERE nvcType = 'TVSeries' AND guidElement = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:48 . 26 - Common.Database.ExecuteNonQuery - 'INSERT INTO tblTitleInfoStorageQueue (nvcType, intTitle, guidElement) VALUES ('TVSeries', 0, 'd8167137-fb5f-4357-a57c-c33f8b32a3d6')'
2026-10-21 21:36:48 . 27 - TVDatabase.GetLocalSerie - serie 'd8167137-fb5f-4357-a57c-c33f8b32a3d6'
2026-10-21 21:36:48 . 28 - Common.Database.ExecuteReader - 'SELECT [intOriginalRunningTime],(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = [guidOriginalCountry]) as originalCountry,nvcOriginalTitle,[intDiscRunningTime],[nvcOriginalNetwork],[decRating], (SELECT S.nvcName FROM tblTVStatus S WITH (NOLOCK) WHERE S.guid = [guidOriginalStatus]) as OriginalStatus,SG.[datFirstAired],[timOriginalAirTime], SG.intAddType, SG.guidAddId, SG.datDataChanged, SG.bitLocked, SG.bitFoundInWebService, SG.bitEdited, SG.bitOnlyLocal , (SELECT COUNT(*) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = SG.guid) as intEpisodes ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[ntxOverview],[nvcSortName],nvcYouTubeTrailerId, SLS.datDataChanged, SLS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = [guidCountry]) as country,[nvcNetwork],(SELECT S.nvcName FROM tblTVStatus S WITH (NOLOCK) WHERE S.guid = [guidStatus]) as status, SCS.[datFirstAired],[intAirDay],[timAirTime],[intRunningTime],[intParentalRating], SCS.datDataChanged, SCS.bitEdited , EP.[intGroup], EP.[intRating], EP.[intCollectionNumber], EP.[datDataChanged] , EP.[datAdded] , EP.[guidElementType] , (SELECT [nvcName] FROM tblElementTypes WITH (NOLOCK) WHERE guid = EP.[guidElementType]) as elementName , EP.[nvcTitle] , EP.[nvcSortTitle] , EP.[nvcNotes] , EP.[nvcTags] , EP.[bitExcludeOnlineCollection] , EP.[bitExcludeMobileSoftware] , EP.[bitInvisibleToFriends] , EP.[nvcLocalTrailer] , SG.[bitOnlyLocal] FROM [My Movies].[dbo].[tblSeriesGlobal] SG LEFT OUTER JOIN [tblSeriesLanguageSpecific] SLS on SG.guid = SLS.guidSeries LEFT OUTER JOIN [tblSeriesCountrySpecific] SCS on SG.guid = SCS.guidSeries LEFT OUTER JOIN [tblElementPersonal] EP on SG.guid = EP.guidElement WHERE SG.guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY SLS.bitAlternative ASC, SCS.bitAlternative ASC '
2026-10-21 21:36:48 . 28 - TVDatabase.GetLocalSerie - Getting Serie Paths
2026-10-21 21:36:48 . 28 - TVDatabase.GetSeriePaths
2026-10-21 21:36:48 . 28 - Common.Database.ExecuteReader - 'SELECT SP.nvcPath FROM tblSeriePaths SP WHERE SP.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:48 . 28 - Common.Database.ExecuteReader - 'SELECT SG.intGenre FROM tblSerieGenres SG WHERE SG.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:48 . 28 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:48 . 29 - Common.Database.ExecuteReader - 'SELECT SP.intId,SP.nvcRole,SP.nvcImage,SP.intImageWidth,SP.intImageHeight,SP.intSort,SP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblSeriePersons SP INNER JOIN tblPersons P on P.intId = SP.intId WHERE SP.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:36:48 . 29 - Common.Database.ExecuteReader - 'SELECT [intCategory] FROM tblSerieCategory WHERE [guidSerie] = @SerieGuid '
2026-10-21 21:36:48 . 29 - Common.Database.ExecuteReader - 'SELECT DISTINCT [intSeasonNumber] FROM tblEpisodeGlobal WHERE [guidSerie] = @SerieGuid  AND bitOwned = 1 '
2026-10-21 21:36:48 . 29 - Common.Database.ExecuteReader - 'SELECT DISTINCT [intSeasonNumber] FROM tblEpisodeGlobal WHERE [guidSerie] = @SerieGuid '
2026-10-21 21:36:48 . 30 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[ntxOverview],[nvcSortName], nvcYouTubeTrailerId, SLS.datDataChanged FROM [My Movies].[dbo].[tblSeriesGlobal] SG INNER JOIN [tblSeriesLanguageSpecific] SLS on SG.guid = SLS.guidSeries WHERE SG.guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' AND SLS.bitAlternative = 1 '
2026-10-21 21:36:48 . 30 - Common.Database.ExecuteReader - 'SELECT (SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = [guidCountry]) as country,[nvcNetwork],(SELECT S.nvcName FROM tblTVStatus S WITH (NOLOCK) WHERE S.guid = [guidStatus]) as status, SCS.[datFirstAired],[intAirDay],[timAirTime],[intRunningTime],[intParentalRating],SCS.datDataChanged FROM [My Movies].[dbo].[tblSeriesGlobal] SG INNER JOIN [tblSeriesCountrySpecific] SCS on SG.guid = SCS.guidSeries WHERE SG.guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' AND SCS.bitAlternative = 1 '
2026-10-21 21:36:48 . 30 - Common.Database.ExecuteReader - 'SELECT datSynchronized FROM tblDatabase'
2026-10-21 21:36:48 . 31 - TVDatabase.GetGroupName - Transaction: 'True'
2026-10-21 21:36:48 . 31 - Common.Database.ExecuteScalar - 'SELECT nvcName FROM tblGroups WITH (NOLOCK) WHERE intId = 1'
2026-10-21 21:36:48 . 32 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' IN (SELECT nvcTVWebServiceId FROM tblTitles WITH (NOLOCK)  WHERE nvcTVWebServiceId IS NOT NULL AND bitWorksAsTVSeries = 1) THEN 1 ELSE 0 END '
2026-10-21 21:36:48 . 34 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN (SELECT intAddType FROM tblSeriesGlobal WITH (NOLOCK) WHERE guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6') = 5 THEN 0 ELSE 1 END '
2026-10-21 21:36:48 . 34 - TVDatabase.IsSeriesOnline
2026-10-21 21:36:48 . 35 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN EXISTS (SELECT nvcPath FROM tblSeriePaths WITH (NOLOCK) WHERE guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6') THEN 1 ELSE 0 END '
2026-10-21 21:36:48 . 35 - Common.OnlineService.Calls.ChangeTVSeriesPersonalData - Calling 'ChangeTVSeriesInCollectionExtendedV2', attempt 1 of 3.
2026-10-21 21:36:48 . 68 - <Response PersonalDataChanged="10/21/2026 6:31:49 AM" status="ok" xmlns="" />
2026-10-21 21:36:48 . 68 - Common.Database.ExecuteNonQuery - 'UPDATE tblElementPersonal SET datDataChanged = @datDataChanged WHERE guidElement = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' '
2026-10-21 21:36:48 . 69 - TVDatabase.UpdateSerie - Close objConn
2026-10-21 21:36:48 . 69 - TVDatabase.EnsureWebServiceHandShake
2026-10-21 21:36:49 . 01 - TVService - Calling 'GetSeriesCompletePercentage'
2026-10-21 21:36:49 . 33 - TVService - Returned
2026-10-21 21:36:49 . 34 - CollectionManagement.TVSerieControl.btnAddSerie_Click - Reverting DataChanged
2026-10-21 21:36:49 . 34 - CollectionManagement.LoadTitleList
2026-10-21 21:36:49 . 34 - CollectionManagement.LoadTitleList - There was no element specified to be selected after the load. Storing existing selected element.
2026-10-21 21:36:49 . 34 - CollectionManagement.LoadTitleList - intSelectId '0'
2026-10-21 21:36:49 . 34 - CollectionManagement.LoadTitleList - strSelectId ''
2026-10-21 21:36:49 . 34 - CollectionManagement.LoadTitleList - intSelectParentId '0'
2026-10-21 21:36:49 . 34 - CollectionManagement.LoadTitleList - strSelectParentId ''
2026-10-21 21:36:49 . 34 - CollectionManagement.LoadTitleList - Clearning list
2026-10-21 21:36:49 . 34 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:36:49 . 35 - CollectionManagement.ChangeSelectedTitle - Ignoring row change
2026-10-21 21:36:49 . 35 - Common.Database.ExecuteReader - '(SELECT 'DiscTitle' As nvcType, intId, CASE WHEN nvcWebServiceId = '' THEN NULL ELSE nvcWebServiceId END, ISNULL(tblTitlePersonal.nvcTitle, tblTitles.nvcLocalTitle) As nvcTitle, tblTitlePersonal.intCollectionNumber, nvcDataProvider, nvcUPC, intComplete, ISNULL(tblTitlePersonal.nvcSortTitle, tblTitles.nvcSortTitle) As nvcSortTitle, bitPersonal, ((SELECT COUNT(intTitleSerie) FROM tblTitleSeries WITH (NOLOCK) WHERE intTitle = tblTitles.intId) + (SELECT COUNT(guidMovie) FROM tblTitleMovies WITH (NOLOCK) WHERE intTitle = tblTitles.intId)) As intSubItems, 1 As bitFoundInWebService, bitWorksAsTVSeries ,(SELECT CASE WHEN bitWorksAsTVSeries = 1 THEN (SELECT CASE WHEN '00000000-0000-0000-0000-000000000000' IN (SELECT guidLanguage FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE tblTitles.nvcTVWebServiceId is not null AND tblTitles.nvcTVWebServiceId <> '' AND guidSeries = tblTitles.nvcTVWebServiceId) THEN 1 ELSE 0 END) ELSE 0 END) as bitErroneous , bitMovieConnected, guidMovie , (SELECT nvcName FROM tblTypes WITH (NOLOCK) WHERE intId = tblTitles.intType) as discType , 1 as bitPathSet , nvcOriginalTitle, nvcCover, intCoverWidth, intCoverHeight , CASE WHEN (tblTitlePersonal.intCollectionNumber = -1) THEN 1000000 ELSE tblTitlePersonal.intCollectionNumber END As SortItem , ISNULL(tblTitlePersonal.nvcSortTitle, tblTitles.nvcSortTitle) As SortAlfabetic  FROM tblTitles WITH (NOLOCK), tblTitlePersonal WITH (NOLOCK) WHERE tblTitlePersonal.intTitle = tblTitles.intId AND tblTitles.intId NOT IN (SELECT intTitleSerie FROM tblTitleSeries WITH (NOLOCK))) UNION ALL (SELECT 'Movie' As nvcType, 0 AS intId, guid As nvcWebServiceId ,(SELECT TOP 1 ISNULL(NULLIF([nvcTitle], ''), (Select TOP 1 [nvcTitle] FROM [tblMovieLanguageSpecific] WITH (NOLOCK) WHERE [guidMovie] = [tblMovieGlobal].[guid]  AND [tblMovieLanguageSpecific].nvcTitle != '' ORDER BY [tblMovieLanguageSpecific].[bitAlternative])) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieGlobal.guid ORDER BY CASE WHEN nvcTitle is null then 0 when nvcTitle = '' then 0 else 1 end desc) As nvcTitle , (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieGlobal.guid) AS intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, (SELECT TOP 1 [intComplete] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieGlobal.guid)  As intComplete ,(SELECT TOP 1 ISNULL(NULLIF([nvcSortTitle],''), (SELECT TOP 1 ISNULL(nvcSortTitle, nvcTitle) FROM tblMovieLanguageSpecific WITH (NOLOCK) WHERE guidMovie = tblMovieGlobal.guid ORDER BY CASE WHEN ISNULL(nvcSortTitle, nvcTitle) is null then 0 when ISNULL(nvcSortTitle, nvcTitle) = '' then 0 else 1 end desc, bitAlternative ASC)) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieGlobal.guid ORDER BY CASE WHEN nvcSortTitle is null then 0 when nvcSortTitle = '' then 0 else 1 end desc) As nvcSortTitle , bitPersonal, 0 AS intSubItems, bitFoundInWebService, 0 as bitSeeAsTVSeries ,0 as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'Movie' as discType , (SELECT CASE WHEN (SELECT TOP 1 nvcPath FROM tblElementPersonal WITH (NOLOCK) WHERE guidElement = tblMovieGlobal.guid ORDER BY datDataChanged desc) IS NOT NULL AND (SELECT TOP 1 nvcPath FROM tblElementPersonal WITH (NOLOCK) WHERE guidElement = tblMovieGlobal.guid ORDER BY datDataChanged desc) <> '' THEN 1 ELSE 0 END) as bitPathSet , nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight , CASE WHEN (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieGlobal.guid) = -1 THEN 1000000 ELSE (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieGlobal.guid) END As SortItem , (SELECT TOP 1 ISNULL(NULLIF([nvcSortTitle],''), (SELECT TOP 1 ISNULL(nvcSortTitle, nvcTitle) FROM tblMovieLanguageSpecific WITH (NOLOCK) WHERE guidMovie = tblMovieGlobal.guid ORDER BY CASE WHEN ISNULL(nvcSortTitle, nvcTitle) is null then 0 when ISNULL(nvcSortTitle, nvcTitle) = '' then 0 else 1 end desc, bitAlternative ASC)) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieGlobal.guid ORDER BY CASE WHEN nvcSortTitle is null then 0 when nvcSortTitle = '' then 0 else 1 end desc) As SortAlfabetic FROM tblMovieGlobal WITH (NOLOCK) WHERE guid IS NOT NULL AND intAddType <> 7 ) UNION ALL (SELECT 'MovieCollection' As nvcType, 0 AS intId, guid As nvcWebServiceId ,(SELECT TOP 1 ISNULL(NULLIF([nvcTitle], ''), (Select TOP 1 [nvcTitle] FROM [tblMovieCollectionLanguageSpecific] WITH (NOLOCK) WHERE [guidMovieCollection] = [tblMovieCollectionGlobal].[guid]  AND [tblMovieCollectionLanguageSpecific].nvcTitle != '' ORDER BY [tblMovieCollectionLanguageSpecific].[bitAlternative])) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieCollectionGlobal.guid ORDER BY CASE WHEN nvcTitle is null then 0 when nvcTitle = '' then 0 else 1 end desc) As nvcTitle , (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieCollectionGlobal.guid) AS intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, (SELECT TOP 1 [intComplete] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieCollectionGlobal.guid)  As intComplete ,(SELECT TOP 1 ISNULL(NULLIF([nvcSortTitle],''), (SELECT TOP 1 ISNULL(nvcSortTitle, nvcTitle) FROM tblMovieCollectionLanguageSpecific WITH (NOLOCK) WHERE guidMovieCollection = tblMovieCollectionGlobal.guid ORDER BY CASE WHEN ISNULL(nvcSortTitle, nvcTitle) is null then 0 when ISNULL(nvcSortTitle, nvcTitle) = '' then 0 else 1 end desc, bitAlternative ASC)) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieCollectionGlobal.guid ORDER BY CASE WHEN nvcSortTitle is null then 0 when nvcSortTitle = '' then 0 else 1 end desc) As nvcSortTitle , bitPersonal, (SELECT COUNT(*) FROM tblMovieCollectionMovies WITH (NOLOCK) WHERE guidMovieCollection = tblMovieCollectionGlobal.guid) AS intSubItems, bitFoundInWebService, 0 as bitSeeAsTVSeries ,0 as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'MovieCollection' as discType , 0 as bitPathSet , nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight , CASE WHEN (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieCollectionGlobal.guid) = -1 THEN 1000000 ELSE (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieCollectionGlobal.guid) END As SortItem , (SELECT TOP 1 ISNULL(NULLIF([nvcSortTitle],''), (SELECT TOP 1 ISNULL(nvcSortTitle, nvcTitle) FROM tblMovieCollectionLanguageSpecific WITH (NOLOCK) WHERE guidMovieCollection = tblMovieCollectionGlobal.guid ORDER BY CASE WHEN ISNULL(nvcSortTitle, nvcTitle) is null then 0 when ISNULL(nvcSortTitle, nvcTitle) = '' then 0 else 1 end desc, bitAlternative ASC)) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblMovieCollectionGlobal.guid ORDER BY CASE WHEN nvcSortTitle is null then 0 when nvcSortTitle = '' then 0 else 1 end desc) As SortAlfabetic FROM tblMovieCollectionGlobal WITH (NOLOCK) WHERE guid IS NOT NULL AND intAddType <> 7 )  UNION ALL (SELECT 'TVSerie' As nvcType, 0 AS intId, guid As nvcWebServiceId ,(SELECT TOP 1 ISNULL(NULLIF([nvcTitle], ''), (SELECT TOP 1 ISNULL(nvcName, nvcSortName) FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = tblSeriesGlobal.guid ORDER BY CASE WHEN nvcName is null then 0 else 1 end desc, bitAlternative ASC)) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblSeriesGlobal.guid ORDER BY CASE WHEN nvcTitle is null then 0 when nvcTitle = '' then 0 else 1 end desc) As nvcTitle ,(SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblSeriesGlobal.guid) As intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, (SELECT TOP 1 [intComplete] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblSeriesGlobal.guid) As intComplete ,(SELECT TOP 1 ISNULL(NULLIF([nvcSortTitle],''), (SELECT TOP 1 ISNULL(nvcSortName, nvcName) FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = tblSeriesGlobal.guid ORDER BY CASE WHEN nvcSortName is null then 0 else 1 end desc, bitAlternative ASC)) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblSeriesGlobal.guid ORDER BY CASE WHEN nvcSortTitle is null then 0 when nvcSortTitle = '' then 0 else 1 end desc) As nvcSortTitle , bitPersonal, (SELECT COUNT(guid) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = tblSeriesGlobal.guid) AS intSubItems, bitFoundInWebService, 0 as bitSeeAsTVSeries , (SELECT CASE WHEN '00000000-0000-0000-0000-000000000000' IN (SELECT guidLanguage FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = tblSeriesGlobal.guid) THEN 1 ELSE 0 END) as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'TVSeries' as discType , 1 as bitPathSet , NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight , CASE WHEN (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblSeriesGlobal.guid) = -1 THEN 1000000 ELSE (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblSeriesGlobal.guid) END As SortItem , (SELECT TOP 1 ISNULL(NULLIF([nvcSortTitle],''), (SELECT TOP 1 ISNULL(nvcSortName, nvcName) FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = tblSeriesGlobal.guid ORDER BY CASE WHEN nvcSortName is null then 0 else 1 end desc, bitAlternative ASC)) FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = tblSeriesGlobal.guid ORDER BY CASE WHEN nvcSortTitle is null then 0 when nvcSortTitle = '' then 0 else 1 end desc) As SortAlfabetic FROM tblSeriesGlobal WITH (NOLOCK) WHERE guid IS NOT NULL AND intAddType <> 5 ) ORDER BY SortItem, SortAlfabetic'
2026-10-21 21:36:49 . 36 - CollectionManagement.LoadTitleList - Adding titles
2026-10-21 21:36:49 . 36 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:36:49 . 36 - CollectionManagement.ChangeSelectedTitle - Ignoring row change
2026-10-21 21:36:49 . 36 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:36:49 . 37 - CollectionManagement.LoadTitleList - Recalculating grid
2026-10-21 21:36:49 . 37 - CollectionManagement.LoadTitleList - Displaying database statistics
2026-10-21 21:36:49 . 37 - Common.Database.ExecuteScalar - 'SELECT SUM(intCountAs) FROM (SELECT CASE WHEN (SELECT intCountAs FROM tblTitles AS tblParentTitle WITH (NOLOCK) WHERE intId = (SELECT TOP 1 intTitle FROM tblTitleSeries WITH (NOLOCK) WHERE intTitleSerie = tblTitles.intId)) > 0 THEN 0 ELSE ISNULL(tblTitlePersonal.intCountAs, ISNULL(tblTitles.intCountAs, 1)) END As intCountAs FROM tblTitles WITH (NOLOCK), tblTitlePersonal WITH (NOLOCK) WHERE tblTitles.intId = tblTitlePersonal.intTitle) As tblCount'
2026-10-21 21:36:49 . 38 - Common.Database.ExecuteScalar - 'SELECT COUNT(guid) FROM tblMovieGlobal WITH (NOLOCK) WHERE NOT intAddType = 7'
2026-10-21 21:36:49 . 38 - Common.Database.ExecuteScalar - 'SELECT COUNT(guid) FROM tblMovieGlobal WITH (NOLOCK)'
2026-10-21 21:36:49 . 38 - Common.Database.ExecuteScalar - 'SELECT COUNT(guid) FROM tblSeriesGlobal WITH (NOLOCK) WHERE NOT intAddType = 5'
2026-10-21 21:36:49 . 38 - Common.Database.ExecuteScalar - 'SELECT COUNT(guid) FROM tblSeriesGlobal WITH (NOLOCK)'
2026-10-21 21:36:49 . 38 - Common.Database.ExecuteScalar - 'SELECT COUNT(guid) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE bitOwned = 1 AND NOT intAddType = 5'
2026-10-21 21:36:49 . 39 - Common.Database.ExecuteScalar - 'SELECT COUNT(guid) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE bitOwned = 1'
2026-10-21 21:36:49 . 39 - Common.Database.ExecuteScalar - 'SELECT COUNT(intId) FROM tblPersons WITH (NOLOCK) WHERE EXISTS (SELECT intPerson FROM tblTitlePerson WITH (NOLOCK) WHERE intPerson = tblPersons.intId AND intType = 1) OR EXISTS (SELECT intId FROM tblMoviePersons WITH (NOLOCK) WHERE intId = tblPersons.intId AND intType = 1) OR EXISTS (SELECT intId FROM tblSeriePersons WITH (NOLOCK) WHERE intId = tblPersons.intId AND intType = 1) OR EXISTS (SELECT intPerson FROM tblEpisodePersons WITH (NOLOCK) WHERE intPerson = tblPersons.intId AND intType = 1)'
2026-10-21 21:36:49 . 39 - Common.Database.ExecuteScalar - 'SELECT COUNT(intId) FROM tblPersons WITH (NOLOCK) WHERE EXISTS (SELECT intPerson FROM tblTitlePerson WITH (NOLOCK) WHERE intPerson = tblPersons.intId AND intType = 2) OR EXISTS (SELECT intId FROM tblMoviePersons WITH (NOLOCK) WHERE intId = tblPersons.intId AND intType = 2) OR EXISTS (SELECT intId FROM tblSeriePersons WITH (NOLOCK) WHERE intId = tblPersons.intId AND intType = 2) OR EXISTS (SELECT intPerson FROM tblEpisodePersons WITH (NOLOCK) WHERE intPerson = tblPersons.intId AND intType = 2)'
2026-10-21 21:36:49 . 40 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:36:49 . 42 - CollectionManagement.TVSerieControl.Close - Reverting DataChanged
2026-10-21 21:36:49 . 43 - TVSerieControl.ShowPoster - Disposing poster
2026-10-21 21:36:49 . 45 - DiscTitleControl.LoadDisc
2026-10-21 21:36:49 . 47 - DiscTitleControl.CheckCompleteAgainstServer
2026-10-21 21:36:49 . 47 - DiscTitleControl.CheckCompleteAgainstServer - end
2026-10-21 21:36:49 . 47 - CollectionManagement.ChangeSelectedTitle - END
2026-10-21 21:36:49 . 48 - Common.Database.ExecuteReader - '(SELECT 'TVSerie' As nvcType, 0 AS intId, SG.guid As nvcWebServiceId ,(SELECT TOP 1 nvcName FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid ORDER BY CASE WHEN nvcName is null then 0 else 1 end desc, bitAlternative ASC) As nvcTitle , (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = SG.guid) AS intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete , (SELECT TOP 1 nvcName FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid ORDER BY CASE WHEN nvcName is null then 0 else 1 end desc, bitAlternative ASC) As nvcSortTitle , SG.bitPersonal, (SELECT COUNT(guid) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = SG.guid) AS intSubItems, 1 as bitDataDownloaded , 1 as bitFileSet, -1 as intSeasonNumber, -1 as intEpisodeNumber, SG.bitFoundInWebService, 1 as bolOnDisc, 0 As bitWorksAsTVSeries , (SELECT CASE WHEN '00000000-0000-0000-0000-000000000000' IN (SELECT guidLanguage FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid) THEN 1 ELSE 0 END) as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'TVSeries' as discType , NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblSeriesGlobal SG WITH (NOLOCK) INNER JOIN tblTitles T on T.nvcTVWebServiceId = CAST(SG.guid AS NVARCHAR(MAX)) WHERE T.intId = 1) UNION ALL (SELECT 'DiscTitle' As nvcType, intId, CASE WHEN nvcWebServiceId = '' THEN NULL ELSE nvcWebServiceId END , ISNULL(tblTitlePersonal.nvcTitle, tblTitles.nvcLocalTitle) As nvcTitle , tblTitlePersonal.intCollectionNumber, nvcDataProvider, nvcUPC, intComplete , ISNULL(tblTitlePersonal.nvcSortTitle, tblTitles.nvcSortTitle) As nvcSortTitle, tblTitles.bitPersonal , (SELECT COUNT(intTitleSerie) FROM tblTitleSeries WITH (NOLOCK) WHERE intTitle = tblTitles.intId) As intSubItems , 1 as bitDataDownloaded, 1 as bitFileSet, 0 As intSeasonNumber, 0 As intEpisodeNumber, 1 As bitFoundInWebService, 0 as bolOnDisc, bitWorksAsTVSeries, 0 as bitErroneous , bitMovieConnected, guidMovie , (SELECT nvcName FROM tblTypes WITH (NOLOCK) WHERE intId = tblTitles.intType) as discType , nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblTitles WITH (NOLOCK), tblTitlePersonal WITH (NOLOCK) WHERE tblTitlePersonal.intTitle = tblTitles.intId AND tblTitles.intId IN (SELECT intTitleSerie FROM tblTitleSeries WITH (NOLOCK) WHERE intTitle = 1))'
2026-10-21 21:36:49 . 48 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:36:49 . 49 - Common.Database.ExecuteReader - 'SELECT 'TVSeason' As nvcType, intSeasonNumber AS intId, guidSerie As nvcWebServiceId, ('Season ' + CAST(intSeasonNumber AS NVARCHAR(255))) As nvcTitle, -1 As intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete, ('Season ' + CAST(intSeasonNumber AS NVARCHAR(255))) As nvcSortTitle, 0 As bitPersonal, 1 AS intSubItems , (CASE WHEN (SELECT COUNT(*) FROM tblEpisodeGlobal EG WITH (NOLOCK) WHERE EG.intSeasonNumber = tblEpisodeGlobal.intSeasonNumber AND tblEpisodeGlobal.guidSerie = EG.guidSerie and EG.bitOwned = 1) > 0 THEN 1 ELSE 0 END) as bitDataDownloaded , 1 as bitFileSet, intSeasonNumber, intEpisodeNumber, (CASE WHEN (SELECT COUNT(*) FROM tblEpisodeGlobal EG WITH (NOLOCK) WHERE EG.intSeasonNumber = tblEpisodeGlobal.intSeasonNumber AND tblEpisodeGlobal.guidSerie = EG.guidSerie and EG.bitFoundInWebService = 1) > 0 THEN 1 ELSE 0 END) as bitFoundInWebService , 0 as bolOnDisc, 0 As bitWorksAsTVSeries, 0 as bitErroneous, 0 as bitMovieConnected, NULL as guidMovie, 'TVSeason' as discType, NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guid IN (SELECT DISTINCT (SELECT TOP 1 guid FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' AND intSeasonNumber = tblEpisodeGlobal1.intSeasonNumber AND bitOwned = 1 AND (guid IN (SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) INNER JOIN tblDiscs D WITH (NOLOCK) on D.intId = DT.intDisc WHERE DT.guidEpisode is not NULL AND D.intTitle = 1 ) OR guid IN (SELECT guidEpisode FROM tblTitleEpisodes WITH (NOLOCK) WHERE intTitle = 1 ))  ORDER BY intEpisodeNumber) As guid FROM tblEpisodeGlobal tblEpisodeGlobal1 WITH (NOLOCK) WHERE tblEpisodeGlobal1.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6') ORDER BY intSeasonNumber'
2026-10-21 21:36:49 . 51 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:36:49 . 52 - Common.Database.ExecuteReader - 'SELECT 'TVEpisode' As nvcType, 0 AS intId, guid As nvcWebServiceId , ISNULL(ISNULL((SELECT TOP 1 NULLIF(nvcName, '') FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid  ORDER BY CASE WHEN nvcName IS NULL THEN 0 ELSE 1 END DESC, bitAlternative ASC), nvcOriginalTitle), 'Episode ' + CAST(intEpisodeNumber AS NVARCHAR(MAX))) As nvcTitle , -1 As intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete , (SELECT TOP 1 nvcName FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid) As nvcSortTitle , 0 As bitPersonal, 0 AS intSubItems , bitOwned as bitDataDownloaded , (CASE WHEN (SELECT COUNT(*) FROM tblEpisodePersonal EP WITH (NOLOCK) WHERE EP.guidEpisode = tblEpisodeGlobal.guid and EP.nvcPath is not null) > 0 THEN 1 ELSE 0 END) as bitFileSet, intSeasonNumber, intEpisodeNumber, bitFoundInWebService , (CASE WHEN (guid IN ((SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) WHERE DT.guidEpisode IS NOT NULL) UNION ALL (SELECT ET.guidEpisode FROM tblTitleEpisodes ET WITH (NOLOCK) WHERE ET.guidEpisode IS NOT NULL))) THEN 1 ELSE 0 END) as bolOnDisc, 0 As bitWorksAsTVSeries, 0 as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'TVEpisode' as discType, NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, CASE WHEN ISNULL((SELECT TOP 1 NULLIF(nvcName, '') FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid  ORDER BY CASE WHEN nvcName IS NULL THEN 0 ELSE 1 END DESC, bitAlternative ASC), nvcOriginalTitle) IS NULL THEN 0 ELSE 1 END As bitContainsTitle FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' AND intSeasonNumber = '1' AND bitOwned = 1 AND (guid IN (SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) INNER JOIN tblDiscs D WITH (NOLOCK) on D.intId = DT.intDisc WHERE DT.guidEpisode is not NULL AND D.intTitle = 1) OR guid IN (SELECT guidEpisode FROM tblTitleEpisodes WITH (NOLOCK) WHERE intTitle = 1))  ORDER BY intEpisodeNumber'
2026-10-21 21:36:49 . 55 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:36:49 . 56 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:36:49 . 58 - CollectionManagement.TVSerieControl.Close - Reverting DataChanged
2026-10-21 21:36:49 . 58 - CollectionManagement.ChangeSelectedTitle - Row found
2026-10-21 21:36:49 . 59 - DiscTitleControl.CheckCompleteAgainstServer - DoWork running
2026-10-21 21:36:49 . 59 - Common.Database.ExecuteScalar - 'SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE intId = (SELECT intCountry FROM tblTitles WITH (NOLOCK) WHERE intId = 2)'
2026-10-21 21:36:49 . 59 - TVDatabase.IsEpisodeRegistered - Transaction: 'False'
2026-10-21 21:36:49 . 59 - DiscTitleControl.CheckCompleteAgainstServer - WebService Id '4bd7501b-a936-415e-96eb-d55bb5abf834'
2026-10-21 21:36:49 . 59 - TVDatabase.IsEpisodeRegistered - Open objConn
2026-10-21 21:36:49 . 59 - SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1
2026-10-21 21:36:49 . 59 - Common.Database.ExecuteScalar - 'SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1'
2026-10-21 21:36:49 . 60 - TVDatabase.IsEpisodeRegistered - Close objConn
2026-10-21 21:36:49 . 66 - TVDatabase.IsEpisodeRegistered - Transaction: 'False'
2026-10-21 21:36:49 . 66 - TVDatabase.IsEpisodeRegistered - Open objConn
2026-10-21 21:36:49 . 66 - SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1
2026-10-21 21:36:49 . 66 - Common.Database.ExecuteScalar - 'SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1'
2026-10-21 21:36:49 . 66 - TVDatabase.IsEpisodeRegistered - Close objConn
2026-10-21 21:36:49 . 67 - TVDatabase.GetLocalEpisode episode '17368189-c757-43d9-995d-0061915cd7b8'
2026-10-21 21:36:49 . 67 - TVDatabase.GetLocalEpisode - Open objConn
2026-10-21 21:36:49 . 67 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber,EG.intEpisodeNumber,EG.nvcOriginalTitle,EG.nvcProductionCode,EG.intAbsoluteNumber,EG.nvcDVDDiscId,EG.nvcDVDSeason,EG.nvcDVDEpisodeNumber,EG.nvcDVDChapter,EG.decTVDBRating,EG.guidSerie, EG.intAddType, EG.guidAddId,EG.datDataChanged,EG.bitLocked, EG.bitFoundInWebService, EG.bitEdited, EG.bitOnlyLocal, EG.bitOwned ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE L.guid = ELS.guidLanguage) as language,ELS.nvcName, ELS.nvcSortName,ELS.ntxOverview,ELS.datDataChanged, ELS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = ECS.guidCountry) as country,ECS.datFirstAired,ECS.datDataChanged, ECS.bitEdited ,EP.intRating,EP.nvcPath,EP.nvcMobileLocationPrimary,EP.nvcMobileLocationSecondary,EP.bitWatched,EP.datDataChanged,EP.datAdded, EG.[lngProgress], EG.[bitOnlyLocal] FROM tblEpisodeGlobal EG LEFT OUTER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodeCountrySpecific ECS on ECS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodePersonal EP on EP.guidEpisode = EG.[guid] WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY ELS.bitAlternative ASC '
2026-10-21 21:36:49 . 67 - Common.Database.ExecuteReader - 'Select [nvcUser] As [User] ,[datDate] As Date ,[bitPriorTo] As Before ,[intState] As State ,[nvcNotes] As Notes ,[nvcHow] As How ,[guidSession] AS Session FROM [tblWatched] WHERE [guid] = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY [datDate]'
2026-10-21 21:36:49 . 67 - Common.Database.ExecuteReader - 'SELECT T.nvcLocalTitle, D.nvcLabel FROM tblTitles T INNER JOIN tblDiscs D on D.intTitle = T.intId INNER JOIN tblDiscTitles DT on DT.intDisc = D.intId WHERE DT.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8' '
2026-10-21 21:36:49 . 68 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:36:49 . 68 - Common.Database.ExecuteReader - 'SELECT EP.intPerson,EP.nvcCharacter,EP.intSort,EP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblEpisodePersons EP INNER JOIN tblPersons P on P.intId = EP.intPerson WHERE EP.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:36:49 . 69 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[nvcSortName],[ntxOverview],ELS.datDataChanged FROM [My Movies].[dbo].[tblEpisodeGlobal] EG INNER JOIN [tblEpisodeLanguageSpecific] ELS on EG.guid = ELS.guidEpisode WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' AND ELS.bitAlternative = 1 '
2026-10-21 21:36:49 . 69 - TVDatabase.GetLocalEpisode - Close objConn
2026-10-21 21:36:49 . 75 - Common.GetImageFromDatabase - 'TVImages\17368189-c757-43d9-995d-0061915cd7b8.jpg'
2026-10-21 21:36:49 . 75 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:36:49 . 75 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVImages\17368189-c757-43d9-995d-0061915cd7b8.jpg''
2026-10-21 21:36:49 . 77 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:36:49 . 83 - Common.Database.ExecuteReader - 'SELECT nvcName FROM tblCountries ORDER BY nvcName'
2026-10-21 21:36:50 . 10 - TVDatabase.EnsureWebServiceHandShake
2026-10-21 21:36:50 . 10 - Common.OnlineService.Calls.LoadDiscTitleInformation - Calling 'LoadDiscTitleInformation', attempt 1 of 3.
2026-10-21 21:36:50 . 40 - Common.OnlineService.Calls.LoadDiscTitleInformation - Returning retrieved node.
2026-10-21 21:36:50 . 40 - DiscTitleControl.CheckCompleteAgainstServer - DoWork end
2026-10-21 21:36:50 . 41 - TVService - Calling 'GetEpisodeCompletePercentage'
2026-10-21 21:36:50 . 74 - TVService - Returned
2026-10-21 21:36:50 . 76 - DiscTitleControl.LoadDisc
2026-10-21 21:36:50 . 78 - DiscTitleControl.CheckCompleteAgainstServer
2026-10-21 21:36:50 . 78 - DiscTitleControl.CheckCompleteAgainstServer - end
2026-10-21 21:36:50 . 78 - CollectionManagement.ChangeSelectedTitle - END
2026-10-21 21:36:50 . 80 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted running
2026-10-21 21:36:50 . 80 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted done
2026-10-21 21:36:50 . 88 - DiscTitleControl.CheckCompleteAgainstServer - DoWork running
2026-10-21 21:36:50 . 88 - Common.Database.ExecuteScalar - 'SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE intId = (SELECT intCountry FROM tblTitles WITH (NOLOCK) WHERE intId = 2)'
2026-10-21 21:36:50 . 89 - DiscTitleControl.CheckCompleteAgainstServer - WebService Id '4bd7501b-a936-415e-96eb-d55bb5abf834'
2026-10-21 21:36:50 . 98 - Common.OnlineService.Calls.LoadDiscTitleInformation - Calling 'LoadDiscTitleInformation', attempt 1 of 3.
2026-10-21 21:36:50 . 99 - CollectionManagement.TVSerieControl.Close - Reverting DataChanged
2026-10-21 21:36:51 . 00 - CollectionManagement.ChangeSelectedTitle - Row found
2026-10-21 21:36:51 . 00 - TVDatabase.IsEpisodeRegistered - Transaction: 'False'
2026-10-21 21:36:51 . 01 - TVDatabase.IsEpisodeRegistered - Open objConn
2026-10-21 21:36:51 . 01 - SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1
2026-10-21 21:36:51 . 01 - Common.Database.ExecuteScalar - 'SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1'
2026-10-21 21:36:51 . 01 - TVDatabase.IsEpisodeRegistered - Close objConn
2026-10-21 21:36:51 . 03 - TVDatabase.IsEpisodeRegistered - Transaction: 'False'
2026-10-21 21:36:51 . 03 - TVDatabase.IsEpisodeRegistered - Open objConn
2026-10-21 21:36:51 . 03 - SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1
2026-10-21 21:36:51 . 03 - Common.Database.ExecuteScalar - 'SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1'
2026-10-21 21:36:51 . 03 - TVDatabase.IsEpisodeRegistered - Close objConn
2026-10-21 21:36:51 . 03 - TVDatabase.GetLocalEpisode episode '17368189-c757-43d9-995d-0061915cd7b8'
2026-10-21 21:36:51 . 04 - TVDatabase.GetLocalEpisode - Open objConn
2026-10-21 21:36:51 . 04 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber,EG.intEpisodeNumber,EG.nvcOriginalTitle,EG.nvcProductionCode,EG.intAbsoluteNumber,EG.nvcDVDDiscId,EG.nvcDVDSeason,EG.nvcDVDEpisodeNumber,EG.nvcDVDChapter,EG.decTVDBRating,EG.guidSerie, EG.intAddType, EG.guidAddId,EG.datDataChanged,EG.bitLocked, EG.bitFoundInWebService, EG.bitEdited, EG.bitOnlyLocal, EG.bitOwned ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE L.guid = ELS.guidLanguage) as language,ELS.nvcName, ELS.nvcSortName,ELS.ntxOverview,ELS.datDataChanged, ELS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = ECS.guidCountry) as country,ECS.datFirstAired,ECS.datDataChanged, ECS.bitEdited ,EP.intRating,EP.nvcPath,EP.nvcMobileLocationPrimary,EP.nvcMobileLocationSecondary,EP.bitWatched,EP.datDataChanged,EP.datAdded, EG.[lngProgress], EG.[bitOnlyLocal] FROM tblEpisodeGlobal EG LEFT OUTER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodeCountrySpecific ECS on ECS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodePersonal EP on EP.guidEpisode = EG.[guid] WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY ELS.bitAlternative ASC '
2026-10-21 21:36:51 . 04 - Common.Database.ExecuteReader - 'Select [nvcUser] As [User] ,[datDate] As Date ,[bitPriorTo] As Before ,[intState] As State ,[nvcNotes] As Notes ,[nvcHow] As How ,[guidSession] AS Session FROM [tblWatched] WHERE [guid] = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY [datDate]'
2026-10-21 21:36:51 . 04 - Common.Database.ExecuteReader - 'SELECT T.nvcLocalTitle, D.nvcLabel FROM tblTitles T INNER JOIN tblDiscs D on D.intTitle = T.intId INNER JOIN tblDiscTitles DT on DT.intDisc = D.intId WHERE DT.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8' '
2026-10-21 21:36:51 . 04 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:36:51 . 05 - Common.Database.ExecuteReader - 'SELECT EP.intPerson,EP.nvcCharacter,EP.intSort,EP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblEpisodePersons EP INNER JOIN tblPersons P on P.intId = EP.intPerson WHERE EP.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:36:51 . 05 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[nvcSortName],[ntxOverview],ELS.datDataChanged FROM [My Movies].[dbo].[tblEpisodeGlobal] EG INNER JOIN [tblEpisodeLanguageSpecific] ELS on EG.guid = ELS.guidEpisode WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' AND ELS.bitAlternative = 1 '
2026-10-21 21:36:51 . 05 - TVDatabase.GetLocalEpisode - Close objConn
2026-10-21 21:36:51 . 09 - Common.GetImageFromDatabase - 'TVImages\17368189-c757-43d9-995d-0061915cd7b8.jpg'
2026-10-21 21:36:51 . 09 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:36:51 . 09 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVImages\17368189-c757-43d9-995d-0061915cd7b8.jpg''
2026-10-21 21:36:51 . 10 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:36:51 . 16 - Common.Database.ExecuteReader - 'SELECT nvcName FROM tblCountries ORDER BY nvcName'
2026-10-21 21:36:51 . 28 - Common.OnlineService.Calls.LoadDiscTitleInformation - Returning retrieved node.
2026-10-21 21:36:51 . 28 - DiscTitleControl.CheckCompleteAgainstServer - DoWork end
2026-10-21 20:36:51 . 40 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:36:51 . 42 - TVDatabase.EnsureWebServiceHandShake
2026-10-21 21:36:51 . 74 - TVService - Calling 'GetEpisodeCompletePercentage'
2026-10-21 21:36:52 . 05 - TVService - Returned
2026-10-21 21:36:52 . 07 - DiscTitleControl.LoadDisc
2026-10-21 21:36:52 . 09 - DiscTitleControl.CheckCompleteAgainstServer
2026-10-21 21:36:52 . 09 - DiscTitleControl.CheckCompleteAgainstServer - end
2026-10-21 21:36:52 . 09 - CollectionManagement.ChangeSelectedTitle - END
2026-10-21 21:36:52 . 09 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted running
2026-10-21 21:36:52 . 10 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted done
2026-10-21 21:36:52 . 21 - DiscTitleControl.CheckCompleteAgainstServer - DoWork running
2026-10-21 21:36:52 . 21 - Common.Database.ExecuteScalar - 'SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE intId = (SELECT intCountry FROM tblTitles WITH (NOLOCK) WHERE intId = 2)'
2026-10-21 21:36:52 . 21 - DiscTitleControl.CheckCompleteAgainstServer - WebService Id '4bd7501b-a936-415e-96eb-d55bb5abf834'
2026-10-21 21:36:52 . 29 - Common.OnlineService.Calls.LoadDiscTitleInformation - Calling 'LoadDiscTitleInformation', attempt 1 of 3.
2026-10-21 21:36:52 . 60 - Common.OnlineService.Calls.LoadDiscTitleInformation - Returning retrieved node.
2026-10-21 21:36:52 . 60 - DiscTitleControl.CheckCompleteAgainstServer - DoWork end
2026-10-21 21:36:52 . 60 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted running
2026-10-21 21:36:52 . 60 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted done
2026-10-21 21:36:58 . 26 - Common.Database.ExecuteReader - '(SELECT 'TVSerie' As nvcType, 0 AS intId, SG.guid As nvcWebServiceId ,(SELECT TOP 1 nvcName FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid ORDER BY CASE WHEN nvcName is null then 0 else 1 end desc, bitAlternative ASC) As nvcTitle , (SELECT TOP 1 [intCollectionNumber] FROM [tblElementPersonal] WITH (NOLOCK) WHERE [guidElement] = SG.guid) AS intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete , (SELECT TOP 1 nvcName FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid ORDER BY CASE WHEN nvcName is null then 0 else 1 end desc, bitAlternative ASC) As nvcSortTitle , SG.bitPersonal, (SELECT COUNT(guid) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = SG.guid) AS intSubItems, 1 as bitDataDownloaded , 1 as bitFileSet, -1 as intSeasonNumber, -1 as intEpisodeNumber, SG.bitFoundInWebService, 1 as bolOnDisc, 0 As bitWorksAsTVSeries , (SELECT CASE WHEN '00000000-0000-0000-0000-000000000000' IN (SELECT guidLanguage FROM tblSeriesLanguageSpecific WITH (NOLOCK) WHERE guidSeries = SG.guid) THEN 1 ELSE 0 END) as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'TVSeries' as discType , NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblSeriesGlobal SG WITH (NOLOCK) INNER JOIN tblTitles T on T.nvcTVWebServiceId = CAST(SG.guid AS NVARCHAR(MAX)) WHERE T.intId = 2) UNION ALL (SELECT 'DiscTitle' As nvcType, intId, CASE WHEN nvcWebServiceId = '' THEN NULL ELSE nvcWebServiceId END , ISNULL(tblTitlePersonal.nvcTitle, tblTitles.nvcLocalTitle) As nvcTitle , tblTitlePersonal.intCollectionNumber, nvcDataProvider, nvcUPC, intComplete , ISNULL(tblTitlePersonal.nvcSortTitle, tblTitles.nvcSortTitle) As nvcSortTitle, tblTitles.bitPersonal , (SELECT COUNT(intTitleSerie) FROM tblTitleSeries WITH (NOLOCK) WHERE intTitle = tblTitles.intId) As intSubItems , 1 as bitDataDownloaded, 1 as bitFileSet, 0 As intSeasonNumber, 0 As intEpisodeNumber, 1 As bitFoundInWebService, 0 as bolOnDisc, bitWorksAsTVSeries, 0 as bitErroneous , bitMovieConnected, guidMovie , (SELECT nvcName FROM tblTypes WITH (NOLOCK) WHERE intId = tblTitles.intType) as discType , nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblTitles WITH (NOLOCK), tblTitlePersonal WITH (NOLOCK) WHERE tblTitlePersonal.intTitle = tblTitles.intId AND tblTitles.intId IN (SELECT intTitleSerie FROM tblTitleSeries WITH (NOLOCK) WHERE intTitle = 2))'
2026-10-21 21:36:58 . 27 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:36:58 . 70 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:36:58 . 70 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:36:58 . 70 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 21:37:00 . 38 - Common.Database.ExecuteReader - 'SELECT 'TVSeason' As nvcType, intSeasonNumber AS intId, guidSerie As nvcWebServiceId, ('Season ' + CAST(intSeasonNumber AS NVARCHAR(255))) As nvcTitle, -1 As intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete, ('Season ' + CAST(intSeasonNumber AS NVARCHAR(255))) As nvcSortTitle, 0 As bitPersonal, 1 AS intSubItems , (CASE WHEN (SELECT COUNT(*) FROM tblEpisodeGlobal EG WITH (NOLOCK) WHERE EG.intSeasonNumber = tblEpisodeGlobal.intSeasonNumber AND tblEpisodeGlobal.guidSerie = EG.guidSerie and EG.bitOwned = 1) > 0 THEN 1 ELSE 0 END) as bitDataDownloaded , 1 as bitFileSet, intSeasonNumber, intEpisodeNumber, (CASE WHEN (SELECT COUNT(*) FROM tblEpisodeGlobal EG WITH (NOLOCK) WHERE EG.intSeasonNumber = tblEpisodeGlobal.intSeasonNumber AND tblEpisodeGlobal.guidSerie = EG.guidSerie and EG.bitFoundInWebService = 1) > 0 THEN 1 ELSE 0 END) as bitFoundInWebService , 0 as bolOnDisc, 0 As bitWorksAsTVSeries, 0 as bitErroneous, 0 as bitMovieConnected, NULL as guidMovie, 'TVSeason' as discType, NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, 1 As bitContainsTitle FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guid IN (SELECT DISTINCT (SELECT TOP 1 guid FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = '6ecad242-d2eb-4db2-a712-e6513edc6fc2' AND intSeasonNumber = tblEpisodeGlobal1.intSeasonNumber AND bitOwned = 1 AND (guid IN (SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) INNER JOIN tblDiscs D WITH (NOLOCK) on D.intId = DT.intDisc WHERE DT.guidEpisode is not NULL AND D.intTitle = 2 ) OR guid IN (SELECT guidEpisode FROM tblTitleEpisodes WITH (NOLOCK) WHERE intTitle = 2 ))  ORDER BY intEpisodeNumber) As guid FROM tblEpisodeGlobal tblEpisodeGlobal1 WITH (NOLOCK) WHERE tblEpisodeGlobal1.guidSerie = '6ecad242-d2eb-4db2-a712-e6513edc6fc2') ORDER BY intSeasonNumber'
2026-10-21 21:37:00 . 40 - CollectionManagement.lstTitles_StartSorting
2026-10-21 20:37:01 . 43 - Common.StoreTVSeriesInformation - Series Id 'd8167137-fb5f-4357-a57c-c33f8b32a3d6'.
2026-10-21 20:37:01 . 43 - Common.SaveTVSeriesInformation
2026-10-21 20:37:01 . 43 - Common.SaveTVSeriesInformation - Open objConn
2026-10-21 20:37:01 . 43 - Common.SaveTVSeriesInformation - Connection Open
2026-10-21 20:37:01 . 43 - Common.GenerateSeriesXML
2026-10-21 20:37:01 . 44 - Common.SELECT intOriginalRunningTime, intDiscRunningTime, nvcOriginalNetwork, decRating, (SELECT nvcName FROM tblTVStatus WITH (NOLOCK) WHERE guid = tblSeriesGlobal.guidOriginalStatus) As nvcOriginalStatus, datFirstAired, timOriginalAirTime, (SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE guid = tblSeriesGlobal.guidOriginalCountry) As nvcOriginalCountry, intAddType, guidAddId, bitFoundInWebService, datDataChanged, (SELECT datAdded FROM [tblElementPersonal] WITH (NOLOCK) WHERE guidElement = guid) as datAdded, bitLocked, (SELECT intCollectionNumber FROM [tblElementPersonal] WITH (NOLOCK) WHERE guidElement = guid) as collNumber, (SELECT COUNT(*) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = tblSeriesGlobal.guid) as intEpisodes, nvcOriginalTitle FROM tblSeriesGlobal WITH (NOLOCK) WHERE guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6'
2026-10-21 20:37:01 . 44 - Common.Database.ExecuteReader - 'SELECT intOriginalRunningTime, intDiscRunningTime, nvcOriginalNetwork, decRating, (SELECT nvcName FROM tblTVStatus WITH (NOLOCK) WHERE guid = tblSeriesGlobal.guidOriginalStatus) As nvcOriginalStatus, datFirstAired, timOriginalAirTime, (SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE guid = tblSeriesGlobal.guidOriginalCountry) As nvcOriginalCountry, intAddType, guidAddId, bitFoundInWebService, datDataChanged, (SELECT datAdded FROM [tblElementPersonal] WITH (NOLOCK) WHERE guidElement = guid) as datAdded, bitLocked, (SELECT intCollectionNumber FROM [tblElementPersonal] WITH (NOLOCK) WHERE guidElement = guid) as collNumber, (SELECT COUNT(*) FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = tblSeriesGlobal.guid) as intEpisodes, nvcOriginalTitle FROM tblSeriesGlobal WITH (NOLOCK) WHERE guid = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 20:37:01 . 44 - Common.SELECT (SELECT nvcName FROM tblLanguages WITH (NOLOCK) WHERE guid = tblSeriesLanguageSpecific.guidLanguage) As nvcLanguage, nvcName, ntxOverview, nvcSortName, bitAlternative, datDataChanged, bitLocked, nvcYouTubeTrailerId FROM tblSeriesLanguageSpecific WHERE guidSeries = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY bitAlternative
2026-10-21 20:37:01 . 44 - Common.Database.ExecuteReader - 'SELECT (SELECT nvcName FROM tblLanguages WITH (NOLOCK) WHERE guid = tblSeriesLanguageSpecific.guidLanguage) As nvcLanguage, nvcName, ntxOverview, nvcSortName, bitAlternative, datDataChanged, bitLocked, nvcYouTubeTrailerId FROM tblSeriesLanguageSpecific WHERE guidSeries = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY bitAlternative'
2026-10-21 20:37:01 . 44 - Common.SELECT (SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE guid = tblSeriesCountrySpecific.guidCountry) As nvcCountry, nvcNetwork, (SELECT nvcName FROM tblTVStatus WITH (NOLOCK) WHERE guid = tblSeriesCountrySpecific.guidStatus) As nvcStatus, datFirstAired, intAirDay, timAirTime, intRunningTime, intParentalRating, bitAlternative, datDataChanged, bitLocked FROM tblSeriesCountrySpecific WITH (NOLOCK) WHERE tblSeriesCountrySpecific.guidSeries = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY bitAlternative
2026-10-21 20:37:01 . 44 - Common.Database.ExecuteReader - 'SELECT (SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE guid = tblSeriesCountrySpecific.guidCountry) As nvcCountry, nvcNetwork, (SELECT nvcName FROM tblTVStatus WITH (NOLOCK) WHERE guid = tblSeriesCountrySpecific.guidStatus) As nvcStatus, datFirstAired, intAirDay, timAirTime, intRunningTime, intParentalRating, bitAlternative, datDataChanged, bitLocked FROM tblSeriesCountrySpecific WITH (NOLOCK) WHERE tblSeriesCountrySpecific.guidSeries = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY bitAlternative'
2026-10-21 20:37:01 . 45 - Common.SELECT tblGenres.nvcName FROM tblGenres WITH (NOLOCK), tblSerieGenres WITH (NOLOCK) WHERE tblSerieGenres.intGenre = tblGenres.intId AND tblSerieGenres.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6'
2026-10-21 20:37:01 . 45 - Common.Database.ExecuteReader - 'SELECT tblGenres.nvcName FROM tblGenres WITH (NOLOCK), tblSerieGenres WITH (NOLOCK) WHERE tblSerieGenres.intGenre = tblGenres.intId AND tblSerieGenres.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 20:37:01 . 45 - Common.SELECT R.nvcRemoteName, R.nvcRemoteId FROM tblRemoteIDs R WITH (NOLOCK) WHERE R.guidItem = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6'
2026-10-21 20:37:01 . 45 - Common.Database.ExecuteReader - 'SELECT R.nvcRemoteName, R.nvcRemoteId FROM tblRemoteIDs R WITH (NOLOCK) WHERE R.guidItem = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 20:37:01 . 45 - Common.SELECT tblCategories.nvcName FROM tblCategories WITH (NOLOCK), tblSerieCategory WITH (NOLOCK) WHERE tblSerieCategory.intCategory = tblCategories.intId AND tblSerieCategory.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6'
2026-10-21 20:37:01 . 45 - Common.Database.ExecuteReader - 'SELECT tblCategories.nvcName FROM tblCategories WITH (NOLOCK), tblSerieCategory WITH (NOLOCK) WHERE tblSerieCategory.intCategory = tblCategories.intId AND tblSerieCategory.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 20:37:01 . 45 - Common.SELECT tblPersons.nvcName, tblSeriePersons.nvcRole, tblSeriePersons.intType, tblPersons.nvcWebServiceId FROM tblPersons WITH (NOLOCK), tblSeriePersons WITH (NOLOCK) WHERE tblSeriePersons.intId = tblPersons.intId AND tblSeriePersons.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY tblSeriePersons.intSort
2026-10-21 20:37:01 . 46 - Common.Database.ExecuteReader - 'SELECT tblPersons.nvcName, tblSeriePersons.nvcRole, tblSeriePersons.intType, tblPersons.nvcWebServiceId FROM tblPersons WITH (NOLOCK), tblSeriePersons WITH (NOLOCK) WHERE tblSeriePersons.intId = tblPersons.intId AND tblSeriePersons.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY tblSeriePersons.intSort'
2026-10-21 20:37:01 . 46 - Common.Database.ExecuteReader - 'SELECT nvcPath FROM tblElementPersonal WITH (NOLOCK) WHERE guidElement = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 20:37:01 . 47 - TVMetadata.FindAndSetSeriesPath
2026-10-21 20:37:01 . 47 - TVDatabase.GetSeriePaths
2026-10-21 20:37:01 . 47 - TVDatabase.GetSeriePaths - Open objConn
2026-10-21 20:37:01 . 47 - Common.Database.ExecuteReader - 'SELECT SP.nvcPath FROM tblSeriePaths SP WHERE SP.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 20:37:01 . 47 - TVDatabase.GetSeriePaths - Close objConn
2026-10-21 20:37:01 . 47 - Common.SaveTVSeriesInformation - Checking if Dune information should be stored.
2026-10-21 20:37:01 . 47 - Common.SaveTVSeriesInformation - Dune storage is disabled.
2026-10-21 20:37:01 . 47 - Common.Database.ExecuteNonQuery - 'DELETE FROM tblTitleInfoStorageQueue WHERE guidElement = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 20:37:01 . 48 - Common.SaveTVSeriesInformation - Close objConn
2026-10-21 21:37:01 . 81 - Common.Database.ExecuteReader - 'SELECT 'TVEpisode' As nvcType, 0 AS intId, guid As nvcWebServiceId , ISNULL(ISNULL((SELECT TOP 1 NULLIF(nvcName, '') FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid  ORDER BY CASE WHEN nvcName IS NULL THEN 0 ELSE 1 END DESC, bitAlternative ASC), nvcOriginalTitle), 'Episode ' + CAST(intEpisodeNumber AS NVARCHAR(MAX))) As nvcTitle , -1 As intCollectionNumber, '' As nvcDataProvider, '' As nvcUPC, 0 As intComplete , (SELECT TOP 1 nvcName FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid) As nvcSortTitle , 0 As bitPersonal, 0 AS intSubItems , bitOwned as bitDataDownloaded , (CASE WHEN (SELECT COUNT(*) FROM tblEpisodePersonal EP WITH (NOLOCK) WHERE EP.guidEpisode = tblEpisodeGlobal.guid and EP.nvcPath is not null) > 0 THEN 1 ELSE 0 END) as bitFileSet, intSeasonNumber, intEpisodeNumber, bitFoundInWebService , (CASE WHEN (guid IN ((SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) WHERE DT.guidEpisode IS NOT NULL) UNION ALL (SELECT ET.guidEpisode FROM tblTitleEpisodes ET WITH (NOLOCK) WHERE ET.guidEpisode IS NOT NULL))) THEN 1 ELSE 0 END) as bolOnDisc, 0 As bitWorksAsTVSeries, 0 as bitErroneous , 0 as bitMovieConnected, NULL as guidMovie, 'TVEpisode' as discType, NULL As nvcOriginalTitle, '' As nvcCover, 0 As intCoverWidth, 0 As intCoverHeight, CASE WHEN ISNULL((SELECT TOP 1 NULLIF(nvcName, '') FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = tblEpisodeGlobal.guid  ORDER BY CASE WHEN nvcName IS NULL THEN 0 ELSE 1 END DESC, bitAlternative ASC), nvcOriginalTitle) IS NULL THEN 0 ELSE 1 END As bitContainsTitle FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = '6ecad242-d2eb-4db2-a712-e6513edc6fc2' AND intSeasonNumber = '1' AND bitOwned = 1 AND (guid IN (SELECT DT.guidEpisode FROM tblDiscTitles DT WITH (NOLOCK) INNER JOIN tblDiscs D WITH (NOLOCK) on D.intId = DT.intDisc WHERE DT.guidEpisode is not NULL AND D.intTitle = 2) OR guid IN (SELECT guidEpisode FROM tblTitleEpisodes WITH (NOLOCK) WHERE intTitle = 2))  ORDER BY intEpisodeNumber'
2026-10-21 21:37:01 . 83 - CollectionManagement.lstTitles_StartSorting
2026-10-21 21:37:03 . 30 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:37:03 . 34 - CollectionManagement.ChangeSelectedTitle - Row found
2026-10-21 21:37:03 . 35 - TVDatabase.IsEpisodeRegistered - Transaction: 'False'
2026-10-21 21:37:03 . 35 - TVDatabase.IsEpisodeRegistered - Open objConn
2026-10-21 21:37:03 . 35 - SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='6585dba5-58ac-4370-b3a4-33d5e48b3648' AND bitOwned = 1
2026-10-21 21:37:03 . 36 - Common.Database.ExecuteScalar - 'SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='6585dba5-58ac-4370-b3a4-33d5e48b3648' AND bitOwned = 1'
2026-10-21 21:37:03 . 36 - TVDatabase.IsEpisodeRegistered - Close objConn
2026-10-21 21:37:03 . 37 - TVDatabase.IsEpisodeRegistered - Transaction: 'False'
2026-10-21 21:37:03 . 37 - TVDatabase.IsEpisodeRegistered - Open objConn
2026-10-21 21:37:03 . 38 - SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='6585dba5-58ac-4370-b3a4-33d5e48b3648' AND bitOwned = 1
2026-10-21 21:37:03 . 38 - Common.Database.ExecuteScalar - 'SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='6585dba5-58ac-4370-b3a4-33d5e48b3648' AND bitOwned = 1'
2026-10-21 21:37:03 . 38 - TVDatabase.IsEpisodeRegistered - Close objConn
2026-10-21 21:37:03 . 38 - TVDatabase.GetLocalEpisode episode '6585dba5-58ac-4370-b3a4-33d5e48b3648'
2026-10-21 21:37:03 . 38 - TVDatabase.GetLocalEpisode - Open objConn
2026-10-21 21:37:03 . 38 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber,EG.intEpisodeNumber,EG.nvcOriginalTitle,EG.nvcProductionCode,EG.intAbsoluteNumber,EG.nvcDVDDiscId,EG.nvcDVDSeason,EG.nvcDVDEpisodeNumber,EG.nvcDVDChapter,EG.decTVDBRating,EG.guidSerie, EG.intAddType, EG.guidAddId,EG.datDataChanged,EG.bitLocked, EG.bitFoundInWebService, EG.bitEdited, EG.bitOnlyLocal, EG.bitOwned ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE L.guid = ELS.guidLanguage) as language,ELS.nvcName, ELS.nvcSortName,ELS.ntxOverview,ELS.datDataChanged, ELS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = ECS.guidCountry) as country,ECS.datFirstAired,ECS.datDataChanged, ECS.bitEdited ,EP.intRating,EP.nvcPath,EP.nvcMobileLocationPrimary,EP.nvcMobileLocationSecondary,EP.bitWatched,EP.datDataChanged,EP.datAdded, EG.[lngProgress], EG.[bitOnlyLocal] FROM tblEpisodeGlobal EG LEFT OUTER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodeCountrySpecific ECS on ECS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodePersonal EP on EP.guidEpisode = EG.[guid] WHERE EG.guid = '6585dba5-58ac-4370-b3a4-33d5e48b3648' ORDER BY ELS.bitAlternative ASC '
2026-10-21 21:37:03 . 39 - Common.Database.ExecuteReader - 'Select [nvcUser] As [User] ,[datDate] As Date ,[bitPriorTo] As Before ,[intState] As State ,[nvcNotes] As Notes ,[nvcHow] As How ,[guidSession] AS Session FROM [tblWatched] WHERE [guid] = '6585dba5-58ac-4370-b3a4-33d5e48b3648' ORDER BY [datDate]'
2026-10-21 21:37:03 . 39 - Common.Database.ExecuteReader - 'SELECT T.nvcLocalTitle, D.nvcLabel FROM tblTitles T INNER JOIN tblDiscs D on D.intTitle = T.intId INNER JOIN tblDiscTitles DT on DT.intDisc = D.intId WHERE DT.guidEpisode = '6585dba5-58ac-4370-b3a4-33d5e48b3648' '
2026-10-21 21:37:03 . 39 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = '6585dba5-58ac-4370-b3a4-33d5e48b3648''
2026-10-21 21:37:03 . 39 - Common.Database.ExecuteReader - 'SELECT EP.intPerson,EP.nvcCharacter,EP.intSort,EP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblEpisodePersons EP INNER JOIN tblPersons P on P.intId = EP.intPerson WHERE EP.guidEpisode = '6585dba5-58ac-4370-b3a4-33d5e48b3648''
2026-10-21 21:37:03 . 39 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[nvcSortName],[ntxOverview],ELS.datDataChanged FROM [My Movies].[dbo].[tblEpisodeGlobal] EG INNER JOIN [tblEpisodeLanguageSpecific] ELS on EG.guid = ELS.guidEpisode WHERE EG.guid = '6585dba5-58ac-4370-b3a4-33d5e48b3648' AND ELS.bitAlternative = 1 '
2026-10-21 21:37:03 . 40 - TVDatabase.GetLocalEpisode - Close objConn
2026-10-21 21:37:03 . 41 - Common.GetImageFromDatabase - 'Photos\507f05f1-7db6-4ea1-bc7e-23eedc9fe025.jpg'
2026-10-21 21:37:03 . 42 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 42 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\507f05f1-7db6-4ea1-bc7e-23eedc9fe025.jpg''
2026-10-21 21:37:03 . 42 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 43 - Common.GetImageFromDatabase - 'Photos\da515cad-53eb-4b60-911f-22aa96cfb7fc.jpg'
2026-10-21 21:37:03 . 43 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 43 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\da515cad-53eb-4b60-911f-22aa96cfb7fc.jpg''
2026-10-21 21:37:03 . 45 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 45 - Common.GetImageFromDatabase - 'Photos\c1ac9f4d-ffb5-4101-836d-0c21047d628c.jpg'
2026-10-21 21:37:03 . 45 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 46 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\c1ac9f4d-ffb5-4101-836d-0c21047d628c.jpg''
2026-10-21 21:37:03 . 46 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 47 - Common.GetImageFromDatabase - 'Photos\1da92a04-ed59-489e-ba6f-fb2b421555dd.jpg'
2026-10-21 21:37:03 . 47 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 47 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\1da92a04-ed59-489e-ba6f-fb2b421555dd.jpg''
2026-10-21 20:37:03 . 50 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:37:03 . 59 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 68 - Common.GetImageFromDatabase - 'Photos\073b3118-fbe2-4022-8fe8-ec9638173f1d.jpg'
2026-10-21 21:37:03 . 68 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 68 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\073b3118-fbe2-4022-8fe8-ec9638173f1d.jpg''
2026-10-21 21:37:03 . 69 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 69 - Common.GetImageFromDatabase - 'Photos\d61917b6-8308-4029-8256-42d2474540d6.jpg'
2026-10-21 21:37:03 . 70 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 70 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\d61917b6-8308-4029-8256-42d2474540d6.jpg''
2026-10-21 21:37:03 . 71 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 72 - Common.GetImageFromDatabase - 'Photos\ee18ca76-f70c-485a-85fb-71bc67f20a8a.jpg'
2026-10-21 21:37:03 . 72 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 72 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\ee18ca76-f70c-485a-85fb-71bc67f20a8a.jpg''
2026-10-21 21:37:03 . 73 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 73 - Common.GetImageFromDatabase - 'Photos\72b92612-d37f-49c1-829a-0239a8154f32.jpg'
2026-10-21 21:37:03 . 74 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 74 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\72b92612-d37f-49c1-829a-0239a8154f32.jpg''
2026-10-21 21:37:03 . 74 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 75 - Common.GetImageFromDatabase - 'Photos\88a35532-033d-477f-b792-d99217ffa11d.jpg'
2026-10-21 21:37:03 . 75 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 75 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\88a35532-033d-477f-b792-d99217ffa11d.jpg''
2026-10-21 21:37:03 . 79 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 81 - Common.GetImageFromDatabase - 'Photos\987951a6-8318-4b0f-a27b-441356e9769a.jpg'
2026-10-21 21:37:03 . 82 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 82 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\987951a6-8318-4b0f-a27b-441356e9769a.jpg''
2026-10-21 21:37:03 . 82 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 83 - Common.GetImageFromDatabase - 'Photos\8a587bc7-419a-49ac-b4ad-3e1f239e3136.jpg'
2026-10-21 21:37:03 . 83 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 83 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\8a587bc7-419a-49ac-b4ad-3e1f239e3136.jpg''
2026-10-21 21:37:03 . 84 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 84 - Common.GetImageFromDatabase - 'Photos\73574865-c578-414c-b665-fc1cb4a6f4b2.jpg'
2026-10-21 21:37:03 . 84 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 84 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\73574865-c578-414c-b665-fc1cb4a6f4b2.jpg''
2026-10-21 21:37:03 . 86 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 86 - Common.GetImageFromDatabase - 'Photos\2a50ae8a-aba8-4f4a-8d6f-061e8fdbb409.jpg'
2026-10-21 21:37:03 . 86 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 86 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\2a50ae8a-aba8-4f4a-8d6f-061e8fdbb409.jpg''
2026-10-21 21:37:03 . 87 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 88 - Common.GetImageFromDatabase - 'Photos\4daa1426-bb51-4866-af18-a4b8e5a06527.jpg'
2026-10-21 21:37:03 . 88 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 88 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'Photos\4daa1426-bb51-4866-af18-a4b8e5a06527.jpg''
2026-10-21 21:37:03 . 89 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 92 - Common.GetImageFromDatabase - 'TVImages\6585dba5-58ac-4370-b3a4-33d5e48b3648.jpg'
2026-10-21 21:37:03 . 92 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:03 . 92 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVImages\6585dba5-58ac-4370-b3a4-33d5e48b3648.jpg''
2026-10-21 21:37:03 . 93 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:03 . 99 - Common.Database.ExecuteReader - 'SELECT nvcName FROM tblCountries ORDER BY nvcName'
2026-10-21 21:37:04 . 26 - TVDatabase.EnsureWebServiceHandShake
2026-10-21 21:37:04 . 58 - TVService - Calling 'GetEpisodeCompletePercentage'
2026-10-21 21:37:04 . 89 - TVService - Returned
2026-10-21 21:37:04 . 91 - DiscTitleControl.LoadDisc
2026-10-21 21:37:04 . 93 - DiscTitleControl.CheckCompleteAgainstServer
2026-10-21 21:37:04 . 93 - DiscTitleControl.CheckCompleteAgainstServer - end
2026-10-21 21:37:04 . 94 - CollectionManagement.ChangeSelectedTitle - END
2026-10-21 21:37:05 . 03 - DiscTitleControl.CheckCompleteAgainstServer - DoWork running
2026-10-21 21:37:05 . 03 - Common.Database.ExecuteScalar - 'SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE intId = (SELECT intCountry FROM tblTitles WITH (NOLOCK) WHERE intId = 2)'
2026-10-21 21:37:05 . 03 - DiscTitleControl.CheckCompleteAgainstServer - WebService Id '4bd7501b-a936-415e-96eb-d55bb5abf834'
2026-10-21 21:37:05 . 11 - Common.OnlineService.Calls.LoadDiscTitleInformation - Calling 'LoadDiscTitleInformation', attempt 1 of 3.
2026-10-21 21:37:05 . 42 - Common.OnlineService.Calls.LoadDiscTitleInformation - Returning retrieved node.
2026-10-21 21:37:05 . 42 - DiscTitleControl.CheckCompleteAgainstServer - DoWork end
2026-10-21 21:37:05 . 42 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted running
2026-10-21 21:37:05 . 42 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted done
2026-10-21 21:37:08 . 35 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:37:08 . 38 - CollectionManagement.ChangeSelectedTitle - Row found
2026-10-21 21:37:08 . 44 - TVDatabase.GetLocalSerieOverviewByGuid - Open objConn
2026-10-21 21:37:08 . 44 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber, EG.intEpisodeNumber ,(SELECT TOP 1 nvcName FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = EG.guid ORDER BY CASE WHEN nvcName is null then 0 else 1 end desc, bitAlternative ASC) As nvcTitle,(SELECT TOP 1 nvcSortName FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = EG.guid ORDER BY CASE WHEN nvcSortName is null then 0 else 1 end desc, bitAlternative ASC) As nvcSortTitle, EG.guid, L.nvcCode, ELS.bitAlternative, EG.bitOwned, ECS.datFirstAired, EP.nvcPath, EG.intAddType, EG.guidAddId , CASE WHEN EG.guid IN ((SELECT guidEpisode FROM tblDiscTitles WITH (NOLOCK) WHERE guidEpisode IS NOT NULL) UNION ALL (SELECT guidEpisode FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode IS NOT NULL)) THEN 1 ELSE 0 END FROM tblEpisodeGlobal EG INNER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.guid INNER JOIN tblLanguages L WITH (NOLOCK) on ELS.guidLanguage = L.guid LEFT OUTER JOIN tblEpisodeCountrySpecific ECS WITH (NOLOCK) on ECS.guidEpisode = EG.guid LEFT OUTER JOIN tblEpisodePersonal EP WITH (NOLOCK) on EP.guidEpisode = EG.guid WHERE EG.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6' ORDER BY EG.intSeasonNumber ASC, EG.intEpisodeNumber ASC '
2026-10-21 21:37:08 . 49 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8') '
2026-10-21 21:37:08 . 50 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = '287d1d44-0a55-494a-836d-d2cbe2b712d8') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = '287d1d44-0a55-494a-836d-d2cbe2b712d8') '
2026-10-21 21:37:08 . 51 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = 'd8e99fe3-77fe-41a9-a57e-ce05498f5b36') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = 'd8e99fe3-77fe-41a9-a57e-ce05498f5b36') '
2026-10-21 21:37:08 . 52 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = 'f2737e57-aa90-4578-8317-11e984b89259') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = 'f2737e57-aa90-4578-8317-11e984b89259') '
2026-10-21 21:37:08 . 53 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = '1e5fb75d-b8dc-4f9f-b464-ec4fa9ee0158') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = '1e5fb75d-b8dc-4f9f-b464-ec4fa9ee0158') '
2026-10-21 21:37:08 . 54 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = '5486a027-e99f-4174-89a7-6a87fd3fe73d') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = '5486a027-e99f-4174-89a7-6a87fd3fe73d') '
2026-10-21 21:37:08 . 55 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = 'c2a154bf-d6bd-473d-83a2-a1b9f5927a78') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = 'c2a154bf-d6bd-473d-83a2-a1b9f5927a78') '
2026-10-21 21:37:08 . 56 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = '03ad2568-7fca-4203-a4bf-b73e631f876c') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = '03ad2568-7fca-4203-a4bf-b73e631f876c') '
2026-10-21 21:37:08 . 57 - Common.Database.ExecuteReader - '(SELECT D.intTitle FROM tblDiscs D WITH (NOLOCK) INNER JOIN tblDiscTitles DT WITH (NOLOCK) on DT.intDisc = D.intId WHERE DT.guidEpisode = '48dac4d9-72c1-4541-aeb0-bfd9a3fc047e') UNION ALL (SELECT intTitle FROM tblTitleEpisodes WITH (NOLOCK) WHERE guidEpisode = '48dac4d9-72c1-4541-aeb0-bfd9a3fc047e') '
2026-10-21 21:37:08 . 57 - TVDatabase.GetGroupId - Close objConn
2026-10-21 21:37:08 . 59 - Common.GetImageFromDatabase - 'TVBanners\d8167137-fb5f-4357-a57c-c33f8b32a3d6_S1.jpg'
2026-10-21 21:37:08 . 59 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:08 . 59 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVBanners\d8167137-fb5f-4357-a57c-c33f8b32a3d6_S1.jpg''
2026-10-21 21:37:08 . 61 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:08 . 61 - Common.GetImageFromDatabase - 'TVPosters\d8167137-fb5f-4357-a57c-c33f8b32a3d6_S1.jpg'
2026-10-21 21:37:08 . 61 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:08 . 61 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVPosters\d8167137-fb5f-4357-a57c-c33f8b32a3d6_S1.jpg''
2026-10-21 21:37:08 . 64 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:08 . 66 - DiscTitleControl.LoadDisc
2026-10-21 21:37:08 . 68 - DiscTitleControl.CheckCompleteAgainstServer
2026-10-21 21:37:08 . 68 - DiscTitleControl.CheckCompleteAgainstServer - end
2026-10-21 21:37:08 . 68 - CollectionManagement.ChangeSelectedTitle - END
2026-10-21 21:37:08 . 78 - DiscTitleControl.CheckCompleteAgainstServer - DoWork running
2026-10-21 21:37:08 . 78 - Common.Database.ExecuteScalar - 'SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE intId = (SELECT intCountry FROM tblTitles WITH (NOLOCK) WHERE intId = 2)'
2026-10-21 21:37:08 . 79 - DiscTitleControl.CheckCompleteAgainstServer - WebService Id '4bd7501b-a936-415e-96eb-d55bb5abf834'
2026-10-21 21:37:08 . 87 - Common.OnlineService.Calls.LoadDiscTitleInformation - Calling 'LoadDiscTitleInformation', attempt 1 of 3.
2026-10-21 21:37:09 . 17 - Common.OnlineService.Calls.LoadDiscTitleInformation - Returning retrieved node.
2026-10-21 21:37:09 . 17 - DiscTitleControl.CheckCompleteAgainstServer - DoWork end
2026-10-21 21:37:09 . 17 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted running
2026-10-21 21:37:09 . 18 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted done
2026-10-21 21:37:09 . 55 - CollectionManagement.ChangeSelectedTitle
2026-10-21 21:37:09 . 58 - CollectionManagement.ChangeSelectedTitle - Row found
2026-10-21 21:37:09 . 58 - TVDatabase.IsEpisodeRegistered - Transaction: 'False'
2026-10-21 21:37:09 . 59 - TVDatabase.IsEpisodeRegistered - Open objConn
2026-10-21 21:37:09 . 59 - SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1
2026-10-21 21:37:09 . 59 - Common.Database.ExecuteScalar - 'SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1'
2026-10-21 21:37:09 . 59 - TVDatabase.IsEpisodeRegistered - Close objConn
2026-10-21 21:37:09 . 65 - TVDatabase.IsEpisodeRegistered - Transaction: 'False'
2026-10-21 21:37:09 . 65 - TVDatabase.IsEpisodeRegistered - Open objConn
2026-10-21 21:37:09 . 65 - SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1
2026-10-21 21:37:09 . 65 - Common.Database.ExecuteScalar - 'SELECT COUNT(*) FROM tblEpisodeGlobal WHERE guid='17368189-c757-43d9-995d-0061915cd7b8' AND bitOwned = 1'
2026-10-21 21:37:09 . 65 - TVDatabase.IsEpisodeRegistered - Close objConn
2026-10-21 21:37:09 . 65 - TVDatabase.GetLocalEpisode episode '17368189-c757-43d9-995d-0061915cd7b8'
2026-10-21 21:37:09 . 67 - TVDatabase.GetLocalEpisode - Open objConn
2026-10-21 21:37:09 . 67 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber,EG.intEpisodeNumber,EG.nvcOriginalTitle,EG.nvcProductionCode,EG.intAbsoluteNumber,EG.nvcDVDDiscId,EG.nvcDVDSeason,EG.nvcDVDEpisodeNumber,EG.nvcDVDChapter,EG.decTVDBRating,EG.guidSerie, EG.intAddType, EG.guidAddId,EG.datDataChanged,EG.bitLocked, EG.bitFoundInWebService, EG.bitEdited, EG.bitOnlyLocal, EG.bitOwned ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE L.guid = ELS.guidLanguage) as language,ELS.nvcName, ELS.nvcSortName,ELS.ntxOverview,ELS.datDataChanged, ELS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = ECS.guidCountry) as country,ECS.datFirstAired,ECS.datDataChanged, ECS.bitEdited ,EP.intRating,EP.nvcPath,EP.nvcMobileLocationPrimary,EP.nvcMobileLocationSecondary,EP.bitWatched,EP.datDataChanged,EP.datAdded, EG.[lngProgress], EG.[bitOnlyLocal] FROM tblEpisodeGlobal EG LEFT OUTER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodeCountrySpecific ECS on ECS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodePersonal EP on EP.guidEpisode = EG.[guid] WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY ELS.bitAlternative ASC '
2026-10-21 21:37:09 . 67 - Common.Database.ExecuteReader - 'Select [nvcUser] As [User] ,[datDate] As Date ,[bitPriorTo] As Before ,[intState] As State ,[nvcNotes] As Notes ,[nvcHow] As How ,[guidSession] AS Session FROM [tblWatched] WHERE [guid] = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY [datDate]'
2026-10-21 21:37:09 . 67 - Common.Database.ExecuteReader - 'SELECT T.nvcLocalTitle, D.nvcLabel FROM tblTitles T INNER JOIN tblDiscs D on D.intTitle = T.intId INNER JOIN tblDiscTitles DT on DT.intDisc = D.intId WHERE DT.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8' '
2026-10-21 21:37:09 . 67 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:37:09 . 68 - Common.Database.ExecuteReader - 'SELECT EP.intPerson,EP.nvcCharacter,EP.intSort,EP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblEpisodePersons EP INNER JOIN tblPersons P on P.intId = EP.intPerson WHERE EP.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:37:09 . 68 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[nvcSortName],[ntxOverview],ELS.datDataChanged FROM [My Movies].[dbo].[tblEpisodeGlobal] EG INNER JOIN [tblEpisodeLanguageSpecific] ELS on EG.guid = ELS.guidEpisode WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' AND ELS.bitAlternative = 1 '
2026-10-21 21:37:09 . 68 - TVDatabase.GetLocalEpisode - Close objConn
2026-10-21 21:37:09 . 73 - Common.GetImageFromDatabase - 'TVImages\17368189-c757-43d9-995d-0061915cd7b8.jpg'
2026-10-21 21:37:09 . 73 - Common.GetImageFromDatabase - Open objConn
2026-10-21 21:37:09 . 74 - Common.Database.ExecuteReader - 'SELECT binData FROM tblFileStorage WITH (NOLOCK) WHERE nvcFileName = 'TVImages\17368189-c757-43d9-995d-0061915cd7b8.jpg''
2026-10-21 21:37:09 . 74 - Common.GetImageFromDatabase - Close objConn
2026-10-21 21:37:09 . 80 - Common.Database.ExecuteReader - 'SELECT nvcName FROM tblCountries ORDER BY nvcName'
2026-10-21 21:37:10 . 07 - TVDatabase.EnsureWebServiceHandShake
2026-10-21 21:37:10 . 39 - TVService - Calling 'GetEpisodeCompletePercentage'
2026-10-21 21:37:10 . 71 - TVService - Returned
2026-10-21 21:37:10 . 73 - DiscTitleControl.LoadDisc
2026-10-21 21:37:10 . 75 - DiscTitleControl.CheckCompleteAgainstServer
2026-10-21 21:37:10 . 75 - DiscTitleControl.CheckCompleteAgainstServer - end
2026-10-21 21:37:10 . 75 - DiscTitleControl.CheckCompleteAgainstServer - DoWork running
2026-10-21 21:37:10 . 75 - Common.Database.ExecuteScalar - 'SELECT nvcName FROM tblCountries WITH (NOLOCK) WHERE intId = (SELECT intCountry FROM tblTitles WITH (NOLOCK) WHERE intId = 2)'
2026-10-21 21:37:10 . 75 - CollectionManagement.ChangeSelectedTitle - END
2026-10-21 21:37:10 . 75 - DiscTitleControl.CheckCompleteAgainstServer - WebService Id '4bd7501b-a936-415e-96eb-d55bb5abf834'
2026-10-21 21:37:10 . 84 - Common.OnlineService.Calls.LoadDiscTitleInformation - Calling 'LoadDiscTitleInformation', attempt 1 of 3.
2026-10-21 21:37:11 . 14 - Common.OnlineService.Calls.LoadDiscTitleInformation - Returning retrieved node.
2026-10-21 21:37:11 . 15 - DiscTitleControl.CheckCompleteAgainstServer - DoWork end
2026-10-21 21:37:11 . 15 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted running
2026-10-21 21:37:11 . 15 - DiscTitleControl.CheckCompleteAgainstServer - workerCompleted done
2026-10-21 21:37:13 . 71 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:37:13 . 71 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:37:13 . 71 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:37:15 . 55 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:37:17 . 72 - Common.LogIn
2026-10-21 21:37:17 . 72 - Common.LogIn - Username and Password stored in registry
2026-10-21 21:37:17 . 72 - Common.EnsureWebServiceHandShake - Timeout '3'
2026-10-21 21:37:18 . 49 - Common.LogIn - Calling 'LoginV2' on WebService.
2026-10-21 21:37:18 . 80 - Common.LogIn - Logged in. Returning '7990f1f8-eaf6-416c-ba32-87decc6b99a8'
2026-10-21 21:37:19 . 18 - TVDatabase.GetLocalEpisode episode '17368189-c757-43d9-995d-0061915cd7b8'
2026-10-21 21:37:19 . 18 - TVDatabase.GetLocalEpisode - Open objConn
2026-10-21 21:37:19 . 18 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber,EG.intEpisodeNumber,EG.nvcOriginalTitle,EG.nvcProductionCode,EG.intAbsoluteNumber,EG.nvcDVDDiscId,EG.nvcDVDSeason,EG.nvcDVDEpisodeNumber,EG.nvcDVDChapter,EG.decTVDBRating,EG.guidSerie, EG.intAddType, EG.guidAddId,EG.datDataChanged,EG.bitLocked, EG.bitFoundInWebService, EG.bitEdited, EG.bitOnlyLocal, EG.bitOwned ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE L.guid = ELS.guidLanguage) as language,ELS.nvcName, ELS.nvcSortName,ELS.ntxOverview,ELS.datDataChanged, ELS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = ECS.guidCountry) as country,ECS.datFirstAired,ECS.datDataChanged, ECS.bitEdited ,EP.intRating,EP.nvcPath,EP.nvcMobileLocationPrimary,EP.nvcMobileLocationSecondary,EP.bitWatched,EP.datDataChanged,EP.datAdded, EG.[lngProgress], EG.[bitOnlyLocal] FROM tblEpisodeGlobal EG LEFT OUTER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodeCountrySpecific ECS on ECS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodePersonal EP on EP.guidEpisode = EG.[guid] WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY ELS.bitAlternative ASC '
2026-10-21 21:37:19 . 18 - Common.Database.ExecuteReader - 'Select [nvcUser] As [User] ,[datDate] As Date ,[bitPriorTo] As Before ,[intState] As State ,[nvcNotes] As Notes ,[nvcHow] As How ,[guidSession] AS Session FROM [tblWatched] WHERE [guid] = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY [datDate]'
2026-10-21 21:37:19 . 19 - Common.Database.ExecuteReader - 'SELECT T.nvcLocalTitle, D.nvcLabel FROM tblTitles T INNER JOIN tblDiscs D on D.intTitle = T.intId INNER JOIN tblDiscTitles DT on DT.intDisc = D.intId WHERE DT.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8' '
2026-10-21 21:37:19 . 19 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:37:19 . 19 - Common.Database.ExecuteReader - 'SELECT EP.intPerson,EP.nvcCharacter,EP.intSort,EP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblEpisodePersons EP INNER JOIN tblPersons P on P.intId = EP.intPerson WHERE EP.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:37:19 . 19 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[nvcSortName],[ntxOverview],ELS.datDataChanged FROM [My Movies].[dbo].[tblEpisodeGlobal] EG INNER JOIN [tblEpisodeLanguageSpecific] ELS on EG.guid = ELS.guidEpisode WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' AND ELS.bitAlternative = 1 '
2026-10-21 21:37:19 . 19 - TVDatabase.GetLocalEpisode - Close objConn
2026-10-21 20:37:27 . 59 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:37:28 . 72 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:37:28 . 72 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:37:28 . 72 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:37:39 . 65 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:37:44 . 07 - SetUserConfiguration - 'LastEpisodeDirectory', '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]', 'Collection Management'
2026-10-21 21:37:44 . 08 - TVEpisodeControl.CheckMove
2026-10-21 21:37:44 . 08 - TVEpisodeControl.CheckMove - File From '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]\Tulsa King [Season 1 Episode 01].iso' to ''
2026-10-21 21:37:44 . 10 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:37:44 . 10 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:37:44 . 10 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 21:37:46 . 46 - TVEpisodeControl.btnAddEpisode_Click - path set to: \\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]\Tulsa King [Season 1 Episode 01].iso
2026-10-21 21:37:46 . 46 - TVEpisodeControl.btnAddEpisode_Click -  txtFilePathValue: \\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]\Tulsa King [Season 1 Episode 01].iso
2026-10-21 21:37:46 . 46 - TVDatabase.UpdateEpisode
2026-10-21 21:37:46 . 47 - TVDatabase.UpdateEpisode - Open objConn
2026-10-21 21:37:46 . 48 - Language Inserted:
2026-10-21 21:37:46 . 49 - English
2026-10-21 21:37:46 . 49 - TVDatabase.LookupLanguageGuidFromLanguage - Language 'English' - Transaction: 'True'
2026-10-21 21:37:46 . 49 - TVDatabase.LookupCountryGrid - Country Name 'United States', Transaction: 'True'
2026-10-21 21:37:46 . 49 - TVDatabase.LookupCountryGrid - Returning 'True' from cache
2026-10-21 21:37:46 . 49 - Common.Database.ExecuteReader - 'SELECT guidEpisode FROM tblEpisodePersonal WITH (NOLOCK) WHERE guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:37:46 . 49 - TVDatabase.UpdateEpisode - personal parameter for sql call: nvcPath = '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]\Tulsa King [Season 1 Episode 01].iso'.
2026-10-21 21:37:46 . 49 - Common.Database.ExecuteNonQuery - 'UPDATE tblEpisodeGlobal SET [nvcOriginalTitle] = @OriginalTitle ,[intSeasonNumber] = @SeasonNumber ,[intEpisodeNumber] = @EpisodeNumber ,[nvcProductionCode] = @ProductionCode ,[intAbsoluteNumber] = @AbsoluteNumber ,[nvcDVDDiscId] = @DVDDiscId ,[nvcDVDSeason] = @DVDSeason ,[nvcDVDEpisodeNumber] = @DVDEpisodeNumber ,[nvcDVDChapter] = @DVDChapter ,[decTVDBRating] = @PublicRating ,[guidSerie] = @SerieGuid ,[intAddType] = @intAddType ,[guidAddId] = @guidAddId ,[datDataChanged] = @globalDataChanged ,[bitEdited] = @IsEdited WHERE guid = @EpisodeGuid DELETE FROM tblEpisodeLanguageSpecific WHERE [guidEpisode] = @EpisodeGuid INSERT INTO tblEpisodeLanguageSpecific([guidEpisode], [guidLanguage], [nvcName], [ntxOverview], [nvcSortName],[datDataChanged],[bitAlternative],[bitEdited])VALUES(@EpisodeGuid, @LanguageGuid, @Name, @Description, @SortName, @languageDataChanged, 1, @LanguageEdited) DELETE FROM tblEpisodeCountrySpecific WHERE [guidEpisode] = @EpisodeGuid INSERT INTO tblEpisodeCountrySpecific([guidEpisode], [guidCountry], [datFirstAired], [datDataChanged], [bitEdited])VALUES(@EpisodeGuid, @CountryGuid, @CountryFirstAired, @CountryDataChanged, @CountryEdited) UPDATE tblEpisodePersonal SET [nvcPath] =  @nvcPath ,[nvcMobileLocationPrimary] =  @nvcMobileLocationPrimary ,[nvcMobileLocationSecondary] =  @nvcMobileLocationSecondary ,[intRating] = @ownRating ,[bitWatched] = @Watched,[datAdded] = @datAdded,[datDataChanged] = @datDataChanged WHERE [guidEpisode] = @EpisodeGuid UPDATE tblEpisodeGlobal SET [lngProgress] = @lngProgress WHERE guid = @EpisodeGuid DELETE FROM tblWatched WHERE guid = '17368189-c757-43d9-995d-0061915cd7b8'DELETE FROM tblRemoteIDs WHERE guidItem = @EpisodeGuid DELETE FROM tblEpisodePersons WHERE guidEpisode = @EpisodeGuid INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Middle Aged Woman' ,77 ,1 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Salesman' ,85 ,2 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Carmine' ,57 ,3 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Security Guard Fred' ,17 ,4 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Maisie' ,53 ,5 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Bar Manager' ,89 ,6 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Bachelorette #1' ,91 ,7 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Bachelorette #2' ,96 ,8 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Bachelorette #3' ,101 ,9 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Grace' ,16 ,10 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Mario' ,41 ,11 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Pete ''The Rock'' Invernizzi' ,8 ,12 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Babe' ,18 ,13 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'ASAC Hendricks' ,19 ,14 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Donnie Shore' ,55 ,15 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Nico ''The Package'' Bugliosi' ,28 ,16 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Curtis' ,65 ,17 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Wade' ,68 ,18 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Melissa' ,70 ,19 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'Helen' ,72 ,20 ,1 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'' ,219 ,1 ,6 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'' ,197 ,1 ,7 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'' ,220 ,1 ,5 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'' ,159 ,1 ,2 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'' ,164 ,1 ,3 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'' ,221 ,2 ,6 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'' ,206 ,2 ,7 ) INSERT INTO tblEpisodePersons([guidEpisode],[nvcCharacter],[intPerson],[intSort],[intType])VALUES(@EpisodeGuid ,N'' ,165 ,2 ,3 ) '
2026-10-21 21:37:46 . 50 - Common.Database.ExecuteReader - 'SELECT nvcPath FROM tblEpisodePersonal WITH (NOLOCK) WHERE nvcPath is not NULL AND guidEpisode IN (SELECT guid FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6') '
2026-10-21 21:37:46 . 51 - TVDatabase.UpdateSeriePathsByEpisodes - Path '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]\Tulsa King [Season 1 Episode 01].iso'
2026-10-21 21:37:46 . 51 - TVDatabase.SetSeriePaths
2026-10-21 21:37:46 . 51 - Common.Database.ExecuteNonQuery - 'DELETE FROM tblSeriePaths WHERE guidSerie = @SerieGuid INSERT INTO tblSeriePaths([guidSerie],[nvcPath])VALUES(@SerieGuid, '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]') '
2026-10-21 21:37:46 . 51 - TVMetadata.FindAndSetSeriesPath
2026-10-21 21:37:46 . 51 - TVDatabase.GetSeriePaths
2026-10-21 21:37:46 . 51 - Common.Database.ExecuteReader - 'SELECT SP.nvcPath FROM tblSeriePaths SP WHERE SP.guidSerie = 'd8167137-fb5f-4357-a57c-c33f8b32a3d6''
2026-10-21 21:37:46 . 51 - TVDatabase.SetSeriesPath - Transaction: 'True'
2026-10-21 21:37:46 . 52 - Common.Database.ExecuteNonQuery - 'UPDATE [tblElementPersonal] SET nvcPath = '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]' WHERE guidElement='d8167137-fb5f-4357-a57c-c33f8b32a3d6' '
2026-10-21 21:37:46 . 52 - Common.QueueElementInfoStorage - Element Id '17368189-c757-43d9-995d-0061915cd7b8'.
2026-10-21 21:37:46 . 52 - Common.Database.ExecuteReader - 'SELECT guidElement FROM tblTitleInfoStorageQueue WITH (NOLOCK) WHERE nvcType = 'TVEpisode' AND guidElement = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:37:46 . 52 - Common.Database.ExecuteNonQuery - 'INSERT INTO tblTitleInfoStorageQueue (nvcType, intTitle, guidElement) VALUES ('TVEpisode', 0, '17368189-c757-43d9-995d-0061915cd7b8')'
2026-10-21 21:37:46 . 52 - TVDatabase.GetLocalEpisode episode '17368189-c757-43d9-995d-0061915cd7b8'
2026-10-21 21:37:46 . 52 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber,EG.intEpisodeNumber,EG.nvcOriginalTitle,EG.nvcProductionCode,EG.intAbsoluteNumber,EG.nvcDVDDiscId,EG.nvcDVDSeason,EG.nvcDVDEpisodeNumber,EG.nvcDVDChapter,EG.decTVDBRating,EG.guidSerie, EG.intAddType, EG.guidAddId,EG.datDataChanged,EG.bitLocked, EG.bitFoundInWebService, EG.bitEdited, EG.bitOnlyLocal, EG.bitOwned ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE L.guid = ELS.guidLanguage) as language,ELS.nvcName, ELS.nvcSortName,ELS.ntxOverview,ELS.datDataChanged, ELS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = ECS.guidCountry) as country,ECS.datFirstAired,ECS.datDataChanged, ECS.bitEdited ,EP.intRating,EP.nvcPath,EP.nvcMobileLocationPrimary,EP.nvcMobileLocationSecondary,EP.bitWatched,EP.datDataChanged,EP.datAdded, EG.[lngProgress], EG.[bitOnlyLocal] FROM tblEpisodeGlobal EG LEFT OUTER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodeCountrySpecific ECS on ECS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodePersonal EP on EP.guidEpisode = EG.[guid] WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY ELS.bitAlternative ASC '
2026-10-21 21:37:46 . 53 - Common.Database.ExecuteReader - 'Select [nvcUser] As [User] ,[datDate] As Date ,[bitPriorTo] As Before ,[intState] As State ,[nvcNotes] As Notes ,[nvcHow] As How ,[guidSession] AS Session FROM [tblWatched] WHERE [guid] = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY [datDate]'
2026-10-21 21:37:46 . 53 - Common.Database.ExecuteReader - 'SELECT T.nvcLocalTitle, D.nvcLabel FROM tblTitles T INNER JOIN tblDiscs D on D.intTitle = T.intId INNER JOIN tblDiscTitles DT on DT.intDisc = D.intId WHERE DT.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8' '
2026-10-21 21:37:46 . 53 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:37:46 . 53 - Common.Database.ExecuteReader - 'SELECT EP.intPerson,EP.nvcCharacter,EP.intSort,EP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblEpisodePersons EP INNER JOIN tblPersons P on P.intId = EP.intPerson WHERE EP.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:37:46 . 55 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[nvcSortName],[ntxOverview],ELS.datDataChanged FROM [My Movies].[dbo].[tblEpisodeGlobal] EG INNER JOIN [tblEpisodeLanguageSpecific] ELS on EG.guid = ELS.guidEpisode WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' AND ELS.bitAlternative = 1 '
2026-10-21 21:37:46 . 55 - Common.Database.ExecuteReader - 'SELECT datSynchronized FROM tblDatabase'
2026-10-21 21:37:46 . 55 - TVDatabase.IsEpisodeConnectedToDisc - Transaction: 'True'
2026-10-21 21:37:46 . 55 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN '17368189-c757-43d9-995d-0061915cd7b8' IN ((SELECT guidEpisode FROM tblDiscTitles) UNION ALL (SELECT guidEpisode FROM tblTitleEpisodes)) THEN 1 ELSE 0 END '
2026-10-21 21:37:46 . 55 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN (SELECT intAddType FROM tblEpisodeGlobal WITH (NOLOCK) WHERE guid = '17368189-c757-43d9-995d-0061915cd7b8') = 5 THEN 0 ELSE 1 END '
2026-10-21 21:37:46 . 55 - Common.Database.ExecuteScalar - 'SELECT CASE WHEN EXISTS (SELECT guidEpisode FROM tblEpisodePersonal WITH (NOLOCK) WHERE ISNULL(nvcPath, '') <> '') THEN 1 ELSE 0 END '
2026-10-21 21:37:46 . 56 - Common.MediaCenterShared.LoadEpisodePlayOptionsByEpisodeId - ID '17368189-c757-43d9-995d-0061915cd7b8'
2026-10-21 21:37:46 . 56 - Common.Database.ExecuteReader - 'SELECT TOP 1 nvcName FROM tblEpisodeLanguageSpecific WITH (NOLOCK) WHERE guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY CASE WHEN nvcName IS NULL THEN 0 ELSE 1 END DESC, bitAlternative ASC'
2026-10-21 21:37:46 . 56 - Common.Database.ExecuteReader - 'SELECT nvcPath FROM tblEpisodePersonal WITH (NOLOCK) WHERE guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8' AND ISNULL(nvcPath, '') <> '''
2026-10-21 21:37:46 . 56 - Common.MediaCenterShared.LoadEpisodePlayOptionsByEpisodeId - TV Episode path detected.
2026-10-21 21:37:46 . 56 - Common.MediaPlayers.GetEpisodePlayPath - Location is a file. Checking the type of media in it.
2026-10-21 21:37:46 . 56 - Common.MediaPlayers.GetEpisodePlayPath - Title is an image file. Trying to determine type.
2026-10-21 21:37:46 . 56 - Common.MediaPlayers.GetTitlePlayPaths - MediaInfo not found for item.
2026-10-21 21:37:46 . 57 - Common.MediaPlayers.GetEpisodePlayPath - ImageType not found as part of MediaInfo. Trying to determine.
2026-10-21 21:37:48 . 46 - Common.MediaPlayers.GetEpisodePlayPath - Files extracted to 'C:\ProgramData\My Movies\Temp\50fc5b26-1e44-4012-a1b5-f57b488ed610'.
2026-10-21 21:37:48 . 46 - Common.MediaPlayers.GetEpisodePlayPath - A index.bdmv file existed, the ISO is a Blu-ray.
2026-10-21 21:37:48 . 46 - Common.MediaPlayers.GetEpisodePlayPath - Determining location for path '\\server\Multimedia Library\Blu-ray\TV Shows and Mini-Series\Tulsa King\Tulsa King [Season 1]\Tulsa King [Season 1 Disc 01]\Tulsa King [Season 1 Episode 01].iso'
2026-10-21 21:37:48 . 46 - Common.MediaPlayers.GetEpisodePlayPath - Location: \\server\Multimedia Library
2026-10-21 21:37:48 . 46 - Common.Database.ExecuteReader - 'SELECT nvcValue FROM tblConfiguration WITH (NOLOCK) WHERE nvcType = 'Server' AND nvcPath = 'ExternalCredentials' AND nvcName = 'UserName-server''
2026-10-21 21:37:48 . 46 - Common.Database.ExecuteReader - 'SELECT nvcValue FROM tblConfiguration WITH (NOLOCK) WHERE nvcType = 'Server' AND nvcPath = 'ExternalCredentials' AND nvcName = 'Password-server''
2026-10-21 21:37:48 . 47 - Common.OnlineService.Calls.ChangeEpisodePersonalData - Calling 'ChangeTVEpisodeInCollectionExtended', attempt 1 of 3.
2026-10-21 21:37:49 . 05 - Common.OnlineService.Calls.ChangeEpisodePersonalData - Calling 'ChangeTVEpisodeInCollectionExtended', attempt 2 of 3.
2026-10-21 21:37:49 . 61 - Common.OnlineService.Calls.ChangeEpisodePersonalData - Calling 'ChangeTVEpisodeInCollectionExtended', attempt 3 of 3.
2026-10-21 21:37:50 . 18 - Common.OnlineService.Calls.ChangeEpisodePersonalData - The online service did not respond.
2026-10-21 21:37:50 . 18 - Common.OnlineService.Calls.ChangeEpisodePersonalData - Returning False.
2026-10-21 21:37:50 . 18 - TVMetadata.InsertSerie - Error! The tv episode could not be updated in the online service 'The online service could not be contacted'
2026-10-21 21:37:50 . 18 - TVMetadata.UpdateEpisode - Close objConn
2026-10-21 21:37:50 . 18 - TVEpisodeControl.btnAddEpisode_Click - update didn't succeed.
2026-10-21 20:37:51 . 70 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:37:59 . 13 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:37:59 . 13 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:37:59 . 13 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:38:03 . 76 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:38:14 . 15 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:38:14 . 15 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:38:14 . 15 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:38:15 . 85 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:38:27 . 89 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:38:29 . 16 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:38:29 . 16 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:38:29 . 16 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:38:39 . 95 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:38:44 . 17 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:38:44 . 17 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:38:44 . 17 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:38:52 . 00 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:38:59 . 18 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:38:59 . 18 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:38:59 . 18 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:39:04 . 04 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:39:14 . 20 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:39:14 . 20 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:39:14 . 20 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:39:16 . 09 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:39:28 . 16 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:39:29 . 21 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:39:29 . 21 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:39:29 . 22 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:39:40 . 23 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:39:44 . 21 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:39:44 . 21 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:39:44 . 21 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:39:52 . 26 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:39:59 . 22 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:39:59 . 22 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:39:59 . 22 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:40:04 . 32 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:40:14 . 25 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:40:14 . 25 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:40:14 . 25 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:40:16 . 37 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:40:28 . 43 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:40:29 . 27 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:40:29 . 27 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:40:29 . 27 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:40:40 . 49 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:40:44 . 29 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:40:44 . 29 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:40:44 . 29 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 21:40:46 . 65 - CollectionManagement.UnhandledThreadExceptionHandler - Arithmetic operation resulted in an overflow. -    at System.IntPtr.op_Explicit(IntPtr value)
   at MyMovies.SendMailTo.MAPI.GetRecipients(Int32& recipCount) in Y:\Documents\Visual Studio 2019\Projects\My Movies 5 SVN Check\My Movies - Collection\SendMailTo.vb:line 74
   at MyMovies.SendMailTo.MAPI.SendMail(String strSubject, String strBody, Int32 how) in Y:\Documents\Visual Studio 2019\Projects\My Movies 5 SVN Check\My Movies - Collection\SendMailTo.vb:line 43
   at MyMovies.SendMailTo.MAPI.SendMailPopup(String strSubject, String strBody) in Y:\Documents\Visual Studio 2019\Projects\My Movies 5 SVN Check\My Movies - Collection\SendMailTo.vb:line 26
   at MyMovies.CollectionManagement.mitDebugSendLog_Click(Object sender, EventArgs e) in Y:\Documents\Visual Studio 2019\Projects\My Movies 5 SVN Check\My Movies - Collection\Collection Management.vb:line 26299
   at System.Windows.Forms.ToolStripItem.RaiseEvent(Object key, EventArgs e)
   at System.Windows.Forms.ToolStripMenuItem.OnClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleClick(EventArgs e)
   at System.Windows.Forms.ToolStripItem.HandleMouseUp(MouseEventArgs e)
   at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.ToolStripDropDown.OnMouseUp(MouseEventArgs mea)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ToolStrip.WndProc(Message& m)
   at System.Windows.Forms.ToolStripDropDown.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
2026-10-21 20:40:52 . 54 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:40:59 . 29 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:40:59 . 29 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:40:59 . 30 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:41:04 . 59 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:41:14 . 29 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:41:14 . 30 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:41:14 . 30 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:41:16 . 76 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:41:28 . 84 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:41:29 . 32 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:41:29 . 32 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:41:29 . 32 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 21:41:38 . 50 - TVDatabase.GetLocalEpisode episode '17368189-c757-43d9-995d-0061915cd7b8'
2026-10-21 21:41:38 . 50 - TVDatabase.GetLocalEpisode - Open objConn
2026-10-21 21:41:38 . 50 - Common.Database.ExecuteReader - 'SELECT EG.intSeasonNumber,EG.intEpisodeNumber,EG.nvcOriginalTitle,EG.nvcProductionCode,EG.intAbsoluteNumber,EG.nvcDVDDiscId,EG.nvcDVDSeason,EG.nvcDVDEpisodeNumber,EG.nvcDVDChapter,EG.decTVDBRating,EG.guidSerie, EG.intAddType, EG.guidAddId,EG.datDataChanged,EG.bitLocked, EG.bitFoundInWebService, EG.bitEdited, EG.bitOnlyLocal, EG.bitOwned ,(SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE L.guid = ELS.guidLanguage) as language,ELS.nvcName, ELS.nvcSortName,ELS.ntxOverview,ELS.datDataChanged, ELS.bitEdited ,(SELECT C.nvcName FROM tblCountries C WITH (NOLOCK) WHERE C.guid = ECS.guidCountry) as country,ECS.datFirstAired,ECS.datDataChanged, ECS.bitEdited ,EP.intRating,EP.nvcPath,EP.nvcMobileLocationPrimary,EP.nvcMobileLocationSecondary,EP.bitWatched,EP.datDataChanged,EP.datAdded, EG.[lngProgress], EG.[bitOnlyLocal] FROM tblEpisodeGlobal EG LEFT OUTER JOIN tblEpisodeLanguageSpecific ELS on ELS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodeCountrySpecific ECS on ECS.guidEpisode = EG.[guid]LEFT OUTER JOIN tblEpisodePersonal EP on EP.guidEpisode = EG.[guid] WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY ELS.bitAlternative ASC '
2026-10-21 21:41:38 . 50 - Common.Database.ExecuteReader - 'Select [nvcUser] As [User] ,[datDate] As Date ,[bitPriorTo] As Before ,[intState] As State ,[nvcNotes] As Notes ,[nvcHow] As How ,[guidSession] AS Session FROM [tblWatched] WHERE [guid] = '17368189-c757-43d9-995d-0061915cd7b8' ORDER BY [datDate]'
2026-10-21 21:41:38 . 51 - Common.Database.ExecuteReader - 'SELECT T.nvcLocalTitle, D.nvcLabel FROM tblTitles T INNER JOIN tblDiscs D on D.intTitle = T.intId INNER JOIN tblDiscTitles DT on DT.intDisc = D.intId WHERE DT.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8' '
2026-10-21 21:41:38 . 51 - Common.Database.ExecuteReader - 'SELECT nvcRemoteId,nvcRemoteName FROM tblRemoteIDs WHERE guidItem = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:41:38 . 51 - Common.Database.ExecuteReader - 'SELECT EP.intPerson,EP.nvcCharacter,EP.intSort,EP.intType, P.nvcName, P.nvcWebServiceId , P.nvcImage, P.intImageWidth, P.intImageHeight FROM tblEpisodePersons EP INNER JOIN tblPersons P on P.intId = EP.intPerson WHERE EP.guidEpisode = '17368189-c757-43d9-995d-0061915cd7b8''
2026-10-21 21:41:38 . 51 - Common.Database.ExecuteReader - 'SELECT (SELECT L.nvcName FROM tblLanguages L WITH (NOLOCK) WHERE l.guid = [guidLanguage]) as language,[nvcName],[nvcSortName],[ntxOverview],ELS.datDataChanged FROM [My Movies].[dbo].[tblEpisodeGlobal] EG INNER JOIN [tblEpisodeLanguageSpecific] ELS on EG.guid = ELS.guidEpisode WHERE EG.guid = '17368189-c757-43d9-995d-0061915cd7b8' AND ELS.bitAlternative = 1 '
2026-10-21 21:41:38 . 52 - TVDatabase.GetLocalEpisode - Close objConn
2026-10-21 20:41:40 . 88 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:41:44 . 33 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:41:44 . 33 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:41:44 . 33 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:41:52 . 92 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:41:59 . 34 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:41:59 . 34 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:41:59 . 35 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:42:04 . 98 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:42:14 . 37 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:42:14 . 37 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:42:14 . 38 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:42:17 . 02 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:42:29 . 06 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:42:29 . 39 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:42:29 . 39 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:42:29 . 39 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:42:41 . 12 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:42:44 . 42 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:42:44 . 42 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:42:44 . 43 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:42:53 . 17 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:42:59 . 43 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:42:59 . 43 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:42:59 . 43 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:43:05 . 21 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:43:14 . 44 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:43:14 . 44 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:43:14 . 44 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:43:17 . 25 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:43:29 . 28 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:43:29 . 45 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:43:29 . 45 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:43:29 . 46 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:43:41 . 33 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:43:44 . 47 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:43:44 . 48 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:43:44 . 48 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:43:53 . 38 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:43:59 . 50 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:43:59 . 50 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:43:59 . 50 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:44:05 . 42 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:44:14 . 52 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:44:14 . 52 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:44:14 . 52 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:44:17 . 47 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 20:44:29 . 51 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:44:29 . 54 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:44:29 . 54 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:44:29 . 54 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:44:41 . 56 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:44:44 . 57 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:44:44 . 57 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:44:44 . 57 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:44:53 . 62 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:44:59 . 58 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:44:59 . 58 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:44:59 . 58 - WindowsConsole.UpdateAlerts - Close objConn
2026-10-21 20:45:05 . 67 - Common.Database.ExecuteNonQuery - 'UPDATE tblCollectionChanges SET nvcProcessClient = 'SERVER' WHERE ISNULL(nvcProcessClient, '') = '' AND DATEDIFF(SECOND, datTime, GETDATE()) >= 0'
2026-10-21 21:45:14 . 59 - WindowsConsole.UpdateAlerts - Open objConn
2026-10-21 21:45:14 . 59 - Common.Database.ExecuteReader - 'SELECT COUNT(*), nvcAlertType FROM tblServerAlerts WITH (NOLOCK) WHERE datExpires >= getdate() GROUP BY nvcAlertType '
2026-10-21 21:45:14 . 60 - WindowsConsole.UpdateAlerts - Close objConn