UPSTREAM FIX

magento2-28796: Duplicated data in eav_attribute_option_value with a unique key

Community fix magento2-28796 merged into magento/magento2 on 2024-07-04, released in 2.4.8; applies cleanly to 27 releases from 2.4.6 to 2.4.7-p10.

Fixes duplicated data in eav_attribute_option_value with a unique key edited

Pull request title
Missing unique key on eav_attribute_option_value table
Pull request
magento/magento2#28796
Issues
#24718 human
Author
@ihor-sviziev
Merged
2024-07-04
Fixed in
2.4.8
Reported on
—
Categories
Catalog/Product
Components
magento/module-eav

Labels

Area
Catalog
Component
DB
Priority
P2
Severity
S3
Reported on (labels)
2.3.x

Issue

Title and steps come from the upstream issue and pull request.

The upstream issue and pull request have no structured description.

Code match per tag

Each tag was checked with git apply --check against that tag's files. A clean match means the change applies; it is not a test result. Tags that already contain the fix are marked.

LineCode match per tagTests
2.4.6
2.4.6 clean 2.4.6-p1 clean 2.4.6-p2 clean 2.4.6-p3 clean 2.4.6-p4 clean 2.4.6-p5 clean 2.4.6-p6 clean 2.4.6-p7 clean 2.4.6-p8 clean 2.4.6-p9 clean 2.4.6-p10 clean 2.4.6-p11 clean 2.4.6-p12 clean 2.4.6-p13 clean 2.4.6-p14 clean 2.4.6-p15 clean
2.4.6: no test data 2.4.6-p1: no test data 2.4.6-p2: no test data 2.4.6-p3: no test data 2.4.6-p4: no test data 2.4.6-p5: no test data 2.4.6-p6: no test data 2.4.6-p7: no test data 2.4.6-p8: no test data 2.4.6-p9: no test data 2.4.6-p10: no test data 2.4.6-p11: no test data 2.4.6-p12: no test data 2.4.6-p13: no test data 2.4.6-p14: no test data 2.4.6-p15: no test data
2.4.7
2.4.7 clean 2.4.7-p1 clean 2.4.7-p2 clean 2.4.7-p3 clean 2.4.7-p4 clean 2.4.7-p5 clean 2.4.7-p6 clean 2.4.7-p7 clean 2.4.7-p8 clean 2.4.7-p9 clean 2.4.7-p10 clean
2.4.7: no test data 2.4.7-p1: no test data 2.4.7-p2: no test data 2.4.7-p3: no test data 2.4.7-p4: no test data 2.4.7-p5: no test data 2.4.7-p6: no test data 2.4.7-p7: no test data 2.4.7-p8: no test data 2.4.7-p9: no test data 2.4.7-p10: no test data
2.4.8
2.4.8 conflictcontains the fix 2.4.8-p1 conflictcontains the fix 2.4.8-p2 conflictcontains the fix 2.4.8-p3 conflictcontains the fix 2.4.8-p4 conflictcontains the fix 2.4.8-p5 conflictcontains the fix
2.4.8: no test data 2.4.8-p1: no test data 2.4.8-p2: no test data 2.4.8-p3: no test data 2.4.8-p4: no test data 2.4.8-p5: no test data
2.4.9
2.4.9 conflictcontains the fix
2.4.9: no test data

Triage

Model @cf/cloudflare/clef. Probability this is a bug fix: 89.5%. Probability it is security relevant: 0.6%.

Show the model's answers and probabilities
QuestionAnswerProbabilitiesConfidence
Change kindbugfixbugfix 90.0%, feature 4.7%, refactor 3.5%, tests_only 0.7%, dependency 0.7%, docs_only 0.5%77.5%
Areacatalogcatalog 87.8%, framework 4.4%, admin 3.7%74.2%
Reported versionunspecifiedunspecified 40.7%, 2.4.1 1.6%, 2.4.3-p1 1.6%16.1%
Scope0.24 of 20 80.6%, 1 15.1%, 2 4.3%51.1%
Risk1.79 of 22 86.6%, 0 7.8%, 1 5.7%63.7%
Worth backporting1.09 of 21 46.9%, 2 30.9%, 0 22.2%4.7%

Download

For cweagans/composer-patches, choose a version below and download the bundle. Copy its magento2-28796/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Test files are always removed; paths are relative to each package root, using the default -p1 level.

Packages (1): magento/module-eav
Bundle README (what the ZIP ships)
# magento2-28796

Community fix merged upstream into magento/magento2, adapted by magento.watch.
This is not a patch published by Adobe.

Pull request: https://github.com/magento/magento2/pull/28796
Issue: https://github.com/magento/magento2/issues/24718
Author: @ihor-sviziev
Source commit: 14ee777aed23b5b3305a2dd82b337a396cf05fc6
Modifications: test files and documentation removed, paths rewritten relative to each Composer package.
Licence: OSL-3.0 / AFL-3.0, as the original Magento Open Source code.
Maintainer: Łukasz Bajsarowicz (@lbajsarowicz)

Licence: Magento Open Source code under OSL-3.0 and AFL-3.0. The bundle carries the original author, source commit and the list of modifications.

Sources

Łukasz Bajsarowicz
Built by

Łukasz Bajsarowicz, e-commerce architect

Magento and Adobe Commerce architecture, upgrades, performance and audits for merchants and agencies since 2015; magento.watch is the tooling I use on those projects.

Open source, maintained on weekends.