Reply To: Fatal error: Uncaught TypeError: Return value of Inc\Claz\Export

[RRowley]

OK, I missed the php.log. The DELETE and UPDATE examples shown in your previous message are examples. In the php.log file it has

FOREIGN KEY TABLE         COLUMN              REFERENCE TABLE          COLUMN     INVALID VALUE
------------------------  ------------------  -----------------------  ---------  -------------
invoice_items             invoice_id          invoices                 id         1

This is saying that you have one or more records in the si_invoice_items table with an invoice_id of 1 where there is no entry in the si_invoices table with an id value of 1. In other words, the si_invoice_item records are orphaned. My recommendation:
1) Verify that what I am saying is true.
2) Display the si_invoice_items table and go to the SQL tag.
3) Enter this command DELETE FROM si_invoice_items WHERE invoice_id = 1

Then run SI and see if it completes the update or encounters another foreign key issue.

• This reply was modified 4 years, 6 months ago by RRowley.