- Issue created by @drupalfan2
- ๐ฆ๐นAustria drupalfan2
I added the primary key manually:
ALTER TABLE `mydatabase`.`drupal_amazon_paapi_amazon_product_widget_asin_map` ADD PRIMARY KEY (`entity_id`);
- ๐ฉ๐ชGermany Denis Waรmann
@drupalfan2 Unfortunately, I have no idea about databases - where do i get the entity_id? thx
- ๐ธ๐ฎSlovenia miha.wagner
This solution will almost certainly throw an error if there are several products integrated in the same entity. Primary keys need to be unique, and the 'entity_id' column is not meant to be unique.
Thank you for bringing this up, I'll take a look at what can be done about this.
- Merge request !21#3375539 amazon_product_widget_asin_map table needs primary key โ (Merged) created by miha.wagner
-
miha.wagner โ
committed b06f8328 on 1.5.x
Issue #3375539 by miha.wagner, drupalfan2:...
-
miha.wagner โ
committed b06f8328 on 1.5.x
- ๐ธ๐ฎSlovenia miha.wagner
I've added a composite primary key on the entity_id, entity_type and asin columns, which combined do offer a unique value. This fixes the warning and will be included in the next release.
Thank you for the report.