nopcommerce 4.2 after insert abou2 53 category and some of them parent category category page got this error We're sorry, an internal error occurred.
Our supporting staff has been notified of this error and will address the issue shortly.
and log is The number of rows provided for a FETCH clause must be greater then zero. Full message System.Data.SqlClient.SqlException (0x80131904): The number of rows provided for a FETCH clause must be greater then zero. 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.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() 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.Services.Vendors.VendorService.GetAllVendors(String name, Int32 pageIndex, Int32 pageSize, Boolean showHidden) at Nop.Web.Factories.CatalogModelFactory.<PrepareVendorNavigationModel>b__50_0() in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Factories\CatalogModelFactory.cs:line 1101 at EasyCaching.InMemory.DefaultInMemoryCachingProvider.BaseGet[T](String cacheKey, Func`1 dataRetriever, TimeSpan expiration) at EasyCaching.Core.EasyCachingAbstractProvider.Get[T](String cacheKey, Func`1 dataRetriever, TimeSpan expiration) 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 42 at Nop.Web.Factories.CatalogModelFactory.PrepareVendorNavigationModel() in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Factories\CatalogModelFactory.cs:line 1119 at Nop.Web.Components.VendorNavigationViewComponent.Invoke() in C:\andrei\nopcommerce\sources\src\Presentation\Nop.Web\Components\VendorNavigation.cs:line 26 at lambda_method(Closure , Object , Object[] )
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.