View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005544 | OXID eShop (all versions) | 1.03. Basket, checkout process | public | 2013-11-30 18:38 | 2014-06-18 10:46 |
Reporter | enki | ||||
Priority | urgent | Severity | major | Reproducibility | always |
Status | resolved | Resolution | fixed | ||
Platform | linux/nginx + apache | OS | OS Version | ||
Product Version | 4.8.0 / 5.1.0 | ||||
Target Version | 4.9.0_5.2.0_beta1 | Fixed in Version | 4.8.5 / 5.1.5 | ||
Summary | 0005544: --> state gets written in numbers not letters <-- | ||||
Description | basket/checkout/pdf adressfield show the mysql oxid stateID instead of oxid state title | ||||
Steps To Reproduce | place order for internaional shipping use countries with states ! ->goto next step --> state gets written in the generated adressfield in numbers not letters <-- | ||||
Tags | No tags attached. | ||||
Theme | Azure | ||||
Browser | All | ||||
PHP Version | 5.4 | ||||
Database Version | any | ||||
related to | 0005595 | acknowledged | User's state is saved in wrong way | |
child of | 0005029 | resolved | gregor.hyneck | PrimaryKey in "oxstates" table only set on column "OXID" |
|
|
|
Reverted state ids back to isoalpha values, as to change all places where id is used as code requires template changes and will only go to future version. |
|
Bug not fixed! problem still there after update to newest version 4.8.5 |
|
The problem is resolved since 5.1.5/4.8.5 version, but not in the update to 5.1.5/4.8.5. |
|
use this sql script to fix data if some users or address where created with state oxid not isoalpha: UPDATE `oxaddress` INNER JOIN `oxstates` ON `oxstates`.`oxid` = `oxaddress`.`oxstateid` SET `oxaddress`.`oxstateid` = `oxstates`.`oxisoalpha2`; UPDATE `oxuser` INNER JOIN `oxstates` ON `oxstates`.`oxid` = `oxuser`.`oxstateid` SET `oxuser`.`oxstateid` = `oxstates`.`oxisoalpha2`; UPDATE `oxstates` SET `oxid` = `oxisoalpha2`; |
|
resolved |