Reply to thread

Message: <blockquote data-quote="rat6666" data-source="post: 1116029" data-attributes="member: 151007">Hi,I'm running into issues getting scheduled programs to record. Generally, SlimTV is working well. TV plays fine and instant record works. However, when the server checks for scheduled recordings I get an exception in the MP2-Server log and recordings fail(log file attached): [DEBUG] - scheduler: SchedulerWorker inner exception System.NotSupportedException: LINQ to Entities does not recognize the method 'System.DateTime AddMinutes(Double)' method, and this method cannot be translated into a store expression.I think it emanates from this function:Mediaportal.TV.Server.TVDatabase.TVBusinessLayer.ProgramManagement.RetrieveCurrentRunningByTitle[SPOILER="Exception"][2014-12-21 22:19:54,836] [4798  ] [scheduler thread] [DEBUG] - scheduler: SchedulerWorker inner exception System.NotSupportedException: LINQ to Entities does not recognize the method 'System.DateTime AddMinutes(Double)' method, and this method cannot be translated into a store expression.  at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.DefaultTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)  at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.BinaryTranslator.TypedTranslate(ExpressionConverter parent, BinaryExpression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.BinaryTranslator.TypedTranslate(ExpressionConverter parent, BinaryExpression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.BinaryTranslator.TypedTranslate(ExpressionConverter parent, BinaryExpression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TranslateLambda(LambdaExpression lambda, DbExpression input)  at System.Data.Objects.ELinq.ExpressionConverter.TranslateLambda(LambdaExpression lambda, DbExpression input, DbExpressionBinding& binding)  at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.OneLambdaTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, DbExpression& source, DbExpressionBinding& sourceBinding, DbExpression& lambda)  at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.OneLambdaTranslator.Translate(ExpressionConverter parent, MethodCallExpression call)  at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.SequenceMethodTranslator.Translate(ExpressionConverter parent, MethodCallExpression call, SequenceMethod sequenceMethod)  at System.Data.Objects.ELinq.ExpressionConverter.MethodCallTranslator.TypedTranslate(ExpressionConverter parent, MethodCallExpression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TypedTranslator`1.Translate(ExpressionConverter parent, Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.TranslateExpression(Expression linq)  at System.Data.Objects.ELinq.ExpressionConverter.Convert()  at System.Data.Objects.ELinq.ELinqQueryState.GetExecutionPlan(Nullable`1 forMergeOption)  at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)  at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()  at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)  at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)  at Mediaportal.TV.Server.TVDatabase.TVBusinessLayer.ProgramManagement.RetrieveCurrentRunningByTitle(String programName, Int32 preRecordInterval, Int32 postRecordInterval)  at Mediaportal.TV.Server.TVLibrary.Scheduler.Scheduler.IsTimeToRecordEveryTimeOnEveryChannel(Schedule schedule)  at Mediaportal.TV.Server.TVLibrary.Scheduler.Scheduler.IsTimeToRecord(Schedule schedule, DateTime currentTime, RecordingDetail& newRecording)  at Mediaportal.TV.Server.TVLibrary.Scheduler.Scheduler.StartAnyDueRecordings()  at Mediaportal.TV.Server.TVLibrary.Scheduler.Scheduler.DoScheduleWork()  at Mediaportal.TV.Server.TVLibrary.Scheduler.Scheduler.SchedulerWorker()[/SPOILER]containing the line: sb.AddConstraint(Operator.LessThanOrEquals, "startTime", DateTime.Now.AddMinutes(preRec));I know my away around github, but can't get my head around what bits come from where in the MP1 and MP2 repositories for building TVE3.5. Google reckons the common issue is with DateTime.AddMinutes not being compatible with the database query, and that Entity.DbFunctions.AddMinutes should be used instead, but the fix is dependant on the version of Entity Framework being used. Beyond my knowledge base really.I'm on windows 7 SP1, using just MP2 components (nativeTV with SQLite I assume).PS. MP2 is looking very good btw. Thanks.</blockquote>

Verification