search

mwheelerjr / mptvseries

Automatically exported from code.google.com/p/mptvseries
0 stars 0 forks source link

Unable to add series to a view inside GUI #582

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Not sure if this is due to some manual edits done to the database on views, but 
at some point it stopped working where I can add a series to a view in GUI. It 
still works fine inside config when editing views.

The 'DAWN' view has no PIN and is enabled via Hyperlink, and following is 
debug+SQL snipplet of code that covers the final part showing the actions 
taken, entering plugin via basicHome, switching to view 'RON' (a rename of 'NO 
VIEW'), entering PIN, and then trying to add first show to a view via F9 (does 
not seem to log this):

00000001 - 5/13/2011 1:58:11 AM - MP-TVSeries Version: v3.0.3.1747
00000001 - 5/13/2011 1:58:11 AM - MP-TVSeries Build Date: 4/27/2011 6:06:52 PM
...
...
...
00000006 - 5/13/2011 1:58:31 AM - File Watcher: Starting File System Watcher 
Background Task
00000006 - 5/13/2011 1:58:36 AM - Executing SQL: select * from ImportPathes 
order by ID
00000006 - 5/13/2011 1:58:36 AM - Success, returned Rows: 4
00000001 - 5/13/2011 1:58:55 AM - OnPageLoad() started.
00000001 - 5/13/2011 1:58:55 AM - Executing SQL: SELECT sql FROM sqlite_master 
WHERE name='Views'
00000001 - 5/13/2011 1:58:55 AM - Success, returned Rows: 1
00000001 - 5/13/2011 1:58:55 AM - Executing SQL: select * from Views order by 
sort
00000001 - 5/13/2011 1:58:55 AM - Success, returned Rows: 6
00000001 - 5/13/2011 1:58:55 AM - Executing SQL: select value from options 
where property = 'DBViewsVersion'
00000001 - 5/13/2011 1:58:55 AM - Success, returned Rows: 1
00000001 - 5/13/2011 1:58:55 AM - Executing SQL: select * from Views where 
enabled = 1 order by sort
00000001 - 5/13/2011 1:58:55 AM - Success, returned Rows: 3
00000001 - 5/13/2011 1:58:55 AM - Switching view to DAWN
00000001 - 5/13/2011 1:58:55 AM - Executing SQL: select value from options 
where property = 'lastView'
00000001 - 5/13/2011 1:58:55 AM - Success, returned Rows: 1
00000001 - 5/13/2011 1:58:55 AM - Executing SQL: update options set value = 
'DAWN' where property = 'lastView'
00000001 - 5/13/2011 1:58:55 AM - Success, returned Rows: 1
00000001 - 5/13/2011 1:58:55 AM - LoadFacade: ListLevel: Series
00000001 - 5/13/2011 1:58:55 AM - Disabling native autoplay.
00000001 - 5/13/2011 1:58:55 AM - OnPageLoad() completed.
00000008 - 5/13/2011 1:58:55 AM - Begin Loading of Facade
00000008 - 5/13/2011 1:58:55 AM - View: Get Series Items
00000008 - 5/13/2011 1:58:55 AM - View: Get Series Items: Executing SQL
00000008 - 5/13/2011 1:58:55 AM - Executing SQL: select online_series.ID, 
online_series.Pretty_Name, online_series.SortName, online_series.Status, 
online_series.Genre, online_series.BannerFileNames, 
online_series.CurrentBannerFileName, online_series.PosterFileNames, 
online_series.PosterBannerFileName, online_series.Summary, 
online_series.OnlineDataImported, online_series.AirsDay, 
online_series.AirsTime, online_series.Actors, online_series.BannersDownloaded, 
online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, 
online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, 
online_series.isFavourite, online_series.WatchedFileTimeStamp, 
online_series.UnwatchedItems, online_series.EpisodeCount, 
online_series.EpisodesUnWatched, online_series.ViewTags, 
online_series.language, online_series.banner, online_series.FirstAired, 
online_series.IMDB_ID, online_series.zap2it_id, online_series.EpisodeOrders, 
online_series.choosenOrder, online_series.ContentRating, online_series.Network, 
online_series.NetworkID, online_series.Rating, online_series.Runtime, 
online_series.SeriesID, online_series.added, online_series.addedBy, 
online_series.fanart, online_series.lastupdated, online_series.poster, 
online_series.Parsed_Name, online_series.origName, 
online_series.EpisodeSortOrder, online_series.HasNewEpisodes, 
online_series.Pretty_Name__USEREDIT__, online_series.SortName__USEREDIT__, 
online_series.Network__USEREDIT__, online_series.RatingCount, 
online_series.TraktIgnore, local_series.Parsed_Name, local_series.ID, 
local_series.ScanIgnore, local_series.DuplicateLocalName, local_series.Hidden 
from online_series left join local_series on local_series.ID==online_series.ID 
where online_series.ViewTags like '%%|DAWN|%%' and 
local_series.DuplicateLocalName = 0 and local_series.Hidden = 0 order by 
upper(online_series.Pretty_Name)
00000008 - 5/13/2011 1:58:55 AM - Success, returned Rows: 57
00000008 - 5/13/2011 1:58:55 AM - Displaying 57 series
00000008 - 5/13/2011 1:58:55 AM - Executing SQL: select * from FormattingRules 
order by ID
00000008 - 5/13/2011 1:58:55 AM - Success, returned Rows: 34
00000008 - 5/13/2011 1:58:55 AM - Found and loaded 34 User Formatting Rules
00000001 - 5/13/2011 1:58:56 AM - Element Selection: 0
00000001 - 5/13/2011 1:58:56 AM - Watch: Started: 1 time(s) - Elapsed: 196ms 
(196785 µs) -> 196 ms (196785 µs)/start "FacadeLoading"
00000001 - 5/13/2011 1:58:56 AM - Watch: Started: 1 time(s) - Elapsed: 140ms 
(140986 µs) -> 140 ms (140986 µs)/start "FacadeLoading BG Thread"
00000001 - 5/13/2011 1:58:56 AM - Watch: Started: 1 time(s) - Elapsed: 116ms 
(116925 µs) -> 116 ms (116925 µs)/start "FacadeLoading getting/reporting 
items"
00000001 - 5/13/2011 1:58:56 AM - Watch: Started: 59 time(s) - Elapsed: 9ms 
(9174 µs) -> 0 ms (155 µs)/start "FacadeLoading changed"
00000001 - 5/13/2011 1:58:56 AM - Watch: Started: 1 time(s) - Elapsed: 0ms (686 
µs) -> 0 ms (686 µs)/start "FacadeMode - switch to List"
00000001 - 5/13/2011 1:58:56 AM - Watch: Started: 57 time(s) - Elapsed: 3ms 
(3672 µs) -> 0 ms (64 µs)/start "FacadeLoading addElem"
00000001 - 5/13/2011 1:58:56 AM - Background Load Facade Complete
00000001 - 5/13/2011 1:58:56 AM - Testing logos for item of type Series
00000001 - 5/13/2011 1:58:56 AM - Checking for Fanart on series: 3rd Rock from 
the Sun
00000001 - 5/13/2011 1:58:56 AM - Number of fanart found on disk: 3
00000001 - 5/13/2011 1:58:56 AM - Executing SQL: select * from Fanart where 
seriesID = 72389 and LocalPath != '' order by id
00000001 - 5/13/2011 1:58:56 AM - Success, returned Rows: 3
00000001 - 5/13/2011 1:58:56 AM - Found 3 Fanart from Database
00000001 - 5/13/2011 1:58:56 AM - Fanart found and loaded for series 3rd Rock 
from the Sun, loading: C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Fan 
Art\fanart\original\72389-4.jpg
00000001 - 5/13/2011 1:58:57 AM - Fanart found and loaded for series 3rd Rock 
from the Sun, loading: C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Fan 
Art\fanart\original\72389-4.jpg
00000001 - 5/13/2011 1:59:00 AM - View: RON is locked, prompting for PinCode
00000001 - 5/13/2011 1:59:03 AM - Switching view to RON
00000001 - 5/13/2011 1:59:03 AM - Fanart: Disabling Fanart Display
00000001 - 5/13/2011 1:59:03 AM - ImageSwapper: Clearing Properties
00000001 - 5/13/2011 1:59:03 AM - Executing SQL: update options set value = 
'RON' where property = 'lastView'
00000001 - 5/13/2011 1:59:03 AM - Success, returned Rows: 1
00000001 - 5/13/2011 1:59:03 AM - LoadFacade: ListLevel: Series
00000008 - 5/13/2011 1:59:03 AM - Begin Loading of Facade
00000008 - 5/13/2011 1:59:03 AM - View: Get Series Items
00000008 - 5/13/2011 1:59:03 AM - View: Get Series Items: Executing SQL
00000008 - 5/13/2011 1:59:03 AM - Executing SQL: select online_series.ID, 
online_series.Pretty_Name, online_series.SortName, online_series.Status, 
online_series.Genre, online_series.BannerFileNames, 
online_series.CurrentBannerFileName, online_series.PosterFileNames, 
online_series.PosterBannerFileName, online_series.Summary, 
online_series.OnlineDataImported, online_series.AirsDay, 
online_series.AirsTime, online_series.Actors, online_series.BannersDownloaded, 
online_series.HasLocalFiles, online_series.HasLocalFiles_Temp, 
online_series.GetEpisodesTimeStamp, online_series.UpdateBannersTimeStamp, 
online_series.isFavourite, online_series.WatchedFileTimeStamp, 
online_series.UnwatchedItems, online_series.EpisodeCount, 
online_series.EpisodesUnWatched, online_series.ViewTags, 
online_series.language, online_series.banner, online_series.FirstAired, 
online_series.IMDB_ID, online_series.zap2it_id, online_series.EpisodeOrders, 
online_series.choosenOrder, online_series.ContentRating, online_series.Network, 
online_series.NetworkID, online_series.Rating, online_series.Runtime, 
online_series.SeriesID, online_series.added, online_series.addedBy, 
online_series.fanart, online_series.lastupdated, online_series.poster, 
online_series.Parsed_Name, online_series.origName, 
online_series.EpisodeSortOrder, online_series.HasNewEpisodes, 
online_series.Pretty_Name__USEREDIT__, online_series.SortName__USEREDIT__, 
online_series.Network__USEREDIT__, online_series.RatingCount, 
online_series.TraktIgnore, local_series.Parsed_Name, local_series.ID, 
local_series.ScanIgnore, local_series.DuplicateLocalName, local_series.Hidden 
from online_series left join local_series on local_series.ID==online_series.ID 
where online_series.ViewTags = '' and local_series.DuplicateLocalName = 0 and 
local_series.Hidden = 0 order by upper(online_series.Pretty_Name)
00000008 - 5/13/2011 1:59:03 AM - Success, returned Rows: 62
00000008 - 5/13/2011 1:59:03 AM - Displaying 62 series
00000001 - 5/13/2011 1:59:03 AM - Element Selection: 0
00000001 - 5/13/2011 1:59:03 AM - Watch: Started: 1 time(s) - Elapsed: 64ms 
(64842 µs) -> 64 ms (64842 µs)/start "FacadeLoading"
00000001 - 5/13/2011 1:59:03 AM - Watch: Started: 1 time(s) - Elapsed: 42ms 
(42817 µs) -> 42 ms (42817 µs)/start "FacadeLoading BG Thread"
00000001 - 5/13/2011 1:59:03 AM - Watch: Started: 1 time(s) - Elapsed: 42ms 
(42016 µs) -> 42 ms (42016 µs)/start "FacadeLoading getting/reporting items"
00000001 - 5/13/2011 1:59:03 AM - Watch: Started: 64 time(s) - Elapsed: 2ms 
(2207 µs) -> 0 ms (34 µs)/start "FacadeLoading changed"
00000001 - 5/13/2011 1:59:03 AM - Watch: Started: 1 time(s) - Elapsed: 0ms (9 
µs) -> 0 ms (9 µs)/start "FacadeMode - switch to List"
00000001 - 5/13/2011 1:59:03 AM - Watch: Started: 62 time(s) - Elapsed: 0ms 
(141 µs) -> 0 ms (2 µs)/start "FacadeLoading addElem"
00000001 - 5/13/2011 1:59:03 AM - Watch: Started: 2 time(s) - Elapsed: 14ms 
(14786 µs) -> 7 ms (7393 µs)/start "add to TextureManager"
00000001 - 5/13/2011 1:59:03 AM - Background Load Facade Complete
00000001 - 5/13/2011 1:59:03 AM - Testing logos for item of type Series
00000001 - 5/13/2011 1:59:03 AM - Checking for Fanart on series: Afro Samurai
00000001 - 5/13/2011 1:59:03 AM - Number of fanart found on disk: 3
00000001 - 5/13/2011 1:59:03 AM - Executing SQL: select * from Fanart where 
seriesID = 79755 and LocalPath != '' order by id
00000001 - 5/13/2011 1:59:03 AM - Success, returned Rows: 3
00000001 - 5/13/2011 1:59:03 AM - Found 3 Fanart from Database
00000001 - 5/13/2011 1:59:03 AM - Fanart found and loaded for series Afro 
Samurai, loading: C:\ProgramData\Team MediaPortal\MediaPortal\Thumbs\Fan 
Art\fanart\original\79755-2.jpg
00000001 - 5/13/2011 1:59:05 AM - Checking whether assembly SubCentral is 
available and loaded...
00000001 - 5/13/2011 1:59:05 AM - Assembly SubCentral is not loaded (not 
available?), trying to load it manually...
00000001 - 5/13/2011 1:59:05 AM - Assembly SubCentral is unavailable, load 
unsuccessful: System.IO.FileNotFoundException:Could not load file or assembly 
'SubCentral' or one of its dependencies. The system cannot find the file 
specified.
00000001 - 5/13/2011 1:59:05 AM - Executing SQL: select value from options 
where property = 'onlineUserID'
00000001 - 5/13/2011 1:59:05 AM - Success, returned Rows: 1
00000031 - 5/13/2011 1:59:05 AM - [follw.it] Not connected.
00000001 - 5/13/2011 1:59:09 AM - Executing SQL: select * from Views where 
TaggedView = 1
00000001 - 5/13/2011 1:59:09 AM - Success, returned Rows: 3
00000001 - 5/13/2011 1:59:27 AM - OnPageDestroy() started.
00000001 - 5/13/2011 1:59:27 AM - OnPageDestroy() completed.
00000001 - 5/13/2011 1:59:28 AM - Removing all drives from Disk Watcher
00000001 - 5/13/2011 1:59:28 AM - Stopping Disk Watcher...
00000001 - 5/13/2011 1:59:28 AM - Successfully stopped Disk Watcher.
00000002 - 5/13/2011 1:59:28 AM - Cleaning up cached, generated Logos

Original issue reported on code.google.com by RoChess....@gmail.com on 13 May 2011 at 5:07

GoogleCodeExporter commented 9 years ago 
After manually editing the SQLite database to adjust the order of the views, 
everything works again. Not sure why that would be a factor, but I had to put 
the custom view at the end to make everything work again.

Original comment by RoChess....@gmail.com on 29 Jun 2011 at 2:28