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
FIXED: SQL-Error with latest svn
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="mmf" data-source="post: 215435" data-attributes="member: 55662"><p>Same issue here - although my skin is foofaraw...</p><p></p><p>Even reverting back to older SVNs and deleting the database didn't fix it. </p><p></p><p>18.12.2007 14:02:09 - Online Parsing done</p><p>18.12.2007 14:02:09 - Switching logical view to Unwatched</p><p>18.12.2007 14:02:09 - new listlevel: Series</p><p>18.12.2007 14:02:09 - Fanart: resetting to normal</p><p>18.12.2007 14:02:09 - Begin LoadFacade</p><p>18.12.2007 14:02:09 - LoadFacade: ListLevel: Series</p><p>18.12.2007 14:02:09 - LoadFacade: BeginDisplayLoopSeries: 14</p><p>18.12.2007 14:02:11 - Cache Initialized</p><p>18.12.2007 14:02:12 - new listlevel: Season</p><p>18.12.2007 14:02:12 - Selected: 78881</p><p>18.12.2007 14:02:12 - Fanart: Series selected</p><p>18.12.2007 14:02:12 - Fanart: resetting to normal</p><p>18.12.2007 14:02:12 - Begin LoadFacade</p><p>18.12.2007 14:02:12 - LoadFacade: ListLevel: Season</p><p>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_prepare16<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue :p" loading="lazy" data-shortname=":p" />vm=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 ).</p><p>18.12.2007 14:02:12 - LoadFacade: BeginDisplayLoopSeason: 0</p><p>18.12.2007 14:02:12 - Nothing to display, going out</p><p>18.12.2007 14:02:12 - new listlevel: Series</p><p>18.12.2007 14:02:12 - Begin LoadFacade</p><p>18.12.2007 14:02:12 - LoadFacade: ListLevel: Series</p><p>18.12.2007 14:02:12 - LoadFacade: BeginDisplayLoopSeries: 14</p><p>18.12.2007 14:02:12 - Fanart: resetting to normal</p><p>18.12.2007 14:02:13 - Searching for all supported videos files within and it's subfolders.</p><p>18.12.2007 14:02:13 - Found 0 supported video files.</p><p>18.12.2007 14:03:48 - Cleaning up cached, generated Logos</p></blockquote><p></p>
[QUOTE="mmf, post: 215435, member: 55662"] 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_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 = 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 [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
My TVSeries
FIXED: SQL-Error with latest svn
Contact us
RSS
Top
Bottom
