[5.x]: Restoring variants does not work #4065
Description
What happened?
Description
PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column "sku" of relation "commerce_variants" does not exist
LINE 1: UPDATE "commerce_variants" SET "sku"=$1, "dateUpdated"=$2 WH...
^
File "/index.php", line 19
$app->run();
...
(15 additional frame(s) were not displayed)
yii\db\Exception: SQLSTATE[42703]: Undefined column: 7 ERROR: column "sku" of relation "commerce_variants" does not exist
LINE 1: UPDATE "commerce_variants" SET "sku"=$1, "dateUpdated"=$2 WH...
^
The SQL being executed was: UPDATE "commerce_variants" SET "sku"='10762-1', "dateUpdated"='2025-06-28 11:59:29' WHERE "id"=97027
File "/index.php", line 19
$app->run();
Steps to reproduce
- Delete a variant
- Restore it
Craft CMS version
5.7.11
Craft Commerce version
5.4
PHP version
8.3
Operating system and version
No response
Database type and version
No response
Image driver and version
No response