Saving new product throws PDOException

[berrytimmermans]

Description

After upgrading from Craft CMS 4 / Commerce 4 to Craft CMS 5 / Commerce 5, saving a new Digital Product throws a PDOException because the price field is missing from the INSERT query into commerce_purchasables.

Steps to reproduce

1. Upgrade Craft CMS from v4 to v5 (The upgrade and migration completed successfully without any errors.)
2. Upgrade Craft Commerce from v4 to v5 (The upgrade and migration completed successfully without any errors.)
3. Install or keep craftcms/digital-products v4.0.3
4. Go to Commerce → Products → Digital Products
5. Create a new digital product and save it

Additional info

• Craft version: Craft Pro 5.10.1

• PHP version: 8.4.20

• Database driver & version: MySQL 8.0.40

• Plugins & versions:

• Craft Commerce: 5.6.5

• Digital Products: 4.0.3

• Freeform: 5.15.13

• Link Vault: 5.0.3

• Mollie for Craft Commerce: 4.4.1

• Redactor: 4.2.0

• Redactor Anchors: 1.5.0

[linear-code]

COM-569

[lukeholder]

Thanks for reporting this. The fix will be included in the next release.

In the meantime, to get the fix early, change your craftcms/commerce-digital-products requirement in composer.json to:

"require": {
  "craftcms/commerce-digital-products": "4.x-dev#06d10f8fabc4d39826a3f900725c20838fb4377a as 4.0.3",
  "...": "..."
}

Then run composer update.

We will update this ticket once the release is out. Thanks!