View Issue Details

IDProjectCategoryView StatusLast Update
0002758OXID eShop (all versions)4.06. Language and translationspublic2011-07-13 08:43
ReporterHelmut L. 
Status resolvedResolutionfixed 
Product Version4.5.0 revision 34568 
Target VersionFixed in Version4.5.1 revision 38045 
Summary0002758: oxfield2shop does not work with multilingual fields
DescriptionWhen 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 Reproduceadd 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 InformationEnterprise Edition
line 4713
line 4745
TagsNo tags attached.
PHP Versionany
Database Versionany


related to 0002901 resolvedarvydas_vapsva insert into oxfield2shop fails 



2011-07-07 10:42

reporter   ~0004834

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

Helmut L.

2011-07-07 11:17

reporter   ~0004835

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.


2011-07-13 08:43

reporter   ~0004853

added oxfield2shop class which automatically (by using standard ox18n/oxbase methods) handles such situations