Reply To: Database Upgrade Error

[RRowley]

These are the records at issue (from the attached zip file):

FOREIGN KEY TABLE         COLUMN              REFERENCE TABLE          COLUMN     INVALID VALUE
------------------------  ------------------  -----------------------  ---------  -------------
invoice_items             invoice_id          invoices                 id         1
invoice_items             invoice_id          invoices                 id         2
invoice_items             invoice_id          invoices                 id         3
invoice_items             invoice_id          invoices                 id         4
invoice_items             invoice_id          invoices                 id         12
payment                   ac_inv_id           invoices                 id         2
payment                   ac_inv_id           invoices                 id         3

These records are orphaned, they have no associated parent records. For the si_invoice_items records, you can check them in the database and verify the the index_id in each of these records does not exist in the si_invoices table. Similarly for the si_payments records you can verify that the ac_inv_id does not have a corresponding record in the si_invoices table.

Once verified, your choice is to delete the orphaned records or to manually create an si_invoice record with an id matching the orphaned records.

Once this is done, the patch process will complete.