FIXED: SQL-Error with latest svn (1 Viewer)

[Hawkeye]

Hi,

with latest svn I've got the following problem: If I want to enter a series nothing happens...

Skin: Blue Two

Logfile says:

Commit failed on this command: <select season.ID, season.SeriesID, season.SeasonIndex, season.BannerFileNames, season.CurrentBannerFileName, season.HasLocalFiles, season.HasLocalFilesTemp, season.HasOnlineEpisodes, season.HasOnlineEpisodesTemp, season.Hidden, season.ForomSubtitleRoot, season.UnwatchedItems from season left join local_episodes on season.seriesid = local_episodes.seriesid  and season.seasonindex = local_episodes.seasonindex left join online_episodes on local_episodes.compositeid = online_episodes.compositeid  where online_episodes.Watched = 0 and season.SeriesID = 76156 and season.HasOnlineEpisodes = 1 and season.Hidden = 0 and  exists( select online_episodes.EpisodeIndex from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID)  where online_episodes.SeriesID = season.SeriesID and online_episodes.SeasonIndex = season.SeasonIndex and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.SeriesID =  and local_episodes.SeasonIndex =  and local_episodes.CompositeID2 != '') union select online_episodes.EpisodeIndex from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID)  where online_episodes.SeriesID = season.SeriesID and online_episodes.SeasonIndex = season.SeasonIndex and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and local_episodes.CompositeID2 != '' ) and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 group by season.id  order by season.seasonIndex asc > (SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "and": syntax error query:select season.ID, season.SeriesID, season.SeasonIndex, season.BannerFileNames, season.CurrentBannerFileName, season.HasLocalFiles, season.HasLocalFilesTemp, season.HasOnlineEpisodes, season.HasOnlineEpisodesTemp, season.Hidden, season.ForomSubtitleRoot, season.UnwatchedItems from season left join local_episodes on season.seriesid = local_episodes.seriesid  and season.seasonindex = local_episodes.seasonindex left join online_episodes on local_episodes.compositeid = online_episodes.compositeid  where online_episodes.Watched = 0 and season.SeriesID = 76156 and season.HasOnlineEpisodes = 1 and season.Hidden = 0 and  exists( select online_episodes.EpisodeIndex from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID)  where online_episodes.SeriesID = season.SeriesID and online_episodes.SeasonIndex = season.SeasonIndex and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.SeriesID =  and local_episodes.SeasonIndex =  and local_episodes.CompositeID2 != '') union select online_episodes.EpisodeIndex from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID)  where online_episodes.SeriesID = season.SeriesID and online_episodes.SeasonIndex = season.SeasonIndex and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and local_episodes.CompositeID2 != '' ) and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 group by season.id  order by season.seasonIndex asc ).

Anyone else having this?

 

[spuck]

Anyone else having this?

Yep.. https://forum.team-mediaportal.com/showpost.php?p=213027&postcount=10 Please someone fix it.

 

[mmf]

Same issue here - although my skin is foofaraw...

Even reverting back to older SVNs and deleting the database didn't fix it.

18.12.2007 14:02:09 - Online Parsing done
18.12.2007 14:02:09 - Switching logical view to Unwatched
18.12.2007 14:02:09 - new listlevel: Series
18.12.2007 14:02:09 - Fanart: resetting to normal
18.12.2007 14:02:09 - Begin LoadFacade
18.12.2007 14:02:09 - LoadFacade: ListLevel: Series
18.12.2007 14:02:09 - LoadFacade: BeginDisplayLoopSeries: 14
18.12.2007 14:02:11 - Cache Initialized
18.12.2007 14:02:12 - new listlevel: Season
18.12.2007 14:02:12 - Selected: 78881
18.12.2007 14:02:12 - Fanart: Series selected
18.12.2007 14:02:12 - Fanart: resetting to normal
18.12.2007 14:02:12 - Begin LoadFacade
18.12.2007 14:02:12 - LoadFacade: ListLevel: Season
18.12.2007 14:02:12 - Commit failed on this command: <select season.ID, season.SeriesID, season.SeasonIndex, season.BannerFileNames, season.CurrentBannerFileName, season.HasLocalFiles, season.HasLocalFilesTemp, season.HasOnlineEpisodes, season.HasOnlineEpisodesTemp, season.Hidden, season.ForomSubtitleRoot, season.UnwatchedItems from season left join local_episodes on season.seriesid = local_episodes.seriesid and season.seasonindex = local_episodes.seasonindex left join online_episodes on local_episodes.compositeid = online_episodes.compositeid where online_episodes.Watched = 0 and season.SeriesID = 78881 and season.HasOnlineEpisodes = 1 and season.Hidden = 0 and exists( select online_episodes.EpisodeIndex from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) where online_episodes.SeriesID = season.SeriesID and online_episodes.SeasonIndex = season.SeasonIndex and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.SeriesID = and local_episodes.SeasonIndex = and local_episodes.CompositeID2 != '') union select online_episodes.EpisodeIndex from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) where online_episodes.SeriesID = season.SeriesID and online_episodes.SeasonIndex = season.SeasonIndex and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and local_episodes.CompositeID2 != '' ) and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 group by season.id order by season.seasonIndex asc > (SQLiteClient: TVSeriesDatabase4.db3 cmd:sqlite3_prepare16vm=null err:ERROR detailed:near "and": syntax error query:select season.ID, season.SeriesID, season.SeasonIndex, season.BannerFileNames, season.CurrentBannerFileName, season.HasLocalFiles, season.HasLocalFilesTemp, season.HasOnlineEpisodes, season.HasOnlineEpisodesTemp, season.Hidden, season.ForomSubtitleRoot, season.UnwatchedItems from season left join local_episodes on season.seriesid = local_episodes.seriesid and season.seasonindex = local_episodes.seasonindex left join online_episodes on local_episodes.compositeid = online_episodes.compositeid where online_episodes.Watched = 0 and season.SeriesID = 78881 and season.HasOnlineEpisodes = 1 and season.Hidden = 0 and exists( select online_episodes.EpisodeIndex from online_episodes left join local_episodes on (local_episodes.CompositeID=online_episodes.CompositeID) where online_episodes.SeriesID = season.SeriesID and online_episodes.SeasonIndex = season.SeasonIndex and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and online_episodes.CompositeID not in (select distinct local_episodes.CompositeID2 from local_episodes where local_episodes.SeriesID = and local_episodes.SeasonIndex = and local_episodes.CompositeID2 != '') union select online_episodes.EpisodeIndex from online_episodes left join local_episodes on (local_episodes.CompositeID2=online_episodes.CompositeID) where online_episodes.SeriesID = season.SeriesID and online_episodes.SeasonIndex = season.SeasonIndex and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 and local_episodes.CompositeID2 != '' ) and local_episodes.EpisodeFilename != '' and online_episodes.Hidden = 0 group by season.id order by season.seasonIndex asc ).
18.12.2007 14:02:12 - LoadFacade: BeginDisplayLoopSeason: 0
18.12.2007 14:02:12 - Nothing to display, going out
18.12.2007 14:02:12 - new listlevel: Series
18.12.2007 14:02:12 - Begin LoadFacade
18.12.2007 14:02:12 - LoadFacade: ListLevel: Series
18.12.2007 14:02:12 - LoadFacade: BeginDisplayLoopSeries: 14
18.12.2007 14:02:12 - Fanart: resetting to normal
18.12.2007 14:02:13 - Searching for all supported videos files within and it's subfolders.
18.12.2007 14:02:13 - Found 0 supported video files.
18.12.2007 14:03:48 - Cleaning up cached, generated Logos

 

[its_me_gb]

I'm also getting this, was just about to uninstall and reinstall mediaportal, then i saw this thread!

Happens in both B2 and SimpleMP.

Anyways, attatched is my MP-TVSeries.log

hope it helps!

gb

 

[zeflash]

goddamn! So basically everything I touched broke one way or another. And the funny (kind of) thing is that it worked fine here - but on MY special configuration, my existing DB, etc, etc.
OK, so now it should work better. Let me know if anyone see any of those SQL errors again.

That's build 261, and hopefully ... no I won't say anything.

 

[ThaClown]

Works now, well I can get to the episode listing, but I dont see any thumbnail screenshots... but maybe thats just a problem with my setup

 

[its_me_gb]

that will be because of the new option in the config:

Import Settings -> Online Data Sync -> Download Episode Snapshots.

Though i have noticed that the Tooltip for this option is the same as the download blank banners tooltip.

gb

 

[Hawkeye]

Yes, it's working again!

 

[ThaClown]

Thx its_me_gb, I missed that option totally.
Indeed all works great job guys!

Mmm weird, the TV logo's worked 1 time (for just 2 series with I was testing)
But now that I have deleted the TV Series DB and dit a rescan of all my 30 series no thumbnails are created...
The options is on, could it be a bug?

Logo's are working btw...