- 4
well we've been duplicating our nopCommerce file system and database to a new local machine for testing, but there whenever we try to filter in category page we get this alerted message, the admin log says in short:
" Invalid column name 'ProductAttributeID'. "
and the long version says:
"
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ProductAttributeID'. ב- System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) ב- System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) ב- System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) ב- System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) ב- System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() ב- System.Data.SqlClient.SqlDataReader.get_MetaData() ב- System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) ב- System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) ב- System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) ב- System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) ב- System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) ב- System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) ב- System.Data.Common.DbCommand.ExecuteReader() ב- Nop.Data.NopObjectContext.ExecuteStoredProcedureList[TEntity](String commandText, Object[] parameters) ב- d:\Projects\LnetLibrary_nop\Libraries\Nop.Data\NopObjectContext.cs:שורה 171 ב- SevenSpikes.Nop.Plugins.AjaxFilters.Services.ProductServiceNopAjaxFilters.(IList`1 , SpecificationFilterModelDTO , AttributeFilterModelDTO , ManufacturerFilterModelDTO , Int32 , Int32 , Int32 , Int32 , Int32 , Nullable`1 , Nullable`1 , Nullable`1 , Int32 , String , Boolean , Boolean , Int32 , ProductSortingEnum , Boolean ) ב- SevenSpikes.Nop.Plugins.AjaxFilters.Services.ProductServiceNopAjaxFilters.SearchProducts(IList`1 categoryIds, SpecificationFilterModelDTO specifiationFilterModelDTO, AttributeFilterModelDTO attributeFilterModelDTO, ManufacturerFilterModelDTO manufacturerFilterModelDTO, Int32 pageIndex, Int32 pageSize, Int32 manufacturerId, Int32 storeId, Int32 vendorId, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, Int32 productTagId, String keywords, Boolean searchDescriptions, Boolean searchProductTags, Int32 languageId, ProductSortingEnum orderBy, Boolean showHidden) ב- SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.() ב- SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.(Int32 , Int32 , PriceRangeFilterModel7Spikes , SpecificationFilterModel7Spikes , AttributeFilterModel7Spikes , ManufacturerFilterModel7Spikes , CatalogPagingFilteringModel , String , Boolean , String& ) ב- lambda_method(Closure , ControllerBase , Object[] ) ב- System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) ב- System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) ב- System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) ב- System.Web.Mvc.Async.Asy
" Invalid column name 'ProductAttributeID'. "
and the long version says:
"
System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ProductAttributeID'. ב- System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) ב- System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) ב- System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) ב- System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) ב- System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() ב- System.Data.SqlClient.SqlDataReader.get_MetaData() ב- System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) ב- System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) ב- System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) ב- System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) ב- System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) ב- System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) ב- System.Data.Common.DbCommand.ExecuteReader() ב- Nop.Data.NopObjectContext.ExecuteStoredProcedureList[TEntity](String commandText, Object[] parameters) ב- d:\Projects\LnetLibrary_nop\Libraries\Nop.Data\NopObjectContext.cs:שורה 171 ב- SevenSpikes.Nop.Plugins.AjaxFilters.Services.ProductServiceNopAjaxFilters.(IList`1 , SpecificationFilterModelDTO , AttributeFilterModelDTO , ManufacturerFilterModelDTO , Int32 , Int32 , Int32 , Int32 , Int32 , Nullable`1 , Nullable`1 , Nullable`1 , Int32 , String , Boolean , Boolean , Int32 , ProductSortingEnum , Boolean ) ב- SevenSpikes.Nop.Plugins.AjaxFilters.Services.ProductServiceNopAjaxFilters.SearchProducts(IList`1 categoryIds, SpecificationFilterModelDTO specifiationFilterModelDTO, AttributeFilterModelDTO attributeFilterModelDTO, ManufacturerFilterModelDTO manufacturerFilterModelDTO, Int32 pageIndex, Int32 pageSize, Int32 manufacturerId, Int32 storeId, Int32 vendorId, Nullable`1 featuredProducts, Nullable`1 priceMin, Nullable`1 priceMax, Int32 productTagId, String keywords, Boolean searchDescriptions, Boolean searchProductTags, Int32 languageId, ProductSortingEnum orderBy, Boolean showHidden) ב- SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.() ב- SevenSpikes.Nop.Plugins.AjaxFilters.Controllers.Catalog7SpikesController.(Int32 , Int32 , PriceRangeFilterModel7Spikes , SpecificationFilterModel7Spikes , AttributeFilterModel7Spikes , ManufacturerFilterModel7Spikes , CatalogPagingFilteringModel , String , Boolean , String& ) ב- lambda_method(Closure , ControllerBase , Object[] ) ב- System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) ב- System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) ב- System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) ב- System.Web.Mvc.Async.Asy