[abek]

thank you sir.

If I adjust the (local.currency_code to EURO), the entire system freezes. And I no longer see any invoices.
Where can I find the information that I need to enter for the Euro?
Default it was USD

version.name = 2019.2.32
version.update_date = 20210526

local.locale = nl_NL
local.currency_code = Euro
local.precision = 2

[abek]

Upgrade vieuw

Attachments:

1. 

   Upgrade-setting.png
   

[abek]

ERROR after pressing the UPDATE BUTTON

Attachments:

1. 

   2023-Error-after-update-pressB.png
   

[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 1 year, 1 month ago by abek.

Attachments:

1. 

   2023-ERROR.png
   

[abek]

i got these error while upgrade from 2019.2

[Author]

Posts