Tutorial needed to upgrade from simpleinvoices 2011 to 2023

[abek]

Tutorial needed to upgrade from simpleinvoices 2011 to 2023 (VERSION)

What matters to me is that I have both environments (VERSIONS) running. I would like to import the data from the OLD Database of which I have the 2011 installation, into the 2023 (version) environment of simpleinvoices.

I have downloaded all versions, but somehow this doesn’t work with tons of error messages.

Does anyone have any experience with this to help? Or the steps for updating …to the latest version

• This topic was modified 6 months ago by abek.

[abek]

i got these error while upgrade from 2019.2

[abek]

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 5 months, 4 weeks ago by abek.

Attachments:

1. 

   2023-ERROR.png
   

[abek]

ERROR after pressing the UPDATE BUTTON

Attachments:

1. 

   2023-Error-after-update-pressB.png
   

[abek]

Upgrade vieuw

Attachments:

1. 

   Upgrade-setting.png
   

[RRowley]

Concerning unable to apply foreign key changes error, the exception message tells you what the issue is. From your error log:

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

This is saying that there are si_invoice_item_tax table records with an id of 10, 11, 12 and 13, containing invoice_item_id values that do not exist in the si_invoice_items table.

There are two ways to resolve this. One is to create si_invoice_itens records that contain these values. The other is to delete these records from the si_invoice_item_tax table. Since the orphaned records are likely left over from the deletion of si_invoice_items records that failed to delete associated tax records, the solution to delete the si_invoice_item_tax records with id values of 10, 11, 12 and 13 is likely the best solution.

[Author]

Posts