View Issue Details

IDProjectCategoryView StatusLast Update
0007425OXID eShop (all versions)4.07. Source code, Testpublic2023-02-22 12:25
Status acknowledgedResolutionopen 
Product Version6.5.1 
Target VersionFixed in Version 
Summary0007425: unique oxstates.oxid is not enforced
DescriptionOxstates table has only a combined primary key PRIMARY KEY (`OXID`,`OXCOUNTRYID`) so in case we have some database entry with same OXID but different
oxcountry id. In that case State::load() can lead to ambiguous results as it needs to be loaded by oxstate.oxid and oxstate.oxcountryid.
Steps To ReproduceAdd multiple entris to oxstate table with same oxid but different country ids and verfy that you get whatever the database returns first.
TagsNo tags attached.
ThemeNot defined
BrowserNot defined
PHP VersionNot defined
Database VersionAll


parent of 0007422 resolved[email protected] module PayPal Checkout Same state/county IDs may lead to wrong display on PayPal page 



2023-02-22 12:24

administrator   ~0015054

Last edited: 2023-02-22 12:25

View 2 revisions

Thanks for your report. It's reproducable and already known. It was reported in the PayPal Checkout project: Issue#7422 Since this issue may cause a problem in other cases - not just PayPal Checkout module - I acknowledge also for general OXID eShop project. Issue#7422 was set to child issue of this one.