DataTables are not showing the data

Hello,

I just install nopcommerce on my website. all the functionality is going smooth except that I have issues with DataTables; they do not load any data and showing this error message: "DataTables warning: table id=average-order-report-grid - Ajax error. For more information about this error, please see http://datatables.net/tn/7"

First clear your browser cache. If still error exists then check error log in log list page.

mhsjaber wrote:

I did clear the cache, browser console shows Error 405 (Method not allowed), what the issue here?

DataTables will give that error when it receives any response other than 200.  Looking at the ReportController it will throw access denied (which is probably a 403 so not sure why it says 405, but 405 can be vague).  Anyway,  I would start by confirming the user has Manage Orders permission, and then make sure you have logging enabled so we can get more details.

if (!_permissionService.Authorize(StandardPermissionProvider.ManageOrders))
     return AccessDeniedDataTablesJson();

Hi,

I have the same issue on almost all the admin pages.

I can give the store url and an admin account info.

https://ercangurevin.com/Admin
user: [email protected]
pass: 11223344

I cant even check the logs. Log does not shown because of the "Datatable warning".

you're getting 403 forbidden responses, can you access the Log directory on the server?  Your ACL looks correct but I could not find your test user in the Customer list (due to the datatable error) to confirm its permissions

I have all access to the server. The user has administrator and register roles. You could not check the customers because all the pages has this error.

I have access the db and the log table's records can be found vie this url;

https://drive.google.com/file/d/18rK0MNDvjJMhSbmnnsolvjGPzfuH_Rwh/view?usp=sharing

it seems many people are having this error in 4.3, this is the only one I can find that found a solution:
https://www.nopcommerce.com/en/boards/topic/82066/versione-43-mysql-error-datatable-admin-products-list

af1racing wrote:

the solution without details, do you have any idea?