View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0001970 | OXID eShop (all versions) | 5. ------ UpdateApp / Update ------ | public | 2010-07-13 12:29 | 2010-09-14 08:46 |
| Reporter | dominiks | Assigned To | |||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | unable to reproduce | ||
| Product Version | 4.4.0 revision 28699 | ||||
| Summary | 0001970: Collation problems after update to CE 4.4.0_28699 | ||||
| Description | There are some DB collation problems after update to version 4.4.0_28699 (CE, utf8_czech_ci based database). Admin -> Service -> System Requirements: Collations in some columns do not match: * oxobject2seodata o OXOBJECTID - latin1_general_ci * oxobject2action o OXOBJECTID - latin1_general_ci o OXACTIONID - latin1_general_ci o OXID - latin1_general_ci * oxinvitations o OXUSERID - latin1_general_ci * oxacceptedterms o OXUSERID - latin1_general_ci | ||||
| Tags | No tags attached. | ||||
| Theme | |||||
| Browser | FireFox 3.x | ||||
| PHP Version | any | ||||
| Database Version | 5.1 | ||||
| related to | 0000808 | resolved | alfonsas_cirtautas | Charset changed to UTF8 for database during update to 4.1.0 |
|
|
@Developers: please check bug entry 0001987 for more info about this case. |
|
|
Reminder sent to: dominiks Hi, We tried to reproduce this case locally, but had no success. Strange is, that you get such notification in the system requirements check. The thing is that ID columns in the tables should be latin1_ even in UTF8 DB. And this check compares the collation of oxarticles.OXID column with the others - if these has different charset - only then it throws the error. Could you please check what collation is set for oxarticles.OXID field in your DB? Best regards, |
|
|
Closed as cannot reproduce. |
