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
MediaPortal 1 Plugins
Popular Plugins
My TVSeries
BUG: large (3000+ episodes) NEW install imports FAIL
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="ltfearme" data-source="post: 263986" data-attributes="member: 52219"><p>I can reproduce the issue, I created 6000+ episodes using that tool <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></p><p></p><p>It seems to only occur when the Database first does not exist and you run the import imediately after.</p><p></p><p>Steps:</p><p>1. Delete *.db file from disk</p><p>2. Open Configuration Tool (db is created)</p><p>3. Enter in Import Path</p><p>4. Start Import</p><p></p><p>When it tries to Identity unknown series online, it takes roughly 60secs and series are not imported as already described.</p><p></p><p>It all seems ok if you do the following:</p><p></p><p>Steps:</p><p>1. Delete *.db file from disk</p><p>2. Open Configuration tool (db is created)</p><p>3. Enter in Import Paths</p><p>4. Close Configuration tool and Configuration.exe</p><p>5. Start Configuration tool</p><p>6. Start Import</p><p></p><p>Unknown Series are identified immediately and everything is imported OK</p><p></p><p>Looks like something to do with how the database is initialized.</p><p></p><p>------------------------------------------------------------------------------------</p><p></p><p>It appears the problem is that on initial creation of the database there is an exception when it tries to create the indicies:</p><p></p><p>m_db.Execute("create index if not exists epComp1 ON local_episodes(CompositeID ASC)");</p><p>m_db.Execute("create index if not exists epComp2 ON local_episodes(CompositeID2 ASC)");</p><p>m_db.Execute("create index if not exists seriesIDLocal on local_series(ID ASC)");</p><p>m_db.Execute("create index if not exists seriesIDOnlineEp on online_episodes(SeriesID ASC)");</p><p></p><p>It fails with an exception the first time because those particular tables do not exist. This is why it takes forever to execute a query with 3000+ rows. Just ends up returns 1 row with data as you see when it doesn't work.</p><p></p><p>If I set a breakpoint in the code before it tries to match the unknown series/episodes when those indicies don't exist it takes 60+ secs to return when using the SQL Lite Browser but it will return the correct data.</p><p></p><p>If I step through the code it will return with no error and wont come back with anything (*just gives up I guess*).</p><p></p><p>Guess the fix to implement is ensure that those indicies are created when the tables are created.</p><p></p><p>------------------------------------------------------------------------------------</p><p></p><p>Ok, I committed a new binary to SVN. Hopefully this was the cause of your problem.</p><p></p><p>Damien</p></blockquote><p></p>
[QUOTE="ltfearme, post: 263986, member: 52219"] I can reproduce the issue, I created 6000+ episodes using that tool :) It seems to only occur when the Database first does not exist and you run the import imediately after. Steps: 1. Delete *.db file from disk 2. Open Configuration Tool (db is created) 3. Enter in Import Path 4. Start Import When it tries to Identity unknown series online, it takes roughly 60secs and series are not imported as already described. It all seems ok if you do the following: Steps: 1. Delete *.db file from disk 2. Open Configuration tool (db is created) 3. Enter in Import Paths 4. Close Configuration tool and Configuration.exe 5. Start Configuration tool 6. Start Import Unknown Series are identified immediately and everything is imported OK Looks like something to do with how the database is initialized. ------------------------------------------------------------------------------------ It appears the problem is that on initial creation of the database there is an exception when it tries to create the indicies: m_db.Execute("create index if not exists epComp1 ON local_episodes(CompositeID ASC)"); m_db.Execute("create index if not exists epComp2 ON local_episodes(CompositeID2 ASC)"); m_db.Execute("create index if not exists seriesIDLocal on local_series(ID ASC)"); m_db.Execute("create index if not exists seriesIDOnlineEp on online_episodes(SeriesID ASC)"); It fails with an exception the first time because those particular tables do not exist. This is why it takes forever to execute a query with 3000+ rows. Just ends up returns 1 row with data as you see when it doesn't work. If I set a breakpoint in the code before it tries to match the unknown series/episodes when those indicies don't exist it takes 60+ secs to return when using the SQL Lite Browser but it will return the correct data. If I step through the code it will return with no error and wont come back with anything (*just gives up I guess*). Guess the fix to implement is ensure that those indicies are created when the tables are created. ------------------------------------------------------------------------------------ Ok, I committed a new binary to SVN. Hopefully this was the cause of your problem. Damien [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
My TVSeries
BUG: large (3000+ episodes) NEW install imports FAIL
Contact us
RSS
Top
Bottom