Skip to content

Instantly share code, notes, and snippets.

@bleroy
Created April 1, 2015 22:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bleroy/a85501182dfd77e243aa to your computer and use it in GitHub Desktop.
Save bleroy/a85501182dfd77e243aa to your computer and use it in GitHub Desktop.
CodePlex Issue #16375 Plain Text Attachments
Server Error in '/' Application.
--------------------------------------------------------------------------------
An overflow occurred while converting to datetime.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlServerCe.SqlCeException: An overflow occurred while converting to datetime.
Source Error:
[No relevant source lines]
Source File: DefaultContentQuery.cs Line: 139
Stack Trace:
[SqlCeException (0x80004005): An overflow occurred while converting to datetime.]
System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) +50
System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor) +347
System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) +665
System.Data.SqlServerCe.SqlCeCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +12
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +290
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +264
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +186
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +70
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +116
[ADOException: could not execute query
[ SELECT this_.Id as Id349_3_, this_.Number as Number349_3_, this_.Published as Published349_3_, this_.Latest as Latest349_3_, this_.Data as Data349_3_, this_.ContentItemRecord_id as ContentI6_349_3_, contentite1_.Id as Id348_0_, contentite1_.Data as Data348_0_, contentite1_.ContentType_id as ContentT3_348_0_, commonpart3_.Id as Id343_1_, commonpart3_.OwnerId as OwnerId343_1_, commonpart3_.CreatedUtc as CreatedUtc343_1_, commonpart3_.PublishedUtc as Publishe4_343_1_, commonpart3_.ModifiedUtc as Modified5_343_1_, commonpart3_.Container_id as Container6_343_1_, contenttyp2_.Id as Id350_2_, contenttyp2_.Name as Name350_2_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id inner join Common_CommonPartRecord commonpart3_ on contentite1_.Id=commonpart3_.Id inner join Orchard_Framework_ContentTypeRecord contenttyp2_ on contentite1_.ContentType_id=contenttyp2_.Id WHERE contenttyp2_.Name in (@p0) and commonpart3_.Container_id = @p1 and (commonpart3_.CreatedUtc >= @p2 and commonpart3_.CreatedUtc < @p3) and this_.Published = @p4 ORDER BY commonpart3_.CreatedUtc desc ]
Positional parameters: #0>BlogPost #1>Orchard.ContentManagement.Records.ContentItemRecord #2>1752/1/1 0:00:00 #3>1753/1/1 0:00:00 #4>True
[SQL: SELECT this_.Id as Id349_3_, this_.Number as Number349_3_, this_.Published as Published349_3_, this_.Latest as Latest349_3_, this_.Data as Data349_3_, this_.ContentItemRecord_id as ContentI6_349_3_, contentite1_.Id as Id348_0_, contentite1_.Data as Data348_0_, contentite1_.ContentType_id as ContentT3_348_0_, commonpart3_.Id as Id343_1_, commonpart3_.OwnerId as OwnerId343_1_, commonpart3_.CreatedUtc as CreatedUtc343_1_, commonpart3_.PublishedUtc as Publishe4_343_1_, commonpart3_.ModifiedUtc as Modified5_343_1_, commonpart3_.Container_id as Container6_343_1_, contenttyp2_.Id as Id350_2_, contenttyp2_.Name as Name350_2_ FROM Orchard_Framework_ContentItemVersionRecord this_ inner join Orchard_Framework_ContentItemRecord contentite1_ on this_.ContentItemRecord_id=contentite1_.Id inner join Common_CommonPartRecord commonpart3_ on contentite1_.Id=commonpart3_.Id inner join Orchard_Framework_ContentTypeRecord contenttyp2_ on contentite1_.ContentType_id=contenttyp2_.Id WHERE contenttyp2_.Name in (@p0) and commonpart3_.Container_id = @p1 and (commonpart3_.CreatedUtc >= @p2 and commonpart3_.CreatedUtc < @p3) and this_.Published = @p4 ORDER BY commonpart3_.CreatedUtc desc]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +213
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +18
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +79
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +557
NHibernate.Impl.CriteriaImpl.List(IList results) +42
NHibernate.Impl.CriteriaImpl.List() +58
Orchard.ContentManagement.DefaultContentQuery.Slice(Int32 skip, Int32 count) in DefaultContentQuery.cs:139
Orchard.ContentManagement.ContentQuery`1.Orchard.ContentManagement.IContentQuery<T>.List() in DefaultContentQuery.cs:184
Orchard.Blogs.Services.BlogPostService.Get(BlogPart blogPart, ArchiveData archiveData) +4444
Orchard.Blogs.Controllers.BlogPostController.ListByArchive(String blogPath, String archiveData) +924
lambda_method(Closure , ControllerBase , Object[] ) +135
System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +188
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
System.Web.Mvc.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() +56
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +267
System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +20
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +267
System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +20
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +267
System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +20
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +190
System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +329
System.Web.Mvc.Controller.ExecuteCore() +115
System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +94
System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10
System.Web.Mvc.<>c__DisplayClassb.<BeginProcessRequest>b__5() +37
System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +21
System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12
System.Web.Mvc.Async.WrappedAsyncResult`1.End() +55
System.Web.Mvc.<>c__DisplayClasse.<EndProcessRequest>b__d() +31
System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f) +7
System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action) +23
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +59
System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
Orchard.Mvc.Routes.HttpAsyncHandler.EndProcessRequest(IAsyncResult result) in ShellRoute.cs:148
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8841105
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +184
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Server Error in '/' Application.
The added or subtracted value results in an un-representable DateTime.
Parameter name: months
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.ArgumentOutOfRangeException: The added or subtracted value results in an un-representable DateTime.
Parameter name: months
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[ArgumentOutOfRangeException: The added or subtracted value results in an un-representable DateTime.
Parameter name: months]
System.DateTime.AddMonths(Int32 months) +2869059
System.DateTime.AddYears(Int32 value) +42
lambda_method(ExecutionScope ) +103
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0
System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +71
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +350
System.Delegate.DynamicInvokeImpl(Object[] args) +84
System.Delegate.DynamicInvoke(Object[] args) +7
NHibernate.Linq.Visitors.SubtreeEvaluator.Evaluate(Expression e) +205
NHibernate.Linq.Visitors.SubtreeEvaluator.Visit(Expression exp) +117
NHibernate.Linq.Visitors.ExpressionVisitor.VisitBinary(BinaryExpression b) +125
NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp) +229
NHibernate.Linq.Visitors.SubtreeEvaluator.Visit(Expression exp) +140
NHibernate.Linq.Visitors.ExpressionVisitor.VisitBinary(BinaryExpression b) +125
NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp) +229
NHibernate.Linq.Visitors.SubtreeEvaluator.Visit(Expression exp) +140
NHibernate.Linq.Visitors.ExpressionVisitor.VisitLambda(LambdaExpression lambda) +73
NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp) +684
NHibernate.Linq.Visitors.SubtreeEvaluator.Visit(Expression exp) +140
NHibernate.Linq.Visitors.ExpressionVisitor.VisitUnary(UnaryExpression u) +73
NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp) +164
NHibernate.Linq.Visitors.SubtreeEvaluator.Visit(Expression exp) +140
NHibernate.Linq.Visitors.ExpressionVisitor.VisitList(ReadOnlyCollection`1 original) +132
NHibernate.Linq.Visitors.ExpressionVisitor.VisitMethodCall(MethodCallExpression m) +117
NHibernate.Linq.Visitors.ExpressionVisitor.Visit(Expression exp) +619
NHibernate.Linq.Visitors.SubtreeEvaluator.Visit(Expression exp) +140
NHibernate.Linq.Visitors.SubtreeEvaluator.Eval(Expression exp) +42
NHibernate.Linq.Visitors.Evaluator.PartialEval(Expression expression, Func`2 fnCanBeEvaluated) +108
NHibernate.Linq.Visitors.Evaluator.PartialEval(Expression expression) +74
NHibernate.Linq.NHibernateQueryProvider.TranslateExpression(Expression expression) +45
Orchard.ContentManagement.DefaultContentQuery.Where(Expression`1 predicate) +537
Orchard.ContentManagement.ContentQuery`2.Orchard.ContentManagement.IContentQuery<T,TR>.Where(Expression`1 predicate) +147
Orchard.Blogs.Services.BlogPostService.Get(Blog blog, ArchiveData archiveData) +6503
Orchard.Blogs.Controllers.BlogPostController.ListByArchive(String blogSlug, String archiveData) +491
lambda_method(ExecutionScope , ControllerBase , Object[] ) +136
System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17
System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +178
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +24
System.Web.Mvc.<>c__DisplayClassd.<InvokeActionMethodWithFilters>b__a() +52
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +254
System.Web.Mvc.<>c__DisplayClassf.<InvokeActionMethodWithFilters>b__c() +19
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +254
System.Web.Mvc.<>c__DisplayClassf.<InvokeActionMethodWithFilters>b__c() +19
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +254
System.Web.Mvc.<>c__DisplayClassf.<InvokeActionMethodWithFilters>b__c() +19
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +254
System.Web.Mvc.<>c__DisplayClassf.<InvokeActionMethodWithFilters>b__c() +19
System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +192
System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +314
System.Web.Mvc.Controller.ExecuteCore() +105
System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +39
System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +7
System.Web.Mvc.<>c__DisplayClass8.<BeginProcessRequest>b__4() +34
System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +21
System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12
System.Web.Mvc.Async.WrappedAsyncResult`1.End() +59
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +44
System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +7
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8679150
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment