DataTables warning: table id=si-data-table – Invalid JSON response. For more inf

SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › DataTables warning: table id=si-data-table – Invalid JSON response. For more inf

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • July 17, 2025 at 5:11 pm #2172
    marcnyc
    Participant

    Hello, SI has started giving me this error out of the blue:

    DataTables warning: table id=si-data-table - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

    Nothing changed on my end but I cannot load years and years of invoices and customers anymore so I’m kinda screwed.
    Does anyone know what this error means and how to solve it?

    I am using: Version: 2020.0.10 — 20201217

    July 18, 2025 at 3:04 pm #2173
    marcnyc
    Participant

    I’ve done more digging and I found that the file /public/data.json is empty… I’ve tried restoring it from backup but it doesn’t change… I’ve also tried deleting it in case it’s corrput but I keep getting the same error (the data.json) file is re-created upon page load but I keep getting the same error and no data in the tables…

    This happens ONLY with the INVOICES and CUSTOMERS data, it does not happen with USERS, PAYMENT TYPES and all the others…

    I’ve looked in the error logs that are being created and I see a series of errors like these:
    [18-Jul-2025 17:46:44 America/New_York] Invoice::getInvoices() – Owing discrepancy on invoice id[1327] – index_id[1329]. Calculated owing[375] not equal to invoices table owning[0.000000]

    I don’t know how/why these errors are created and how to fix them but any advice would be greatly welcome and I’m willing to hire somebody to fix it.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.