Solution: Episodes not showing up (1 Viewer)

[Iceken]

Hi,

I think this is a fairly common problem that sometimes for some reason somethings go wrong during the import .

One of the problems I was having was that all episodes got parsed correctly during the parsing test. The real import which links local episodes to online episodes however sometimes didn't work completly.
Luckily Inker uses a fairly transparent database scheme, so here is how I solved it:
(Warning, this is a fairly technical solution).

• FIRST BACKUP your current TVSeriesDatabase4.db3 file which is located in the 'Database' subfolder of your Mediaportal installation.
• 
  Go to SqlLite Database Browser and download the software.
• Open your TVSeriesDatabase4 with SQLiteBrowser.
• Go to the Execute SQL tab en execute the following:
  select * from local_episodes where SeriesID < 0
  This lists all your local episodes which aren correctly linked to online episodes.
  HOWEVER, this also tracks your 'special' series for which no info is found on tvdb.
• Scroll to the list en write down the SeriesID's (third column) of all ignorable Series.
• Execute select * from local_episodes where SeriesID < 0 and SeriesID not in (IgnoreID1, IgnoreID2, IgnoreID3)
  (Replace IgnoreID1 etc with your written ids.
  If this is the correct list (ie all episodes not showing up correct in MediaPortal) go to the next step, otherwise, repeat
• Execute delete from local_episodes where SeriesID < 0 and SeriesID not in (IgnoreID1, IgnoreID2, IgnoreID3)
  Press the save icon. WARNING: This really deletes items from the database.
• Start MediaPortal, the autoscan will kick in & import the items correctly.