logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error

Options
Go to last post Go to first unread
dandersonMLT  
#1 Posted : Wednesday, July 24, 2019 10:55:10 AM(UTC)
dandersonMLT

Rank: Newbie

Groups: Developers
Joined: 4/30/2019(UTC)
Posts: 1

I have downloaded v9 final but I am getting errors attempting to install and convert Gold R10 Database.

The first error I receive is in /install/controllers/defaultcontroller.cs line 145 redirect to Configure2:

Quote:
System.Web.HttpException
HResult=0x80004005
Message=Cannot redirect after HTTP headers have been sent.
Source=AbleCommerce
StackTrace:
at AbleCommerce.Areas.Install.Controllers.DefaultController.Configure1(Configure1Model model) in
{Path}\Website\Areas\Install\Controllers\DefaultController.cs:line 145
at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.<BeginInvokeSynchronousActionMethod>b__39(IAsyncResult asyncResult, ActionInvocation innerInvokeState)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult asyncResult)
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3d()
at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f()






If I proceed, the 2nd error I receive is on /Install/Default/Upgrade?DBV=R10:


Quote:
SqlException (0x80131904): Invalid column name 'CatalogUrlId'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +2555926
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +5959200
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +285
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4169
System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +58
System.Data.SqlClient.SqlDataReader.get_MetaData() +89
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +430
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +2598
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +1483
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +64
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +240
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +41
System.Data.Common.DbCommand.ExecuteReader() +14
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(DbCommand cmd) +303
NHibernate.Loader.Loader.GetResultSet(DbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +257
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) +192
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies, IResultTransformer forcedResultTransformer) +129
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) +139

[GenericADOException: could not execute query
[ SELECT this_.RedirectId as redirectid1_89_0_, this_.StoreId as storeid2_89_0_, this_.SourceUrl as sourceurl3_89_0_, this_.LoweredSourceUrl as loweredsourceurl4_89_0_, this_.TargetUrl as targeturl5_89_0_, this_.UseRegEx as useregex6_89_0_, this_.CreatedDate as createddate7_89_0_, this_.LastVisitedDate as lastvisiteddate8_89_0_, this_.VisitCount as visitcount9_89_0_, this_.CatalogUrlId as catalogurlid10_89_0_, this_.OrderBy as orderby11_89_0_ FROM ac_Redirects this_ WHERE this_.StoreId = @p0 and this_.UseRegEx = @p1 ORDER BY this_.OrderBy asc ]
Name:cp0 - Value:CommerceBuilder.Stores.Store Name:cp1 - Value:True
[SQL: SELECT this_.RedirectId as redirectid1_89_0_, this_.StoreId as storeid2_89_0_, this_.SourceUrl as sourceurl3_89_0_, this_.LoweredSourceUrl as loweredsourceurl4_89_0_, this_.TargetUrl as targeturl5_89_0_, this_.UseRegEx as useregex6_89_0_, this_.CreatedDate as createddate7_89_0_, this_.LastVisitedDate as lastvisiteddate8_89_0_, this_.VisitCount as visitcount9_89_0_, this_.CatalogUrlId as catalogurlid10_89_0_, this_.OrderBy as orderby11_89_0_ FROM ac_Redirects this_ WHERE this_.StoreId = @p0 and this_.UseRegEx = @p1 ORDER BY this_.OrderBy asc]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters, IResultTransformer forcedResultTransformer) +226
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +20
NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) +76
NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) +368
NHibernate.Impl.CriteriaImpl.List(IList results) +49
NHibernate.Impl.CriteriaImpl.List() +58
CommerceBuilder.Seo.RedirectRepository.a(Boolean A_0, Int32 A_1, Int32 A_2, String A_3) +185
CommerceBuilder.Seo.RedirectRepository.LoadDynamicRedirects() +20
CommerceBuilder.Seo.RedirectService.InitializeCache() +85
CommerceBuilder.Seo.RedirectService.LocateRedirect(String sourceUrl) +725
CommerceBuilder.Essentials.RedirectionProcessingModule.a(HttpContext A_0, HttpRequest A_1) +362
CommerceBuilder.Essentials.RedirectionProcessingModule.b(Object A_0, EventArgs A_1) +174
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +141
System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +48
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +71




This error ends the install process and I am unable to proceed.
Any help would be greatly appreciated.

Thank you.

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.

judy at Web2Market  
#2 Posted : Wednesday, July 24, 2019 12:04:02 PM(UTC)
judy at Web2Market

Rank: Advanced Member

Groups: Developers
Joined: 11/7/2018(UTC)
Posts: 303

Thanks: 21 times
Was thanked: 5 time(s) in 5 post(s)
I upgraded an RC3 site to final release and got this error like you did: SqlException (0x80131904): Invalid column name 'CatalogUrlId'.]
I had to take the file AbleCommerce_Upgrade_ACGold_AC9.SQL from the Areas/Install/Content folder and run it on the SQL Server database and the site is up now.
mazhar  
#3 Posted : Thursday, July 25, 2019 6:30:08 AM(UTC)
mazhar

Rank: Administration

Groups: Admin, Administrators, HelpDesk, System, Authorized User, Developers, Registered
Joined: 10/5/2018(UTC)
Posts: 175

Thanks: 8 times
Was thanked: 17 time(s) in 15 post(s)
@dandersonMLT This seems to be happening where the redirection module is trying to intercept the upgrade request where it should not. The temporary workaround is to disable the redirection processing module during the upgrade and enable it back once you are upgraded.

1- edit your AbleCommerce.config file and locate the following module in it
Code:
<add name="Redirection Processing Module" type="CommerceBuilder.Essentials.RedirectionProcessingModule, CommerceBuilder" enabled="True" />

2- Now disable the module by setting enabled to false.
Code:
<add name="Redirection Processing Module" type="CommerceBuilder.Essentials.RedirectionProcessingModule, CommerceBuilder" enabled="False" />

3- Save the ablecommerce.config file.
4- Now try to upgrade using Gold database as per normal instructions.
5- After upgrade rollback the changes you made to disable the module.

Edited by user Thursday, July 25, 2019 6:30:39 AM(UTC)  | Reason: Not specified

Users browsing this topic
Guest (2)
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.