Upgrade from 4.1 to 4.2 problem

Posted: June 10, 2019 at 4:02 PM Quote #237460
Hi,

we upgraded from 4.1 to 4.2 following the instructions and site is up and running with all the products visible in the public store but no products in the admin area.
Also missing is all customers and orders in the admin area.

Note: on the Dashboard number of orders and customers is correct as in database but we can not see any of them through the admin interface.

Anybody had this problem? What do you suggest we try to do? Thank you!
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: June 11, 2019 at 3:04 AM Quote #237486
Hello,

You are probably getting some error in the grid both in the products and order administration. You will most likely be able to see the error details in the system log (Administration -> System -> Log). Please share that with us for any further help.

Also, try to clear your browser cache and see if that makes a difference.

Hope that helps!

Regards,
Anton
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.Nop-Templates.com - the best place for nopCommerce themes and plugins

Follow us on
Facebook: http://www.facebook.com/NopTemplates
Twitter: http://twitter.com/NopTemplates
Blog: http://www.nop-templates.com/blog

www.Nop-Templates.com
nopCommerce Solution Partners
Posted: June 11, 2019 at 5:14 AM Quote #237494
We managed to get it working on one computer after clearing the cache but on the other it is still not working, I can not access the log either.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: June 11, 2019 at 5:36 AM Quote #237495
Hello

Please try to view sites in private/incognito window.
If you are not able to view the logs on admin may be if you have access change the logs at database level.
OR you can enable stdout logs in web.config and try to check logs in stdout folder of your website.

i think you will get some clue about issue.

if its working on one system then it should work on other system. Its looking strange.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Need any professional assistance? Drop us your requirements on [email protected]

http://www.satyanamsoft.com/
nopCommerce Solution Partner
Posted: June 11, 2019 at 7:47 AM Quote #237504
I enabled log and here is a log file

************************************************************

info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
      Entity Framework Core 2.2.4-servicing-10062 initialized 'NopObjectContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: MaxPoolSize=128 using lazy-loading proxies
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (56ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [t].[Id], [t].[Enabled], [t].[LastEndUtc], [t].[LastStartUtc], [t].[LastSuccessUtc], [t].[Name], [t].[Seconds], [t].[StopOnError], [t].[Type]
      FROM [ScheduleTask] AS [t]
      WHERE [t].[Enabled] = 1
      ORDER BY [t].[Seconds] DESC
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (4ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [s].[Id], [s].[CompanyAddress], [s].[CompanyName], [s].[CompanyPhoneNumber], [s].[CompanyVat], [s].[DefaultLanguageId], [s].[DisplayOrder], [s].[Hosts], [s].[Name], [s].[SslEnabled], [s].[Url]
      FROM [Store] AS [s]
      ORDER BY [s].[DisplayOrder], [s].[Id]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (66ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [s].[Id], [s].[Name], [s].[StoreId], [s].[Value]
      FROM [Setting] AS [s]
      ORDER BY [s].[Name], [s].[StoreId]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (77ms) [Parameters=[@p0='?' (DbType = DateTime2), @p1='?' (DbType = Int32), @p2='?' (Size = 4000), @p3='?' (Size = 200), @p4='?' (DbType = Int32), @p5='?' (Size = 4000), @p6='?' (Size = 4000), @p7='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
      SET NOCOUNT ON;
      INSERT INTO [Log] ([CreatedOnUtc], [CustomerId], [FullMessage], [IpAddress], [LogLevelId], [PageUrl], [ReferrerUrl], [ShortMessage])
      VALUES (@p0, @p1, @p2, @p3, @p4, @p5, @p6, @p7);
      SELECT [Id]
      FROM [Log]
      WHERE @@ROWCOUNT = 1 AND [Id] = scope_identity();
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [l].[Id], [l].[DefaultCurrencyId], [l].[DisplayOrder], [l].[FlagImageFileName], [l].[LanguageCulture], [l].[LimitedToStores], [l].[Name], [l].[Published], [l].[Rtl], [l].[UniqueSeoCode]
      FROM [Language] AS [l]
      WHERE [l].[Published] = 1
      ORDER BY [l].[DisplayOrder], [l].[Id]
Hosting environment: Production
Content root path: C:\Inetpub\vhosts\kinetafitness.com\httpdocs
Now listening on: http://127.0.0.1:7165
Application started. Press Ctrl+C to shut down.
info: Microsoft.AspNetCore.Hosting.Internal.WebHost[1]
      Request starting HTTP/1.1 GET http://kinetafitness.com/Admin/Order/List  
warn: Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware[1]
      AcceptLanguageHeaderRequestCultureProvider returned the following unsupported cultures 'en-US, en, bs'.
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[3]
      Route matched with {area = "Admin", action = "List", controller = "Order"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult List(System.Collections.Generic.List`1[System.Int32], System.Collections.Generic.List`1[System.Int32], System.Collections.Generic.List`1[System.Int32]) on controller Nop.Web.Areas.Admin.Controllers.OrderController (Nop.Web).
info: Microsoft.EntityFrameworkCore.Infrastructure[10403]
      Entity Framework Core 2.2.4-servicing-10062 initialized 'NopObjectContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: MaxPoolSize=128 using lazy-loading proxies
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (2ms) [Parameters=[@__email_0='?' (Size = 1000)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [c].[Id], [c].[Active], [c].[AdminComment], [c].[AffiliateId], [c].[BillingAddress_Id], [c].[CannotLoginUntilDateUtc], [c].[CreatedOnUtc], [c].[CustomerGuid], [c].[Deleted], [c].[Email], [c].[EmailToRevalidate], [c].[FailedLoginAttempts], [c].[HasShoppingCartItems], [c].[IsSystemAccount], [c].[IsTaxExempt], [c].[LastActivityDateUtc], [c].[LastIpAddress], [c].[LastLoginDateUtc], [c].[RegisteredInStoreId], [c].[RequireReLogin], [c].[ShippingAddress_Id], [c].[SystemName], [c].[Username], [c].[VendorId]
      FROM [Customer] AS [c]
      WHERE [c].[Email] = @__email_0
      ORDER BY [c].[Id]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [e].[Customer_Id], [e].[CustomerRole_Id]
      FROM [Customer_CustomerRole_Mapping] AS [e]
      WHERE [e].[Customer_Id] = @__get_Item_0
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [e].[Id], [e].[Active], [e].[DefaultTaxDisplayTypeId], [e].[EnablePasswordLifetime], [e].[FreeShipping], [e].[IsSystemRole], [e].[Name], [e].[OverrideTaxDisplayType], [e].[PurchasedWithProductId], [e].[SystemName], [e].[TaxExempt]
      FROM [CustomerRole] AS [e]
      WHERE [e].[Id] = @__get_Item_0
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__get_Item_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [e].[Id], [e].[Active], [e].[DefaultTaxDisplayTypeId], [e].[EnablePasswordLifetime], [e].[FreeShipping], [e].[IsSystemRole], [e].[Name], [e].[OverrideTaxDisplayType], [e].[PurchasedWithProductId], [e].[SystemName], [e].[TaxExempt]
      FROM [CustomerRole] AS [e]
      WHERE [e].[Id] = @__get_Item_0
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (77ms) [Parameters=[@__entityId_0='?' (DbType = Int32), @__keyGroup_1='?' (Size = 400)], CommandType='Text', CommandTimeout='30']
      SELECT [ga].[Id], [ga].[EntityId], [ga].[Key], [ga].[KeyGroup], [ga].[StoreId], [ga].[Value]
      FROM [GenericAttribute] AS [ga]
      WHERE ([ga].[EntityId] = @__entityId_0) AND ([ga].[KeyGroup] = @__keyGroup_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (81ms) [Parameters=[@__customerRoleId_0='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [pr].[Id], [pr].[Category], [pr].[Name], [pr].[SystemName]
      FROM [PermissionRecord] AS [pr]
      INNER JOIN [PermissionRecord_Role_Mapping] AS [prcrm] ON [pr].[Id] = [prcrm].[PermissionRecord_Id]
      WHERE [prcrm].[CustomerRole_Id] = @__customerRoleId_0
      ORDER BY [pr].[Id]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@p23='?' (DbType = Int32), @p0='?' (DbType = Boolean), @p1='?' (Size = 4000), @p2='?' (DbType = Int32), @p3='?' (DbType = Int32), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (DbType = Guid), @p7='?' (DbType = Boolean), @p8='?' (Size = 1000), @p9='?' (Size = 1000), @p10='?' (DbType = Int32), @p11='?' (DbType = Boolean), @p12='?' (DbType = Boolean), @p13='?' (DbType = Boolean), @p14='?' (DbType = DateTime2), @p15='?' (Size = 4000), @p16='?' (DbType = DateTime2), @p17='?' (DbType = Int32), @p18='?' (DbType = Boolean), @p19='?' (DbType = Int32), @p20='?' (Size = 400), @p21='?' (Size = 1000), @p22='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SET NOCOUNT ON;
      UPDATE [Customer] SET [Active] = @p0, [AdminComment] = @p1, [AffiliateId] = @p2, [BillingAddress_Id] = @p3, [CannotLoginUntilDateUtc] = @p4, [CreatedOnUtc] = @p5, [CustomerGuid] = @p6, [Deleted] = @p7, [Email] = @p8, [EmailToRevalidate] = @p9, [FailedLoginAttempts] = @p10, [HasShoppingCartItems] = @p11, [IsSystemAccount] = @p12, [IsTaxExempt] = @p13, [LastActivityDateUtc] = @p14, [LastIpAddress] = @p15, [LastLoginDateUtc] = @p16, [RegisteredInStoreId] = @p17, [RequireReLogin] = @p18, [ShippingAddress_Id] = @p19, [SystemName] = @p20, [Username] = @p21, [VendorId] = @p22
      WHERE [Id] = @p23;
      SELECT @@ROWCOUNT;
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@p5='?' (DbType = Int32), @p0='?' (DbType = Int32), @p1='?' (Size = 400), @p2='?' (Size = 400), @p3='?' (DbType = Int32), @p4='?' (Size = 4000)], CommandType='Text', CommandTimeout='30']
      SET NOCOUNT ON;
      UPDATE [GenericAttribute] SET [EntityId] = @p0, [Key] = @p1, [KeyGroup] = @p2, [StoreId] = @p3, [Value] = @p4
      WHERE [Id] = @p5;
      SELECT @@ROWCOUNT;
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[1]
      Executing action method Nop.Web.Areas.Admin.Controllers.OrderController.List (Nop.Web) - Validation state: Valid
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (14ms) [Parameters=[@__entityId_0='?' (DbType = Int32), @__keyGroup_1='?' (Size = 400)], CommandType='Text', CommandTimeout='30']
      SELECT [ga].[Id], [ga].[EntityId], [ga].[Key], [ga].[KeyGroup], [ga].[StoreId], [ga].[Value]
      FROM [GenericAttribute] AS [ga]
      WHERE ([ga].[EntityId] = @__entityId_0) AND ([ga].[KeyGroup] = @__keyGroup_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (0ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (4ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (0ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT COUNT(*)
      FROM [Vendor] AS [v]
      WHERE [v].[Deleted] = 0
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__p_0='?' (DbType = Int32), @__p_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT [v].[Id], [v].[Active], [v].[AddressId], [v].[AdminComment], [v].[AllowCustomersToSelectPageSize], [v].[Deleted], [v].[Description], [v].[DisplayOrder], [v].[Email], [v].[MetaDescription], [v].[MetaKeywords], [v].[MetaTitle], [v].[Name], [v].[PageSize], [v].[PageSizeOptions], [v].[PictureId]
      FROM [Vendor] AS [v]
      WHERE [v].[Deleted] = 0
      ORDER BY [v].[DisplayOrder], [v].[Name]
      OFFSET @__p_0 ROWS FETCH NEXT @__p_1 ROWS ONLY
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [wh].[Id], [wh].[AddressId], [wh].[AdminComment], [wh].[Name]
      FROM [Warehouse] AS [wh]
      ORDER BY [wh].[Name]
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (105ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
      SELECT [c].[Id], [c].[AllowsBilling], [c].[AllowsShipping], [c].[DisplayOrder], [c].[LimitedToStores], [c].[Name], [c].[NumericIsoCode], [c].[Published], [c].[SubjectToVat], [c].[ThreeLetterIsoCode], [c].[TwoLetterIsoCode]
      FROM [Country] AS [c]
      ORDER BY [c].[DisplayOrder], [c].[Name]
info: Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker[2]
      Executed action method Nop.Web.Areas.Admin.Controllers.OrderController.List (Nop.Web), returned result Microsoft.AspNetCore.Mvc.ViewResult in 488.9122ms.
info: Microsoft.AspNetCore.Mvc.ViewFeatures.ViewResultExecutor[1]
      Executing ViewResult, running view List.
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (1ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.EntityFrameworkCore.Database.Command[20101]
      Executed DbCommand (0ms) [Parameters=[@__resourceKey_0='?' (Size = 200), @__languageId_1='?' (DbType = Int32)], CommandType='Text', CommandTimeout='30']
      SELECT TOP(1) [l].[ResourceValue]
      FROM [LocaleStringResource] AS [l]
      WHERE ([l].[ResourceName] = @__resourceKey_0) AND ([l].[LanguageId] = @__languageId_1)
info: Microsoft.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: June 12, 2019 at 9:50 AM Quote #237586
Hello,

If you managed to get it working on one of your machines, then it is the cache problem and not something in the nopCommerce application. Furthermore, the log file you've shared doesn't contain any errors that I can see.

Are there any javascript errors in your browser console of the other machines that still have this issue?

Regards,
Anton
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
www.Nop-Templates.com - the best place for nopCommerce themes and plugins

Follow us on
Facebook: http://www.facebook.com/NopTemplates
Twitter: http://twitter.com/NopTemplates
Blog: http://www.nop-templates.com/blog

www.Nop-Templates.com
nopCommerce Solution Partners
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.