search

2sic / 2sxc

DNN + 2sxc = #DNNCMS - This tool helps web designers and developers prepare great looking content in DNN (DotNetNuke). It's like mixing DNN with Umbraco and Drupal :)
http://2sxc.org
MIT License
145 stars 40 forks source link

Exeption when converting 2sxc from8.x to 9.05.01 #1295

Closed Fraraven closed 7 years ago

Fraraven commented 7 years ago

I'm submitting a ... [x] bug report

...about
[x] other Conversion database after upgrade 2sxc from8.x to 9.05.01

Current behavior I did an update of from 2sxc 8 to 9.5 and I clicked on the button in a page to update the data. Afterwards I get an exception.

Error: System.Exception: Module upgrade did not complete (read more). Click to complete: Clicking again and again does not help.

When i look in the log it says " Module upgrade did not complete successfully. Please login as host user to finish the upgrade." But I am logged-in as an host user. Also in the logfile is And a second type of error is Sequence contains no elements

ERROR 1 AbsoluteURL:/Default.aspx DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke ExceptionGUID:918c088b-baf0-47bd-a16e-581339505e7d AssemblyVersion: PortalId:-1 UserId:-1 TabId:-1 RawUrl: Referrer: UserAgent: ExceptionHash:ftfNH8SDauOpGOlCSV3QCCiqIxU= Message:Module upgrade did not complete successfully. Please login as host user to finish the upgrade. StackTrace: InnerMessage: InnerStackTrace: Source: FileName: FileLineNumber:0 FileColumnNumber:0 Method: Server Name: Walraven

ERROR 2 AbsoluteURL:/API/2sxc/view/module/finishinstallation DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke ExceptionGUID:b27a5df3-ad5a-44f6-bbbe-eae41c9b7ec8 AssemblyVersion: PortalId:-1 UserId:-1 TabId:-1 RawUrl: Referrer: UserAgent: ExceptionHash:eDcsmgsXyFHqFtoZ5LNsmmGxXv4= Message:Sequence contains no elements StackTrace: at System.Linq.Enumerable.Single[TSource](IEnumerable1 source) at lambda_method(Closure , QueryContext ) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.<>c__DisplayClass20_01.b0(QueryContext qc) at Microsoft.EntityFrameworkCore.Query.Internal.QueryCompiler.Execute[TResult](Expression query) at Microsoft.EntityFrameworkCore.Query.Internal.EntityQueryProvider.Execute[TResult](Expression expression) at System.Linq.Queryable.Single[TSource](IQueryable1 source, Expression1 predicate) at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.GetAttribute(Int32 attributeSetId, Int32 attributeId, String name) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 50 at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.AttributeId(Int32 setId, String staticName) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 57 at ToSic.Eav.Repository.Efc.Parts.DbAttributeDefinition.GetOrCreateAttributeDefinition(Int32 contentTypeId, AttributeDefinition newAtt) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbAttributeDefinition.cs:line 42 at ToSic.Eav.Repository.Efc.Parts.DbContentType.ExtendSaveContentTypes(ContentType contentType, SaveOptions saveOptions) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbContentType_Modify.cs:line 113 at ToSic.Eav.Repository.Efc.Parts.DbContentType.<>c__DisplayClass13_0.b1(ContentType ct) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbContentType_Modify.cs:line 99 at System.Collections.Generic.List1.ForEach(Action1 action) at ToSic.Eav.Repository.Efc.Parts.DbContentType.<>cDisplayClass13_0.b0() in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbContentType_Modify.cs:line 99 at ToSic.Eav.Repository.Efc.Parts.DbRelationship.DoWhileQueueingRelationships(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbRelationship.cs:line 18 at ToSic.Eav.Repository.Efc.Parts.DbContentType.ExtendSaveContentTypes(List1 contentTypes, SaveOptions saveOptions) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbContentType_Modify.cs:line 99 at ToSic.Eav.Repository.Efc.DbDataController.Save(List1 contentTypes, SaveOptions saveOptions) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\DbDataController.cs:line 268 at ToSic.Eav.Apps.ImportExport.Import.MergeAndSaveContentTypes(List`1 contentTypes) at ToSic.Eav.Apps.ImportExport.Import.<>cDisplayClass7_0.b2() at ToSic.Eav.Repository.Efc.Parts.DbVersioning.QueueDuringAction(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\Parts\DbVersioning.cs:line 55 at ToSic.Eav.Repository.Efc.DbDataController.DoWhileQueuingVersioning(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\DbDataController.cs:line 262 at ToSic.Eav.Apps.ImportExport.Import.<>cDisplayClass7_0.b1() at ToSic.Eav.Repository.Efc.DbDataController.DoInTransaction(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\DbDataController.cs:line 242 at ToSic.Eav.Apps.ImportExport.Import.<>cDisplayClass7_0.b0() at ToSic.Eav.Repository.Efc.DbDataController.DoWithDelayedCacheInvalidation(Action action) in C:\Projects\eav-server\ToSic.Eav.Repository.Efc\DbDataController.cs:line 255 at ToSic.Eav.Apps.ImportExport.Import.ImportIntoDb(IEnumerable1 newAttributeSets, IEnumerable1 newEntities) at ToSic.Eav.Apps.ImportExport.XmlImportWithFiles.ImportXml(Int32 zoneId, Int32 appId, XDocument doc, Boolean leaveExistingValuesUntouched) at ToSic.SexyContent.Installer.Helpers.ImportXmlSchemaOfVersion(String version, Boolean leaveOriginalsUntouched) in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\Helpers.cs:line 59 at ToSic.SexyContent.Installer.InstallationController.UpgradeModule(String version) in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\InstallationController.cs:line 184 at ToSic.SexyContent.Installer.InstallationController.FinishAbortedUpgrade() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\SexyContent\Installer\InstallationController.cs:line 217 at ToSic.SexyContent.WebApi.View.ModuleController.FinishInstallation() in C:\Projects\2SexyContent\Web\DesktopModules\ToSIC_SexyContent\Sxc WebApi\View\ModuleController.cs:line 301 at lambda_method(Closure , Object , Object[] ) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>cDisplayClass10.b9(Object instance, Object[] methodParameters) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.Execute(Object instance, Object[] arguments) at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary2 arguments, CancellationToken cancellationToken) --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Tracing.ITraceWriterExtensions.d__181.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ApiControllerActionInvoker.d0.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Tracing.ITraceWriterExtensions.d18`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ActionFilterResult.d2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.d2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Filters.AuthorizationFilterAttribute.d2.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Web.Http.Controllers.ExceptionFilterResult.d0.MoveNext() InnerMessage: InnerStackTrace: Source:System.Core FileName: FileLineNumber:0 FileColumnNumber:0 Method:

Expected behavior data converted and page shows normal

Please tell us about your environment: Microsoft Windows NT 10.0.14393.0 Microsoft-IIS/10.0 NET FRAMEWORK VERSION: 4.0.30319.42000 Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Standard

2sxc version(s): 9.05.01
Browser: Chrome 60.0.3112.113 DNN: 9.1.1.129-232 Language: Dutch

iJungleboy commented 7 years ago

This one looks like it's something with your DB specifically. To me it sounds like it's fails at loading the DB data, because a content-type has fields defined, and something is wrong with whatever fields it got.

As this is a "personal" issue I'll close it (so it's not seen as an open global issue). I'm attaching a pre-release of 2sxc 9.5.2, which will show what IDs were used when the stuff failed. This should help you find the data in the DB to see what went wrong. 2sic_2SexyContent_09.05.02_Install.zip