View Issue Details

IDProjectCategoryView StatusLast Update
0002758OXID eShop (all versions)4.06. Language and translationspublic2011-07-13 08:43
ReporterHelmut L. Assigned To 
PriorityurgentSeverityblockReproducibilityalways
Status resolvedResolutionfixed 
Product Version4.5.0 revision 34568 
Fixed 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
/core/oxarticle.php
line 4713
line 4745
TagsNo tags attached.
ThemeBoth
BrowserAll
PHP Versionany
Database Versionany

Relationships

related to 0002901 resolvedarvydas_vapsva insert into oxfield2shop fails 

Activities

arvydas_vapsva

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.

arvydas_vapsva

2011-07-13 08:43

reporter   ~0004853

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