I have just updated to the last 2023 version however during the update I go this error:
SqlPatchManager::runSqlPatch() error. See error log for more information.
and now it is stuck and won’t proceed to the SQL patch 331.
I navigated to:
tmp/log/php.log
and the last line says:
[19-Jul-2025 21:38:25 America/New_York]
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 2
invoice_item_tax invoice_item_id invoice_items id 3
invoice_item_tax invoice_item_id invoice_items id 4
invoice_item_tax invoice_item_id invoice_items id 5
invoice_item_tax invoice_item_id invoice_items id 7
invoice_item_tax invoice_item_id invoice_items id 8
invoice_item_tax invoice_item_id invoice_items id 162
invoice_item_tax invoice_item_id invoice_items id 322
invoice_item_tax invoice_item_id invoice_items id 471
invoice_item_tax invoice_item_id invoice_items id 617
invoice_item_tax invoice_item_id invoice_items id 660
invoice_item_tax invoice_item_id invoice_items id 1063
invoice_item_tax invoice_item_id invoice_items id 1064
invoice_item_tax invoice_item_id invoice_items id 1058
invoice_item_tax invoice_item_id invoice_items id 1059
invoice_item_tax invoice_item_id invoice_items id 1062
invoice_item_tax invoice_item_id invoice_items id 1060
invoice_item_tax invoice_item_id invoice_items id 1061
invoice_item_tax invoice_item_id invoice_items id 1067
invoice_item_tax invoice_item_id invoice_items id 1068
invoice_item_tax invoice_item_id invoice_items id 1332
invoice_item_tax invoice_item_id invoice_items id 1379
invoice_item_tax invoice_item_id invoice_items id 1455
invoice_item_tax invoice_item_id invoice_items id 1456
invoice_item_tax invoice_item_id invoice_items id 1470
invoice_item_tax invoice_item_id invoice_items id 1598
invoice_item_tax invoice_item_id invoice_items id 1680
invoice_item_tax invoice_item_id invoice_items id 1693
invoice_item_tax invoice_item_id invoice_items id 1694
invoice_item_tax invoice_item_id invoice_items id 1751
invoice_item_tax invoice_item_id invoice_items id 1904
invoice_item_tax invoice_item_id invoice_items id 2008
invoice_item_tax invoice_item_id invoice_items id 2009
invoice_item_tax invoice_item_id invoice_items id 2010
invoice_item_tax invoice_item_id invoice_items id 2164
invoice_item_tax invoice_item_id invoice_items id 2275
invoice_item_tax invoice_item_id invoice_items id 2296
invoice_item_tax invoice_item_id invoice_items id 2401
invoice_item_tax invoice_item_id invoice_items id 2400
invoice_item_tax invoice_item_id invoice_items id 2402
invoice_item_tax invoice_item_id invoice_items id 2403
invoice_item_tax invoice_item_id invoice_items id 2404
invoice_item_tax invoice_item_id invoice_items id 2448
invoice_item_tax invoice_item_id invoice_items id 2449
invoice_item_tax invoice_item_id invoice_items id 2499
invoice_item_tax invoice_item_id invoice_items id 2512
invoice_item_tax invoice_item_id invoice_items id 2517
invoice_item_tax invoice_item_id invoice_items id 2518
invoice_item_tax invoice_item_id invoice_items id 2583
invoice_item_tax invoice_item_id invoice_items id 2586
invoice_item_tax invoice_item_id invoice_items id 2666
invoice_item_tax invoice_item_id invoice_items id 2719
invoice_item_tax invoice_item_id invoice_items id 2752
invoice_item_tax invoice_item_id invoice_items id 2772
invoice_item_tax invoice_item_id invoice_items id 2944
invoice_item_tax invoice_item_id invoice_items id 2989
invoice_item_tax invoice_item_id invoice_items id 2990
invoice_item_tax invoice_item_id invoice_items id 2988
invoice_item_tax invoice_item_id invoice_items id 3038
invoice_item_tax invoice_item_id invoice_items id 3070
[19-Jul-2025 21:38:25 America/New_York] SqlPatchManager::runSqlPatch() - SqlPatchManager::prePatch331() = Unable to set Foreign Keys.
Please help
Recent Comments