Failing to save drafts - Integrity constraint violation

[paulnzime]

Description

When trying to create a draft we get the following error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '15513924731215' for key 'shopify_products.idx_xegbjaxkssvjjizdwoijbjodambngmoprvio'\nThe SQL being executed was: INSERT INTO `shopify_products` (`id`, `shopifyId`, `shopifyGid`, `dateUpdated`, `dateCreated`, `uid`) VALUES (1163, '15513924731215', 'gid://shopify/Product/15513924731215', '2025-07-31 10:57:46', '2025-07-31 10:57:46', 'f5b6b4d9-0665-47a2-bc8a-fae9a62546fc')

This also occurs when Crafts tries to auto-create the draft on editing a field.
Because of this, if we then assign a matrix field to the product we cannot add any blocks as the same error gets triggered.

Any assistance here would be greatly appreciated.

We do have 3 sites configured with unique content between them but other than that its a relatively fresh Craft 5 install.

Steps to reproduce

1. Sync a couple of products from Shopify
2. Edit a product and click Create Draft
3. Note the error

If the error does not occur, try adding multiple sites.

Additional info

• Craft version: 5.8.11
• PHP version: 8.3
• Database driver & version: MySQL 8.0.40
• Plugins & versions: Shopify 6.0.3

[linear]

PT-2865 Failing to save drafts - Integrity constraint violation

[TGriffiths88]

Any updates on this one at all? Running into the same issue on one of our sites. Thanks

[lukeholder]

@TGriffiths88 sorry for delay on this. We have limited resources the last week. Will give you an update on Friday.

[nfourtythree]

Hi @TGriffiths88

Thank you for reporting this we have just pushed a fix in version 6.0.4 that addresses this issue.

Updating to that version should have everything working for you.

Thanks!

[lukeholder]

Thanks Nathaniel forgot to mention this one.

[TGriffiths88]

@nfourtythree Still running into issues with this. The old migration is still running and failing m250213_152850_migrate_shopify_gid_column_for_products

*** applying m250213_152850_migrate_shopify_gid_column_for_products
    > update in {{%shopify_products}} ...Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'gid://shopify/Product/7187651166377' for key 'shopify_products.idx_vnhvgscbmpjthxojmwfnyviwdyjrhpqlywom'
The SQL being executed was: UPDATE `shopify_products` SET `shopifyGid`=CONCAT('gid://shopify/Product/', `shopifyId`) (/var/www/html/vendor/yiisoft/yii2/db/Schema.php:676)
#0 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1325): yii\db\Schema->convertException()
#1 /var/www/html/vendor/yiisoft/yii2/db/Command.php(1120): yii\db\Command->internalExecute()
#2 /var/www/html/vendor/craftcms/cms/src/db/Migration.php(270): yii\db\Command->execute()
#3 /var/www/html/vendor/craftcms/shopify/src/migrations/m250213_152850_migrate_shopify_gid_column_for_products.php(19): craft\db\Migration->update()
#4 /var/www/html/vendor/craftcms/cms/src/db/Migration.php(50): craft\shopify\migrations\m250213_152850_migrate_shopify_gid_column_for_products->safeUp()
#5 /var/www/html/vendor/yiisoft/yii2/console/controllers/BaseMigrateController.php(758): craft\db\Migration->up()
#6 /var/www/html/vendor/craftcms/cms/src/console/controllers/MigrateController.php(373): yii\console\controllers\BaseMigrateController->migrateUp()
#7 [internal function]: craft\console\controllers\MigrateController->actionAll()
#8 /var/www/html/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#9 /var/www/html/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#10 /var/www/html/vendor/yiisoft/yii2/console/Controller.php(180): yii\base\Controller->runAction()
#11 /var/www/html/vendor/craftcms/cms/src/console/controllers/MigrateController.php(192): yii\console\Controller->runAction()
#12 /var/www/html/vendor/yiisoft/yii2/base/Module.php(552): craft\console\controllers\MigrateController->runAction()
#13 /var/www/html/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction()
#14 /var/www/html/vendor/craftcms/cms/src/console/Application.php(91): yii\console\Application->runAction()
#15 /var/www/html/vendor/yiisoft/yii2/base/Controller.php(212): craft\console\Application->runAction()
#16 /var/www/html/vendor/craftcms/cms/src/console/Controller.php(207): yii\base\Controller->run()
#17 /var/www/html/vendor/craftcms/cms/src/console/controllers/UpController.php(60): craft\console\Controller->run()
#18 [internal function]: craft\console\controllers\UpController->actionIndex()
#19 /var/www/html/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#20 /var/www/html/vendor/yiisoft/yii2/base/Controller.php(178): yii\base\InlineAction->runWithParams()
#21 /var/www/html/vendor/yiisoft/yii2/console/Controller.php(180): yii\base\Controller->runAction()
#22 /var/www/html/vendor/craftcms/cms/src/console/ControllerTrait.php(88): yii\console\Controller->runAction()
#23 /var/www/html/vendor/craftcms/cms/src/console/Controller.php(216): craft\console\Controller->traitRunAction()
#24 /var/www/html/vendor/yiisoft/yii2/base/Module.php(552): craft\console\Controller->runAction()
#25 /var/www/html/vendor/yiisoft/yii2/console/Application.php(180): yii\base\Module->runAction()
#26 /var/www/html/vendor/craftcms/cms/src/console/Application.php(91): yii\console\Application->runAction()
#27 /var/www/html/vendor/yiisoft/yii2/console/Application.php(147): craft\console\Application->runAction()
#28 /var/www/html/vendor/craftcms/cms/src/console/Application.php(122): yii\console\Application->handleRequest()
#29 /var/www/html/vendor/yiisoft/yii2/base/Application.php(384): craft\console\Application->handleRequest()
#30 /var/www/html/craft(13): yii\base\Application->run()
#31 {main}
*** failed to apply m250213_152850_migrate_shopify_gid_column_for_products (time: 0.003s)

[nfourtythree]

Hi @TGriffiths88

Apologies that you are still having issues!

We have just pushed up a further tweak.

Are you able to test this extra fix by changing your craftcms/shopify requirement in your project's composer.json to:

"require": {
  "craftcms/shopify": "6.x-dev as 6.0.4",
  "...": "..."
}

Then run composer update.

Please let me know how you get on.

Thanks!

[TGriffiths88]

That works @nfourtythree. Nice one!!

[nfourtythree]

Thank you for the quick reply @TGriffiths88 ! Will put that change out in a hot fix now.

Thanks!

[TGriffiths88]

Thanks for resolving so prompty @nfourtythree