View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0007425||OXID eShop (all versions)||4.07. Source code, Test||public||2023-02-22 11:29||2023-02-22 12:25|
|Target Version||Fixed in Version|
|Summary||0007425: unique oxstates.oxid is not enforced|
|Description||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.|
|Tags||No tags attached.|
|PHP Version||Not defined|
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.