magento2-allegro
magento2-allegro copied to clipboard
Error during bin/magento setup:upgrade
Upgrading data... SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'allegro.api' for key 'queue.QUEUE_NAME', query was: INSERT INTO queue (name) VALUES (?)
More information:
Magento version: magento/product-community-edition": "2.3.4
# composer require macopedia/magento2-allegro
Using version ^4.0 for macopedia/magento2-allegro
./composer.json has been updated
...
# bin/magento setup:upgrade
Cache cleared successfully
File system cleanup:
XXXX/generated/code/Composer
XXXX/generated/code/Dotdigitalgroup
XXXX/generated/code/MSP
XXXX/generated/code/Magento
XXXX/generated/code/Symfony
XXXX/generated/code/Yotpo
The directory 'XXXX/generated/metadata/' doesn't exist - skipping cleanup
XXXX/pub/static/adminhtml
XXXX/pub/static/deployed_version.txt
XXXX/pub/static/frontend
XXXX/var/view_preprocessed/pub
Updating modules:
..
Schema creation/updates:
...
Data install/update:
Module 'Macopedia_Allegro':
Upgrading data... SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'allegro.api' for key 'queue.QUEUE_NAME', query was: INSERT INTO `queue` (`name`) VALUES (?)
Seems like delete those lines fixing the problem:
File: Setup/UpgradeData.php
Delete or comment lines:
62 $this->resource->getConnection()
63 ->insert($this->resource->getTableName('queue'), ['name' => 'allegro.api']);