[BUG] [MPExtended] is accessing non existent column in TVSeriesDatabase4 (1 Viewer)

Wiedmann

Portal Pro
June 22, 2007
107
28
Home Country
Germany Germany
Just look at the log. Current MP-TV series has been installed (first/vanilla installation).

Code:
2014-01-27 19:08:32.64000 [(23)] ERROR: Unhandled exception in service (SOAP interface)
MPExtended.Libraries.SQLitePlugin.QueryException: Failed to execute query
Query: SELECT e.CompositeID, e.EpisodeIndex, e.SeriesID, e.SeasonIndex, e.Watched, e.Rating, e.thumbFilename, e.FirstAired, GROUP_CONCAT(l.EpisodeFilename, '|') AS filename, MIN(l.FileDateAdded) AS dateAdded, e.GuestStars, e.Director, e.Writer, e.IMDB_ID, e.Summary, CASE WHEN LENGTH(TRIM(e.EpisodeName)) > 0 THEN e.EpisodeName ELSE l.LocalEpisodeName END AS name, MIN(ls.Parsed_Name) AS parsed_name, os.Pretty_Name AS pretty_name FROM online_episodes e INNER JOIN local_episodes l ON e.CompositeID = l.CompositeID OR e.CompositeID = l.CompositeID2 INNER JOIN online_series os ON os.ID = e.SeriesID INNER JOIN local_series ls ON ls.ID = e.SeriesID WHERE e.Hidden = 0 AND 1 GROUP BY e.EpisodeID, e.SeriesID, e.EpisodeName, e.EpisodeIndex, e.SeasonIndex, e.Watched, e.Rating, e.thumbFilename, e.FirstAired, e.GuestStars, e.Director, e.Writer ORDER BY e.FirstAired DESC LIMIT 0, 5
Database: C:\ProgramData\Team MediaPortal\MediaPortal\database\TVSeriesDatabase4.db3
---> System.Data.SQLite.SQLiteException (0x80004005): SQLite error
no such column: e.Rating
   bei System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   bei System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   bei System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   bei System.Data.SQLite.SQLiteDataReader.NextResult()
   bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   bei System.Data.SQLite.SQLiteCommand.ExecuteReader()
   bei MPExtended.Libraries.SQLitePlugin.Query..ctor(DatabaseConnection database, String query, SQLiteParameter[] parameters) in C:\Users\Oxan\Documents\Projects\MPExtended\Libraries\MPExtended.Libraries.SQLitePlugin\Query.cs:Zeile 47.
   --- End of inner exception stack trace ---
   bei MPExtended.Libraries.SQLitePlugin.Query..ctor(DatabaseConnection database, String query, SQLiteParameter[] parameters) in C:\Users\Oxan\Documents\Projects\MPExtended\Libraries\MPExtended.Libraries.SQLitePlugin\Query.cs:Zeile 51.
   bei MPExtended.Libraries.SQLitePlugin.LazyQuery`1.ExecuteQuery() in C:\Users\Oxan\Documents\Projects\MPExtended\Libraries\MPExtended.Libraries.SQLitePlugin\LazyQuery.cs:Zeile 141.
   bei MPExtended.Libraries.SQLitePlugin.LazyQuery`1.GetEnumerator() in C:\Users\Oxan\Documents\Projects\MPExtended\Libraries\MPExtended.Libraries.SQLitePlugin\LazyQuery.cs:Zeile 104.
   bei System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   bei System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   bei MPExtended.Services.MediaAccessService.Finalization.ForList[T](IEnumerable`1 list, Nullable`1 provider, ProviderType providerType) in C:\Users\Oxan\Documents\Projects\MPExtended\Services\MPExtended.Services.MediaAccessService\Finalization.cs:Zeile 37.
   bei MPExtended.Services.MediaAccessService.MediaAccessService.GetTVEpisodesDetailedByRange(Nullable`1 provider, Int32 start, Int32 end, Nullable`1 sort, Nullable`1 order) in C:\Users\Oxan\Documents\Projects\MPExtended\Services\MPExtended.Services.MediaAccessService\MediaAccessService.cs:Zeile 503.
   bei SyncInvokeGetTVEpisodesDetailedByRange(Object , Object[] , Object[] )
   bei System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
   bei System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage41(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
   bei System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
 

Users who are viewing this thread

Top Bottom