View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0005029 | OXID eShop (all versions) | 2.7. Customer info | public | 2013-03-28 10:41 | 2025-11-03 08:16 |
| Reporter | Stefan Krenz | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | confirmed | Resolution | reopened | ||
| Product Version | 4.7.0 / 5.0.0 revision 51243 | ||||
| Fixed in Version | 6.0.0-rc.2 | ||||
| Summary | 0005029: PrimaryKey in "oxstates" table only set on column "OXID" | ||||
| Description | The primary key in the table "oxstates" is only set on the column "OXID", which includes only the abbreviation of the state. If you have two states with the same abbreviation, but different countries, they can not be stored in the database. | ||||
| Additional Information | The PK should be set on the column "OXCOUNTRYID" and "OXID" (in this order), to get really be unique. | ||||
| Tags | Internationalization Rework | ||||
| Theme | Azure | ||||
| Browser | All | ||||
| PHP Version | Not defined | ||||
| Database Version | All | ||||
|
|
"OXID" can be any unique char, visually you will not see these values. So you can change it as you want(must be unique). In next version we added change that "OXID" values would be simple integers. |
|
|
This bug fix was reverted because of 0005544 |
|
|
Fixed with this commit: https://github.com/OXID-eSales/oxideshop_ce/commit/79c2568c53af4213946e70cd6f50c5d0e86f1289 |
