View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0002758 | OXID eShop (all versions) | 4.06. Language and translations | public | 2011-04-19 10:20 | 2011-07-13 08:43 |
| Reporter | Helmut L. | Assigned To | |||
| Priority | urgent | Severity | block | Reproducibility | always |
| Status | resolved | Resolution | fixed | ||
| Product Version | 4.5.0 revision 34568 | ||||
| Fixed in Version | 4.5.1 revision 38045 | ||||
| Summary | 0002758: oxfield2shop does not work with multilingual fields | ||||
| Description | When you add a multilingual field, like OXTITLE, to aMultishopArticleFields, the insert and update queries for oxfield2shop fail. The sql generated tries always to insert/update the fields directly in the oxfield2shop table, although the fields are in oxfield2shop_set1, oxfield2shop_set2, ... | ||||
| Steps To Reproduce | add OXTITLE field to the aMultishopArticleFields array add OXTITLE and OXTITLE_1 field in the oxfield2shop table add a new shop add more than eight languages in the admin go to the second shop and try to change the title of an article | ||||
| Additional Information | Enterprise Edition /core/oxarticle.php line 4713 line 4745 | ||||
| Tags | No tags attached. | ||||
| Theme | Both | ||||
| Browser | All | ||||
| PHP Version | any | ||||
| Database Version | any | ||||
| related to | 0002901 | resolved | arvydas_vapsva | insert into oxfield2shop fails |
|
|
Reminder sent to: Helmut L. I bet you forgot to add some multilanguage fields for OXTITLE in oxfield2shop. Check oxarticles table and you will see, that default oxarticles table has OXTITLE, OXTITLE_1, OXTITLE_2 and OXTITLE_3, so before adding a new language you HAD add not just OXTITLE and OXTITLE_1, but also OXTITLE_2 and OXTITLE_2 |
|
|
I had added the OXTITLE_... fields correctly to the corresponding oxfield2shop, oxfield2shop_set1, oxfield2shop_set2, ... Tables. If i manually insert an entry in these tables everything is correctly displayed in the shop. The generated select queries correctly use the oxfield2shop_set... tables, but the generated insert and update queries don't use the oxfield2shop_set... tables and thus they try to use an OXTITLE_... field in oxfield2shop although it is in oxfield2shop_set... You can see this directly in the source of oxarticle at the mentioned lines. |
|
|
added oxfield2shop class which automatically (by using standard ox18n/oxbase methods) handles such situations |
