TVSeries only shows last 5 series on first load... (1 Viewer)

[bobbyd87]

Ever since I upgraded to TVSeries 1.2, I have been having problems getting it to work as flawless as previous versions. I am using MP with the SVN dated 8-28 and am having the same problems with other versions as well. The first time that I start up mediaportal after a standby or after closing it, and going into TVSeries, only the last five or six series in my database load up. The only way i can get it to show the other 18 or so series is by hitting F9 and telling TVSeries to forcefully do a local scan which can take a while to do with 1400 videos.

Heres a bit of the log that doesnt repeat...

9/1/2007 7:21:32 PM - MPTVSeries Build: 1.2.0.0
9/1/2007 7:21:32 PM - Successfully opened database 'C:\Program Files\Team MediaPortal\MediaPortal\Database\TVSeriesDatabase4.db3'.
9/1/2007 7:21:32 PM - Loading Translations for en(us)
9/1/2007 7:21:32 PM - 54 translated Strings found
9/1/2007 7:21:32 PM - **** Plugin started in MediaPortal ***
9/1/2007 7:21:32 PM - Loading XML Skin: C:\Program Files\Team MediaPortal\MediaPortal\Skin\BlueTwo wide\TVSeries.xml
9/1/2007 7:21:33 PM - ***************************************************************************
9/1/2007 7:21:33 PM - ******************* Full Starting True - False   ***************************
9/1/2007 7:21:33 PM - ***************************************************************************
9/1/2007 7:21:36 PM - Searching for all supported videos files within E:\TV and it's subfolders.
9/1/2007 7:21:38 PM - Found 1416 supported video files.
9/1/2007 7:21:38 PM - ParseLocal starting, processing 1416 files...
9/1/2007 7:21:38 PM - Compiling Regex...
9/1/2007 7:21:38 PM - Compiled Regex sucessfuly, 6 valid Expressions found
9/1/2007 7:21:40 PM - ParseLocal finished..
9/1/2007 7:21:41 PM - Commit failed on this command: <update local_episodes SET LocalImportProcessed=1 where local_episodes.EpisodeFilename =

The last line repeats for almost as many files that I have in my database

hidden in there is this error too

(SQL:TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:Expression tree is too large (maximum depth 1000) query:update

I can attach my entire log file if needed... but its well over 400KB and just consists of the last line repeating 1400 times


Thanks

 

[unicr0n]

https://forum.team-mediaportal.com/expression_tree_too_large-t26344.html

Think this is the same issue.