View Issue Details
|OXID eShop (all versions)
|4.07. Source code, Test
|Fixed in Version
|0007425: unique oxstates.oxid is not enforced
|Oxstates 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 Reproduce
|Add multiple entris to oxstate table with same oxid but different country ids and verfy that you get whatever the database returns first.
|No tags attached.
Thanks for your report. It's reproducable and already known. It was reported in the PayPal Checkout project: Issue#7422 https://bugs.oxid-esales.com/view.php?id=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.