Close

loading the page failed. unknown reason

inahmias
10 years ago
#8108 Quote
Avatar
  • 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
Boyko
10 years ago
#8110 Quote
Avatar
  • 1570
inahmias wrote:
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'. "


Hi inahmias,

Did you have this error on your other machine?
If no then probably there are some differences between the two i.e missing files, different database or different SQL server configuration.
Regards,
Nop-Templates.com Team