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
after we redownloaded the alfresco theme, we've noticed that for
version 3.2 (our version) the files structure have been changed,
what happened lets say to:
SevenSpikes.Nop.Plugins.MegaMenu/Scripts/MegaMenuResponsive.min.js
current download dont have it, it was there for sure when version 3.2 was the latest.
please guide us with the changes you've made, we need our alfresco theme that we bought to work correctly under mobile asap.
thanks
the menu is not open corectly in "english-rtl" on ipad
hello, we've just bought the Alfresco theme, and it comes with Nop ajax filters.
for our needs we should enable/disable (display none/block) the manufacturers filter box according to the state of one specific specification, let's say, if in this specific specification one or more options have been checked then we should display the manufacturers filter box, and if all the options went uncheckd again we should display:none , afcourse initially the manufacturers filter box shouldn't be displayed..
any ideas on how to implement this functionality?
thanks.