magento2-allegro icon indicating copy to clipboard operation
magento2-allegro copied to clipboard

Error during bin/magento setup:upgrade

Open michalzimniak opened this issue 5 years ago • 2 comments

Upgrading data... SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'allegro.api' for key 'queue.QUEUE_NAME', query was: INSERT INTO queue (name) VALUES (?)

michalzimniak avatar Apr 23 '20 09:04 michalzimniak

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 (?)

michalzimniak avatar Apr 24 '20 10:04 michalzimniak

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']);

michalzimniak avatar Apr 28 '20 08:04 michalzimniak