[04-Jul-2023 16:34:05 America/Indiana/Indianapolis] 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 63 invoice_item_tax invoice_item_id invoice_items id 65 invoice_item_tax invoice_item_id invoice_items id 64 invoice_item_tax invoice_item_id invoice_items id 69 invoice_item_tax invoice_item_id invoice_items id 81 invoice_item_tax invoice_item_id invoice_items id 121 invoice_item_tax invoice_item_id invoice_items id 119 invoice_item_tax invoice_item_id invoice_items id 120 invoice_item_tax invoice_item_id invoice_items id 122 invoice_item_tax invoice_item_id invoice_items id 123 invoice_item_tax invoice_item_id invoice_items id 124 invoice_item_tax invoice_item_id invoice_items id 137 invoice_item_tax invoice_item_id invoice_items id 138 invoice_item_tax invoice_item_id invoice_items id 139 invoice_item_tax invoice_item_id invoice_items id 140 invoice_item_tax invoice_item_id invoice_items id 142 invoice_item_tax invoice_item_id invoice_items id 171 invoice_item_tax invoice_item_id invoice_items id 164 invoice_item_tax invoice_item_id invoice_items id 165 invoice_item_tax invoice_item_id invoice_items id 166 invoice_item_tax invoice_item_id invoice_items id 167 invoice_item_tax invoice_item_id invoice_items id 168 invoice_item_tax invoice_item_id invoice_items id 169 invoice_item_tax invoice_item_id invoice_items id 181 invoice_item_tax invoice_item_id invoice_items id 183 invoice_item_tax invoice_item_id invoice_items id 184 invoice_item_tax invoice_item_id invoice_items id 182 invoice_item_tax invoice_item_id invoice_items id 185 invoice_item_tax invoice_item_id invoice_items id 187 invoice_item_tax invoice_item_id invoice_items id 186 invoice_item_tax invoice_item_id invoice_items id 200 invoice_item_tax invoice_item_id invoice_items id 226 invoice_item_tax invoice_item_id invoice_items id 188 invoice_item_tax invoice_item_id invoice_items id 189 invoice_item_tax invoice_item_id invoice_items id 190 invoice_item_tax invoice_item_id invoice_items id 191 invoice_item_tax invoice_item_id invoice_items id 192 invoice_item_tax invoice_item_id invoice_items id 193 invoice_item_tax invoice_item_id invoice_items id 194 invoice_item_tax invoice_item_id invoice_items id 195 invoice_item_tax invoice_item_id invoice_items id 248 invoice_item_tax invoice_item_id invoice_items id 249 invoice_item_tax invoice_item_id invoice_items id 250 invoice_item_tax invoice_item_id invoice_items id 251 invoice_item_tax invoice_item_id invoice_items id 252 invoice_item_tax invoice_item_id invoice_items id 253 invoice_item_tax invoice_item_id invoice_items id 210 invoice_item_tax invoice_item_id invoice_items id 196 invoice_item_tax invoice_item_id invoice_items id 197 invoice_item_tax invoice_item_id invoice_items id 279 invoice_item_tax invoice_item_id invoice_items id 278 invoice_item_tax invoice_item_id invoice_items id 280 invoice_item_tax invoice_item_id invoice_items id 334 invoice_item_tax invoice_item_id invoice_items id 335 invoice_item_tax invoice_item_id invoice_items id 348 invoice_item_tax invoice_item_id invoice_items id 361 invoice_item_tax invoice_item_id invoice_items id 366 invoice_item_tax invoice_item_id invoice_items id 367 invoice_item_tax invoice_item_id invoice_items id 368 invoice_item_tax invoice_item_id invoice_items id 369 invoice_item_tax invoice_item_id invoice_items id 370 invoice_item_tax invoice_item_id invoice_items id 371 invoice_item_tax invoice_item_id invoice_items id 372 invoice_item_tax invoice_item_id invoice_items id 382 invoice_item_tax invoice_item_id invoice_items id 414 invoice_item_tax invoice_item_id invoice_items id 455 invoice_item_tax invoice_item_id invoice_items id 508 invoice_item_tax invoice_item_id invoice_items id 509 invoice_item_tax invoice_item_id invoice_items id 510 invoice_item_tax invoice_item_id invoice_items id 511 invoice_item_tax invoice_item_id invoice_items id 512 invoice_item_tax invoice_item_id invoice_items id 513 invoice_item_tax invoice_item_id invoice_items id 560 invoice_item_tax invoice_item_id invoice_items id 561 invoice_item_tax invoice_item_id invoice_items id 562 invoice_item_tax invoice_item_id invoice_items id 564 invoice_item_tax invoice_item_id invoice_items id 565 invoice_item_tax invoice_item_id invoice_items id 566 invoice_item_tax invoice_item_id invoice_items id 567 invoice_item_tax invoice_item_id invoice_items id 568 invoice_item_tax invoice_item_id invoice_items id 569 invoice_item_tax invoice_item_id invoice_items id 570 invoice_item_tax invoice_item_id invoice_items id 571 invoice_item_tax invoice_item_id invoice_items id 572 invoice_item_tax invoice_item_id invoice_items id 576 invoice_item_tax invoice_item_id invoice_items id 580 invoice_item_tax invoice_item_id invoice_items id 583 invoice_item_tax invoice_item_id invoice_items id 563 invoice_item_tax invoice_item_id invoice_items id 593 invoice_item_tax invoice_item_id invoice_items id 587 invoice_item_tax invoice_item_id invoice_items id 588 invoice_item_tax invoice_item_id invoice_items id 596 invoice_item_tax invoice_item_id invoice_items id 610 invoice_item_tax invoice_item_id invoice_items id 611 invoice_item_tax invoice_item_id invoice_items id 612 invoice_item_tax invoice_item_id invoice_items id 617 invoice_item_tax invoice_item_id invoice_items id 619 invoice_item_tax invoice_item_id invoice_items id 620 invoice_item_tax invoice_item_id invoice_items id 621 invoice_item_tax invoice_item_id invoice_items id 627 invoice_item_tax invoice_item_id invoice_items id 594 invoice_item_tax invoice_item_id invoice_items id 629 invoice_item_tax invoice_item_id invoice_items id 630 invoice_item_tax invoice_item_id invoice_items id 631 invoice_item_tax invoice_item_id invoice_items id 632 invoice_item_tax invoice_item_id invoice_items id 657 invoice_item_tax invoice_item_id invoice_items id 660 invoice_item_tax invoice_item_id invoice_items id 696 invoice_item_tax invoice_item_id invoice_items id 701 invoice_item_tax invoice_item_id invoice_items id 702 invoice_item_tax invoice_item_id invoice_items id 730 invoice_item_tax invoice_item_id invoice_items id 731 invoice_item_tax invoice_item_id invoice_items id 732 invoice_item_tax invoice_item_id invoice_items id 733 invoice_item_tax invoice_item_id invoice_items id 734 invoice_item_tax invoice_item_id invoice_items id 786 invoice_item_tax invoice_item_id invoice_items id 840 invoice_item_tax invoice_item_id invoice_items id 845 invoice_item_tax invoice_item_id invoice_items id 614 invoice_item_tax invoice_item_id invoice_items id 615 invoice_item_tax invoice_item_id invoice_items id 616 invoice_item_tax invoice_item_id invoice_items id 853 invoice_item_tax invoice_item_id invoice_items id 854 invoice_item_tax invoice_item_id invoice_items id 852 invoice_item_tax invoice_item_id invoice_items id 856 invoice_item_tax invoice_item_id invoice_items id 858 invoice_item_tax invoice_item_id invoice_items id 902 invoice_item_tax invoice_item_id invoice_items id 1233 invoice_item_tax invoice_item_id invoice_items id 1227 invoice_item_tax invoice_item_id invoice_items id 1259 invoice_item_tax invoice_item_id invoice_items id 1285 invoice_item_tax invoice_item_id invoice_items id 1290 invoice_item_tax invoice_item_id invoice_items id 1309 invoice_item_tax invoice_item_id invoice_items id 1328 invoice_item_tax invoice_item_id invoice_items id 1329 invoice_item_tax invoice_item_id invoice_items id 1332 invoice_item_tax invoice_item_id invoice_items id 1370 invoice_item_tax invoice_item_id invoice_items id 1444 [04-Jul-2023 16:34:05 America/Indiana/Indianapolis] SqlPatchManager::runSqlPatch() - SqlPatchManager::prePatch331() = Unable to set Foreign Keys. [04-Jul-2023 16:34:05 America/Indiana/Indianapolis] PdoDb destruct - incomplete transaction - rollback performed.