View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001987 | OXID eShop (all versions) | 5. ------ UpdateApp / Update ------ | public | 2010-07-20 11:43 | 2010-09-10 14:09 |
| Reporter | Stefan_Werner | Assigned To | |||
| Priority | high | Severity | minor | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.5.0_beta3 | ||||
| Target Version | 4.4.0 revision 28699 | Fixed in Version | 4.4.3 revision 30016 | ||
| Summary | 0001987: Collation changes during update from 4.0.0.0 to 4.4.0 | ||||
| Description | got an 4.0.0.0 DB with latin_general_ci perform UpdateApp 4.0.0.0 to 4.4.0 after that i have mixed collations UTF8 and latin_general_ci | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
| related to | 0000808 | resolved | alfonsas_cirtautas | Charset changed to UTF8 for database during update to 4.1.0 |
|
|
after Update fromm 4.0.0.0 to 4.4.2 following tables are changed oxstates oxobject2seodata oxacceptedterms if needed i have an demo dump, just ask |
|
|
Basically - it's the same bug as described in 0000808. Just, earlier we had no chance to fix this in update script, where the issue occured. Now we have cumulative Update packages, which are released together with each new eShop version. So fix in some previous Update script resolves a problem and does not makes any confusion. As the fix, the query: ALTER SCHEMA CHARACTER SET utf8 COLLATE utf8_general_ci; ... is removed from update sql file. For those, who already upgraded shops and have broken collations, please check entry 0000808 for solution how to fix it. |
