View Issue Details

IDProjectCategoryView StatusLast Update
0005029OXID eShop (all versions)2.7. Customer infopublic2017-07-06 09:17
ReporterStefan Krenz Assigned To 
Status resolvedResolutionfixed 
Product Version4.7.0 / 5.0.0 revision 51243 
Fixed in Version6.0.0-rc.2 
Summary0005029: PrimaryKey in "oxstates" table only set on column "OXID"
DescriptionThe 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 InformationThe PK should be set on the column "OXCOUNTRYID" and "OXID" (in this order), to get really be unique.
TagsNo tags attached.
PHP VersionNot defined
Database VersionAll


parent of 0005544 closed --> state gets written in numbers not letters <-- 



2013-04-03 16:37

reporter   ~0008556

"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.


2014-04-15 13:04

reporter   ~0009838

This bug fix was reverted because of 0005544


2017-07-06 09:17

reporter   ~0012178

Fixed with this commit: