no system log, no order list; upgraded from 2.4 to 2.5

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
Il y a 12 ans
After upgrading from 2.4 to 2.5, list of Sales>Orders is blank (No records to display.) but the table in the database has information.

When I checked the system log, it was also blank.

I checked the database and it has the following in the log:
LogLevelId 40
Attempted to divide by zero.
System.DivideByZeroException: Attempted to divide by zero.     at Nop.Core.PagedList`1..ctor(IQueryable`1 source, Int32 pageIndex, Int32 pageSize) in c:\path\Libraries\Nop.Core\PagedList.cs:line 22     at Nop.Services.Logging.DefaultLogger.GetAllLogs(Nullable`1 fromUtc, Nullable`1 toUtc, String message, Nullable`1 logLevel, Int32 pageIndex, Int32 pageSize) in c:\path\Libraries\Nop.Services\Logging\DefaultLogger.cs:line 105     at Nop.Admin.Controllers.LogController.LogList(GridCommand command, LogListModel model)     at lambda_method(Closure , ControllerBase , Object[] )     at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)     at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)     at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)     at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()     at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)     at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14()     at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)     at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14()     at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)     at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)     at System.Web.Mvc.Controller.ExecuteCore()     at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)     at System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext)     at System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5()     at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()     at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)     at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()     at System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d()     at System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f)     at System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action)     at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)     at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result)     at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()     at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Il y a 12 ans
a side note, i've done this upgrade before on a different site and did not have this problem.
Il y a 12 ans
this is code line



        public PagedList(IQueryable<T> source, int pageIndex, int pageSize)
        {
            int total = source.Count();
            this.TotalCount = total;
            this.TotalPages = total / pageSize;

so its must be receiving int pageSize as 0
Il y a 12 ans
Its affecting
Sales>Orders
System>Log
System>Message Queue
Products>Product Reviews (This one doesn't generate a log error)
Sales>Bestsellers
Promotions>Affiliates (This one doesn't generate a log error)

Not affecting
Categories>List
Manufacturers
Products>Manage Products
Customers (list)
Configuration>All Settings
Il y a 12 ans
dfwitdepartment wrote:
Its affecting
Sales>Orders
System>Log
System>Message Queue
Products>Product Reviews (This one doesn't generate a log error)
Sales>Bestsellers
Promotions>Affiliates (This one doesn't generate a log error)

Not affecting
Categories>List
Manufacturers
Products>Manage Products
Customers (list)
Configuration>All Settings


Affecting:
@(Html.Telerik().Grid<LogModel>()
@(Html.Telerik().Grid<QueuedEmailModel>()
@(Html.Telerik().Grid<OrderModel>()

Not Affecting:
@(Html.Telerik().Grid<ProductModel>(Model.Products.Data)
@(Html.Telerik().Grid<CategoryModel>(Model.Data)
@(Html.Telerik().Grid<ManufacturerModel>(Model.Data)


so, must have something to do with not having the Data specified in the call... hmmm
Il y a 12 ans
SELECT *
  FROM Setting
  where Name = 'adminareasettings.gridpagesize'

(default is 15)
Il y a 12 ans
New York wrote:
SELECT *
  FROM Setting
  where Name = 'adminareasettings.gridpagesize'

(default is 15)


When i try to change that in the store>admin area is gives a message box error "'Id' must not be empty."

I had mine at 30, but have changed it to 15.

Still have the issue;

Am reuploading files, maybe a dll got messed up somehow.
Il y a 12 ans
did a re-upload of dlls, and even did an upload of the admin section from a working site- still having the problem.

I'm going to do a fresh download/upload tomorrow, however, if its something in the database then that won't do anything.
Il y a 12 ans
re-applied the upgrade script to the database, still having same issue.

I'm going to re-download/upload- Nopcommerce 2.5 and see if that fixes it.
Il y a 12 ans
just did a new upload to a test server but pointed it to sites database- its working fine;

at least i know now that its not a database issue.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.