Profile: nordic
User posts
10 years ago
Hi nordic,
Thank you very much for the additional information and link.
The actual error we got is
“There is already an open DataReader associated with this Command which must be closed first.”
Can you please double check that in your connection string you have the following option “MultipleActiveResultSets=True” set. This allows multiple connection to the database simultaneously.
You can find your connection string in your ~/App_Data/Settings.txt file.
Looking forward to your reply!
Thank you very much for the additional information and link.
The actual error we got is
“There is already an open DataReader associated with this Command which must be closed first.”
Can you please double check that in your connection string you have the following option “MultipleActiveResultSets=True” set. This allows multiple connection to the database simultaneously.
You can find your connection string in your ~/App_Data/Settings.txt file.
Looking forward to your reply!
IT WORKS . Thank you very much :)
10 years ago
Hi nordic,
There were similar posts related to this type of error. You can check them out:
This post and this post.
Also you can try modifying the Globala.asax file in order to make a full application restart.
If the error still exists can you send us a link to your website where we can see the error.
Hope that helps!
There were similar posts related to this type of error. You can check them out:
This post and this post.
Also you can try modifying the Globala.asax file in order to make a full application restart.
If the error still exists can you send us a link to your website where we can see the error.
Hope that helps!
I have a feeling this will be a different kind of error as above.
and this is site. http://test.infinityobchod.sk/proteiny
[code]An error occurred while executing the command definition. See the inner exception for details.
Celá správa: System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first. at System.Data.SqlClient.SqlInternalConnectionTds.ValidateConnectionForExecute(SqlCommand command) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior) at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues) at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at System.Data.Entity.Internal.Linq.InternalQuery`1.GetEnumerator() at System.Data.Entity.Infrastructure.DbQuery`1.System.Collections.Generic.IEnumerable<TResult>.GetEnumerator() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at SevenSpikes.Nop.AjaxFilters.Services.ProductAttributeService7Spikes..() at Nop.Core.Caching.CacheExtensions.Get[T](ICacheManager cacheManager, String key, Int32 cacheTime, Func`1 acquire) at SevenSpikes.Nop.AjaxFilters.Services.ProductAttributeService7Spikes.(Int32 , Boolean ) at SevenSpikes.Nop.AjaxFilters.Services.ProductAttributeService7Spikes.GetAllProductVariantAttributesWhichHaveValuesByProductId(Int32 productId, Boolean showHiddenProducts) at SevenSpikes.Nop.AjaxFilters.Helpers.AttributeFilterOptionsHelper.(Product , IList`1 ) at SevenSpikes.Nop.AjaxFilters.Helpers.AttributeFilterOptionsHelper.GetProductsForAttributeFiltersAndDetermineAvailableAttributeOptionsForLaterRerieval(IQueryable`1 query, AttributeFilterModelDTO attributeFilterModelDTO) at SevenSpikes.Nop.AjaxFilters.Helpers.FiltersAvailabilityHelper.FilterProductsAndDetermineAvailableFiltersForLaterRetrieval(IQueryable`1 products, Nullable`1 featuredProducts) at S
10 years ago
Hi. I have a problem with this bug if i try search by flavor on category page.
[ArgumentException: The parameters dictionary contains a null entry for parameter 'categoryId' of non-nullable type 'System.Int32' for method 'System.Web.Mvc.ActionResult GetFilteredProducts(Int32, SevenSpikes.Nop.AjaxFilters.Models.PriceRangeFilterSlider.PriceRangeFilterModel7Spikes, SevenSpikes.Nop.AjaxFilters.Models.SpecificationFilter.SpecificationFilterModel7Spikes, SevenSpikes.Nop.AjaxFilters.Models.AttributeFilter.AttributeFilterModel7Spikes, SevenSpikes.Nop.AjaxFilters.Models.ManufacturerFilter.ManufacturerFilterModel7Spikes, Nop.Web.Models.Catalog.CatalogPagingFilteringModel, System.String)' in 'SevenSpikes.Nop.AjaxFilters.Controllers.Catalog7SpikesController'. An optional parameter must be a reference type, a nullable type, or be declared as an optional parameter.
Parameter name: parameters]
