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 | 2024-08-14 10:14 |
| Reporter | HR | Assigned To | |||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | confirmed | Resolution | open | ||
| Product Version | 6.5.1 | ||||
| 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. | ||||
| Theme | Not defined | ||||
| Browser | Not defined | ||||
| PHP Version | Not defined | ||||
| Database Version | All | ||||
| parent of | 0007422 | resolved | [email protected] | module PayPal Checkout | Same state/county IDs may lead to wrong display on PayPal page |
|
|
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. [sp] |
