Reply To: Tutorial needed to upgrade from simpleinvoices 2011 to 2023

SimpleInvoices Group Forum › Forums › Fearless359 SimpleInvoices Discussion Group › Tutorial needed to upgrade from simpleinvoices 2011 to 2023 › Reply To: Tutorial needed to upgrade from simpleinvoices 2011 to 2023

November 5, 2023 at 1:13 am #1994
abek
Participant

i’m getting these ERROR’s after updating form 2020 to 2023

[05-Nov-2023 00:52:30 America/Los_Angeles]
Unable to apply patch 331. Found foreign key table columns with NULL values or
values not in the reference table column. The following list shows what values in foreign
key columns are missing from reference columns.

The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.

FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
———————— —————— ———————– ——— ————-
invoice_item_tax invoice_item_id invoice_items id 10
invoice_item_tax invoice_item_id invoice_items id 11
invoice_item_tax invoice_item_id invoice_items id 12
invoice_item_tax invoice_item_id invoice_items id 13

[05-Nov-2023 00:52:30 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch331() = Unable to set Foreign Keys.
[05-Nov-2023 00:53:47 America/Los_Angeles]
Unable to apply patch 331. Found foreign key table columns with NULL values or
values not in the reference table column. The following list shows what values in foreign
key columns are missing from reference columns.

The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.

FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
———————— —————— ———————– ——— ————-
invoice_item_tax invoice_item_id invoice_items id 10
invoice_item_tax invoice_item_id invoice_items id 11
invoice_item_tax invoice_item_id invoice_items id 12
invoice_item_tax invoice_item_id invoice_items id 13

[05-Nov-2023 00:53:47 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch331() = Unable to set Foreign Keys.
[05-Nov-2023 00:55:35 America/Los_Angeles]
Unable to apply patch 331. Found foreign key table columns with NULL values or
values not in the reference table column. The following list shows what values in foreign
key columns are missing from reference columns.

The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.

FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
———————— —————— ———————– ——— ————-
invoice_item_tax invoice_item_id invoice_items id 10
invoice_item_tax invoice_item_id invoice_items id 11
invoice_item_tax invoice_item_id invoice_items id 12
invoice_item_tax invoice_item_id invoice_items id 13

05-Nov-2023 00:55:35 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch331() = Unable to set Foreign Keys.
[05-Nov-2023 01:09:41 America/Los_Angeles]
Unable to apply patch 331. Found foreign key table columns with NULL values or
values not in the reference table column. The following list shows what values in foreign
key columns are missing from reference columns.

The records in the FOREIGN KEY TABLE are most likely invalid and should be deleted.

FOREIGN KEY TABLE COLUMN REFERENCE TABLE COLUMN INVALID VALUE
———————— —————— ———————– ——— ————-
invoice_item_tax invoice_item_id invoice_items id 11
invoice_item_tax invoice_item_id invoice_items id 12
invoice_item_tax invoice_item_id invoice_items id 13

[05-Nov-2023 01:09:41 America/Los_Angeles] SqlPatchManager::runSqlPatch() – SqlPatchManager::prePatch331() = Unable to set Foreign Keys.

  • This reply was modified 8 months, 3 weeks ago by abek.
Attachments:

  1. 2023-ERROR.png