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.
11 years ago
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)
11 years ago
a side note, i've done this upgrade before on a different site and did not have this problem.
11 years ago
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
11 years ago
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
11 years ago
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
11 years ago
SELECT *
  FROM Setting
  where Name = 'adminareasettings.gridpagesize'

(default is 15)
11 years ago
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.
11 years ago
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.
11 years ago
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.
11 years ago
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.