Reply To: 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 › Reply To: DataTables warning: table id=si-data-table – Invalid JSON response. For more inf

July 20, 2025 at 5:53 am #2178
fearless359
Keymaster

This update is adding foreign key support so that the situation you have now won’t occur in the future. The si_invoice_item_tax table contains orphaned records. That is, they contain a value in the invoice_item_id field that references a record in the si_invoice_items table that no longer exists. You can verify this for yourself by verifying that a record with the value shown in the INVALID VALUE column does not exist in the id field of any record in the si_invoice_items table, but does exist in the invoice_item_id field of the si_invoice_item_tax table.

Once you are satisfied this is the case, you just need to delete those orphaned records from the si_invoice_item_tax table. After the orphaned records are deleted, you can run SI again and it will pick up at this point and move forward from there.

  • This reply was modified 6 months, 1 week ago by fearless359.