PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 5/23/2021 4:50 PM by  MooreCreative
Exception upgrading to HCC 3.5.0
 16 Replies
 1 Subscribed to this topic
 1 Subscribed to this forum
Sort:
You are not authorized to post a reply.
Page 2 of 4 << < 1234 > >>
Author Messages





Veteran Member






--
12/2/2020 4:41 PM
[quote=Scippy;1544]Do you mean hcc_StoreSettings table?
I've checked but nothing start with "AES"[/quote]
Ah, yes. I meant table, not folder. :)

For each store, there should be two records matching this query, beginning with Hotcakes Commerce 3.5.0.

[code=sql]SELECT * FROM [dbo].[hcc_StoreSettings] WHERE [SettingName] LIKE N'AES%' ORDER BY [StoreId], [SettingName];[/code]

Please try the following SQL script, then clear the site cache, and let me know if this resolves the issue. You'll want to run this for each store.

[code=sql]
SELECT * FROM [dbo].[hcc_StoreSettings] WHERE [SettingName] LIKE N'AES%' ORDER BY [SettingName];

DECLARE @StoreId INT, @AesValue NVARCHAR(MAX);
SET @StoreId = 1; -- default for a one-store instance
SET @AesValue = CAST(LEFT((CONVERT(decimal(30,0),(((RAND()*999999999999)/0.00012345671)*999999999))),16) AS nvarchar(16));

IF EXISTS (SELECT 1 FROM [dbo].[hcc_StoreSettings] WHERE [SettingName] = N'AESKey' AND [StoreId] = @StoreId)
BEGIN
UPDATE [dbo].[hcc_StoreSettings] SET [SettingValue] = @AesValue WHERE [SettingName] = N'AESKey' AND [StoreId] = @StoreId;
END
ELSE
BEGIN
INSERT INTO [dbo].[hcc_StoreSettings] ([StoreId], [SettingName], [SettingValue])
VALUES (@StoreId, N'AESKey', @AesValue);
END

IF EXISTS (SELECT 1 FROM [dbo].[hcc_StoreSettings] WHERE [SettingName] = N'AESInitVector' AND [StoreId] = @StoreId)
BEGIN
UPDATE [dbo].[hcc_StoreSettings] SET [SettingValue] = @AesValue WHERE [SettingName] = N'AESInitVector' AND [StoreId] = @StoreId;
END
ELSE
BEGIN
INSERT INTO [dbo].[hcc_StoreSettings] ([StoreId], [SettingName], [SettingValue])
VALUES (@StoreId, N'AESInitVector', @AesValue);
END

SELECT * FROM [dbo].[hcc_StoreSettings] WHERE [SettingName] LIKE N'AES%' ORDER BY [SettingName];
[/code]
Will Strohl, Upendo Ventures Hotcakes Cloud | Get Support | Code Support Official Cloud & Support provider for Hotcakes





Advanced Member






--
12/3/2020 7:28 AM
Yes! Now work fine! Thanks!!!
Is it possible to know more about this two new hcc_StoreSettings records AESInitVector and AESKey?





Veteran Member






--
12/3/2020 1:54 PM
[quote=Scippy;1546]Yes! Now work fine! Thanks!!!
Is it possible to know more about this two new hcc_StoreSettings records AESInitVector and AESKey?[/quote]

Those values are used to help secure the communications between the web browser and the server on the checkout page. I'm afraid that we won't say much more publicly about security-related things like this. :)
Will Strohl, Upendo Ventures Hotcakes Cloud | Get Support | Code Support Official Cloud & Support provider for Hotcakes





Advanced Member






--
2/25/2021 6:04 AM
[b]Hi Will,
I've five eshop in the same DNN 9.8.1 installation, all work fine but suddenly this error reappeared and now on all five eshops I have this error on the checkout page![/b]

Errore: Checkout non รจ attualmente disponibile. DotNetNuke.Services.Exceptions.ModuleLoadException: Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'. ---> System.Web.HttpException: Error executing child request for handler 'System.Web.Mvc.HttpHandlerUtil+ServerExecuteHttpHandlerAsyncWrapper'. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Hotcakes.Modules.Core.Controllers.CheckoutController.LoadCurrentCustomer(CheckoutViewModel model) at Hotcakes.Modules.Core.Controllers.CheckoutController.LoadCheckoutModel() at Hotcakes.Modules.Core.Controllers.CheckoutController.Index() at lambda_method(Closure , ControllerBase , Object[] ) 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.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.b__3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.c__DisplayClass48.b__41() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.c__DisplayClass48.b__41() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.c__DisplayClass48.b__41() at System.Web.Mvc.Async.AsyncControllerActionInvoker.c__DisplayClass33.b__32(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.c__DisplayClass21.c__DisplayClass2b.b__1c() at System.Web.Mvc.Async.AsyncControllerActionInvoker.c__DisplayClass21.b__1e(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End() at System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) at System.Web.Mvc.Controller.b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End() at System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) at System.Web.Mvc.Controller.b__15(IAsyncResult asyncResult, Controller controller) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End() at System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult) at System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.b__5(IAsyncResult asyncResult, ProcessRequestState innerState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResultBase`1.End() at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerAsyncWrapper.c__DisplayClassa.b__9() at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.c__DisplayClass4.b__3() at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap[TResult](Func`1 func) at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerWrapper.Wrap(Action action) at System.Web.Mvc.HttpHandlerUtil.ServerExecuteHttpHandlerAsyncWrapper.EndProcessRequest(IAsyncResult result) at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride) --- End of inner exception stack trace --- at System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride) at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage) at System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm) at System.Web.HttpServerUtilityWrapper.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm) at System.Web.Mvc.Html.ChildActionExtensions.ActionHelper(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues, TextWriter textWriter) at System.Web.Mvc.Html.ChildActionExtensions.Action(HtmlHelper htmlHelper, String actionName, String controllerName, RouteValueDictionary routeValues) at Hotcakes.Commerce.Dnn.Mvc.MvcRenderingEngine.Render(String controllerName, String actionName, String viewName, Object routeValues) at Hotcakes.Modules.Checkout.CheckoutView.RenderView() at Hotcakes.Commerce.Dnn.Web.HotcakesModuleBase.OnLoad(EventArgs e) --- End of inner exception stack trace ---

[b]I've checked AESInitVector and AESKey and all are setted for each shop, the error remains even if I delete all the contents of the Views/Checkout folder, so I think it is an error of the checkout module and not something in the views[/b]





Advanced Member






--
2/25/2021 8:04 AM
I have to correct myself, the problem appears only if I open the checkout page with the admin user, i.e. without a checkout process in progress. Maybe that's right?
You are not authorized to post a reply.
Page 2 of 4 << < 1234 > >>


Loading
  • Sign-up for the Hotcakes Community Newsletter: