Any idea what is causing or how to fix this issue ?

1 week ago
Log level  
Error

Short message  
The multi-part identifier "t0.__RowNumber__" could not be bound.
The multi-part identifier "t0.__RowNumber__" could not be bound.
The multi-part identifier "t0.Id" could not be bound.
The multi-part identifier "t0.CountryId" could not be bound.
The multi-part identifier "t0.Percentage" could not be bound.
The multi-part identifier "t0.StateProvinceId" could not be bound.
The multi-part identifier "t0.StoreId" could not be bound.
The multi-part identifier "t0.TaxCategoryId" could not be bound.
The multi-part identifier "t0.Zip" could not be bound.
Full message  
System.Data.SqlClient.SqlException (0x80131904): The multi-part identifier "t0.__RowNumber__" could not be bound.
The multi-part identifier "t0.__RowNumber__" could not be bound.
The multi-part identifier "t0.Id" could not be bound.
The multi-part identifier "t0.CountryId" could not be bound.
The multi-part identifier "t0.Percentage" could not be bound.
The multi-part identifier "t0.StateProvinceId" could not be bound.
The multi-part identifier "t0.StoreId" could not be bound.
The multi-part identifier "t0.TaxCategoryId" could not be bound.
The multi-part identifier "t0.Zip" could not be bound.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.Execute(IRelationalConnection connection, DbCommandMethod executeMethod, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Storage.Internal.RelationalCommand.ExecuteReader(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.BufferlessMoveNext(DbContext _, Boolean buffer)
   at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded)
   at Microsoft.EntityFrameworkCore.Query.Internal.QueryingEnumerable`1.Enumerator.MoveNext()
   at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider._TrackEntities[TOut,TIn](IEnumerable`1 results, QueryContext queryContext, IList`1 entityTrackingInfos, IList`1 entityAccessors)+MoveNext()
   at Microsoft.EntityFrameworkCore.Query.Internal.LinqOperatorProvider.ExceptionInterceptor`1.EnumeratorExceptionInterceptor.MoveNext()
   at System.Collections.Generic.List`1.AddEnumerable(IEnumerable`1 enumerable)
   at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
   at Nop.Plugin.Tax.FixedOrByCountryStateZip.Services.CountryStateZipService.<>c__DisplayClass5_0.<GetAllTaxRates>b__0()
   at Nop.Core.Caching.PerRequestCacheManager.Get[T](String key, Func`1 acquire, Nullable`1 cacheTime) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Core\Caching\PerRequestCacheManager.cs:line 62
   at Nop.Plugin.Tax.FixedOrByCountryStateZip.Services.CountryStateZipService.GetAllTaxRates(Int32 pageIndex, Int32 pageSize)
   at Nop.Plugin.Tax.FixedOrByCountryStateZip.FixedOrByCountryStateZipTaxProvider.<>c__DisplayClass9_0.<GetTaxRate>b__0()
   at Nop.Core.Caching.MemoryCacheManager.Get[T](String key, Func`1 acquire, Nullable`1 cacheTime) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Core\Caching\MemoryCacheManager.cs:line 152
   at Nop.Plugin.Tax.FixedOrByCountryStateZip.FixedOrByCountryStateZipTaxProvider.GetTaxRate(CalculateTaxRequest calculateTaxRequest)
   at Nop.Services.Tax.TaxService.GetTaxRate(Product product, Int32 taxCategoryId, Customer customer, Decimal price, Decimal& taxRate, Boolean& isTaxable) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Services\Tax\TaxService.cs:line 282
   at Nop.Services.Tax.TaxService.GetProductPrice(Product product, Int32 taxCategoryId, Decimal price, Boolean includingTax, Customer customer, Boolean priceIncludesTax, Decimal& taxRate) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Services\Tax\TaxService.cs:line 415
   at Nop.Services.Tax.TaxService.GetProductPrice(Product product, Decimal price, Boolean includingTax, Customer customer, Decimal& taxRate) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Services\Tax\TaxService.cs:line 387
   at Nop.Services.Tax.TaxService.GetProductPrice(Product product, Decimal price, Customer customer, Decimal& taxRate) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Services\Tax\TaxService.cs:line 370
   at Nop.Services.Tax.TaxService.GetProductPrice(Product product, Decimal price, Decimal& taxRate) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Services\Tax\TaxService.cs:line 355
   at Nop.Web.Factories.ProductModelFactory.PrepareProductPriceModel(Product product) in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Factories\ProductModelFactory.cs:line 589
   at Nop.Web.Factories.ProductModelFactory.PrepareProductDetailsModel(Product product, ShoppingCartItem updatecartitem, Boolean isAssociatedProduct) in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Factories\ProductModelFactory.cs:line 1292
   at Nop.Web.Controllers.ProductController.ProductDetails(Int32 productId, Int32 updatecartitemid) in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Controllers\ProductController.cs:line 179
   at lambda_method(Closure , Object , Object[] )
   at Microsoft.AspNetCore.Mvc.Internal.ActionMethodExecutor.SyncActionResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeNextActionFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Rethrow(ActionExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ControllerActionInvoker.InvokeInnerFilterAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeNextResourceFilter()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Rethrow(ResourceExecutedContext context)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeFilterPipelineAsync()
   at Microsoft.AspNetCore.Mvc.Internal.ResourceInvoker.InvokeAsync()
   at Microsoft.AspNetCore.Builder.RouterMiddleware.Invoke(HttpContext httpContext)
   at StackExchange.Profiling.MiniProfilerMiddleware.Invoke(HttpContext context) in C:\projects\dotnet\src\MiniProfiler.AspNetCore\MiniProfilerMiddleware.cs:line 94
   at Nop.Services.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Services\Authentication\AuthenticationMiddleware.cs:line 79
   at Microsoft.AspNetCore.Localization.RequestLocalizationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Session.SessionMiddleware.Invoke(HttpContext context)
   at Nop.Core.Http.InstallUrlMiddleware.Invoke(HttpContext context, IWebHelper webHelper) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Core\Http\InstallUrlMiddleware.cs:line 51
   at Nop.Core.Http.KeepAliveMiddleware.Invoke(HttpContext context, IWebHelper webHelper) in C:\andrei\nopcommerce\sources\src\Libraries\Nop.Core\Http\KeepAliveMiddleware.cs:line 50
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.StaticFiles.StaticFileMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.StatusCodePagesMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Diagnostics.ExceptionHandlerMiddleware.Invoke(HttpContext context)
ClientConnectionId:1d52a356-9bbe-48f5-9785-9bafaf5d6f62
Error Number:4104,State:1,Class:16

IP address  
66.249.64.140

Customer  [email protected]_engine_record.com

Page URL  
https://www.fanmats.com/coastal-carolina-soccer-ball

Referrer URL  

Created on  
7/31/2020 3:05:17 PM
1 week ago
If you manually go to your page
https://www.fanmats.com/coastal-carolina-soccer-ball
do you then get the any errors logged?

Did you make any custom changes to Nop.Plugin.Tax.FixedOrByCountryStateZip?
1 week ago
Hi,
Thank you so much for reply.
I wan haven't made why changes to that recently.
But before i have uninstalled and reinstalled the plugin, and currently a 0% tax is set for one state. No other entries are there.
Should i remove that entry ?
1 week ago
If you manually go to your page
https://www.fanmats.com/coastal-carolina-soccer-ball
do you then get the any errors logged?
1 week ago
Sorry forgot to answer that part of the question.
No i do not get the error then.
This error starts randomly and it goes to construction page.
I have a hunch that it starts off i change banner or static content. Especially since the only recent setting change i made was enable different cacheing options via iis7

Also my nopcommerce version is 4.10
1 week ago
What version of SQL server are you using?

See this post
https://www.nopcommerce.com/en/boards/topic/57860/multi-part-identifier-t1_rownumber_-could-not-be-bound
1 week ago
New York wrote:

Thank you new york, i think you are probably right. I am indeed using only SQL Server 2008R2. Therefore had to enable UseRowNumberForPaging=true to get backward compatibility.

I guess the only option is to upgrade to latest version of SQL to solve issue.

But thank you very much for taking your time to help me with this. Really appreciate it.