home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Development
General Development (no feature request here!)
Solution: Episodes not showing up
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Iceken" data-source="post: 196819" data-attributes="member: 58253"><p>Hi,</p><p></p><p>I think this is a fairly common problem that sometimes for some reason somethings go wrong during the import <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" />.</p><p></p><p>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.</p><p>Luckily Inker uses a fairly transparent database scheme, so here is how I solved it: </p><p>(Warning, this is a fairly technical solution).</p><p></p><ul> <li data-xf-list-type="ul">FIRST BACKUP your current TVSeriesDatabase4.db3 file which is located in the 'Database' subfolder of your Mediaportal installation.</li> <li data-xf-list-type="ul"><br /> Go to <a href="http://sourceforge.net/projects/sqlitebrowser/" target="_blank">SqlLite Database Browser</a> and download the software.</li> <li data-xf-list-type="ul">Open your TVSeriesDatabase4 with SQLiteBrowser.</li> <li data-xf-list-type="ul">Go to the Execute SQL tab en execute the following:<br /> <em>select * from local_episodes where SeriesID < 0</em><br /> This lists all your local episodes which aren correctly linked to online episodes.<br /> HOWEVER, this also tracks your 'special' series for which no info is found on tvdb.</li> <li data-xf-list-type="ul">Scroll to the list en write down the SeriesID's (third column) of all ignorable Series.</li> <li data-xf-list-type="ul">Execute select * from local_episodes where SeriesID < 0 and SeriesID not in (IgnoreID1, IgnoreID2, IgnoreID3)<br /> (Replace IgnoreID1 etc with your written ids.<br /> If this is the correct list (ie all episodes not showing up correct in MediaPortal) go to the next step, otherwise, repeat <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" /></li> <li data-xf-list-type="ul">Execute delete from local_episodes where SeriesID < 0 and SeriesID not in (IgnoreID1, IgnoreID2, IgnoreID3)<br /> Press the save icon. WARNING: This really deletes items from the database.</li> <li data-xf-list-type="ul">Start MediaPortal, the autoscan will kick in & import the items correctly.</li> </ul></blockquote><p></p>
[QUOTE="Iceken, post: 196819, member: 58253"] 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). [LIST] [*]FIRST BACKUP your current TVSeriesDatabase4.db3 file which is located in the 'Database' subfolder of your Mediaportal installation. [*] Go to [url=http://sourceforge.net/projects/sqlitebrowser/]SqlLite Database Browser[/url] and download the software. [*]Open your TVSeriesDatabase4 with SQLiteBrowser. [*]Go to the Execute SQL tab en execute the following: [i]select * from local_episodes where SeriesID < 0[/i] 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. [/LIST] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Development
General Development (no feature request here!)
Solution: Episodes not showing up
Contact us
RSS
Top
Bottom
