[5.x]: SQL error when processing a fulfillment

[jmauzyk]

What happened?

Description

Getting the following SQL error when trying to process a fulfillment on an order:

SQLSTATE[23514]: Check violation: 7 ERROR: new row for relation "commerce_inventorytransactions" violates check constraint "commerce_inventorymovements_type_check" DETAIL: Failing row contains (3009, 1, 2996, 40cb2e2e2d48dc512ddb8e29db5ddeee, 1, fulfilled, , null, 823094, 10982, 2026-04-29 19:17:03, f3ce165d-50d1-4379-9714-a84b4932d8ba). The SQL being executed was: INSERT INTO "commerce_inventorytransactions" ("quantity", "type", "inventoryItemId", "inventoryLocationId", "movementHash", "dateCreated", "transferId", "lineItemId", "userId", "note", "uid") VALUES (1, 'fulfilled', 2996, 1, '40cb2e2e2d48dc512ddb8e29db5ddeee', '2026-04-29 19:17:03', NULL, 823094, 10982, '', 'f3ce165d-50d1-4379-9714-a84b4932d8ba')

It appears that the m240228_060604_add_fufilled_type_to_inventorytransactions migration isn't applied correctly in PostgreSQL.

Craft CMS version

5.9.21

Craft Commerce version

5.6.2

PHP version

8.2.30

Operating system and version

Linux 6.12.76-linuxkit

Database type and version

PostgreSQL 14.20

Image driver and version

Imagick 3.8.1 (ImageMagick 7.1.1-43)

Installed plugins and versions

No response

[linear]

COM-561