View Issue Details

IDProjectCategoryView StatusLast Update
0007660OXID eShop (all versions)Generalpublic2024-10-15 13:00
ReporterMarcel00 Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status confirmedResolutionreopened 
Summary0007660: Content of a language will not be loaded if the language is available in two shops with different IDs
DescriptionThe content will not be loaded from the field oxcontent if the language is available in two shops with different IDs but same abbreviation.
The Problem is the view oxv_oxcontents_langkey. The same view is called from all shops but the language IDs could be different for the same language.
SHOP 1: ES > ID = 5
SHOP 2: ES > ID = 6
View oxv_oxcontents_es:
   `oxcontents`.`OXCONTENT_5` AS `OXCONTENT`

SHOP 2:
Select oxcontent FROM oxv_oxcontents_es WHERE oxshopid = 2 return always empty string or an other language as expected.

The solution is to create a view for every shop like oxv_oxcontents_shopid_langkey.
Steps To Reproduce- Add es language in 1 shop.
- Add es language in 2 shop with different id but same abbreviation.
- Open editor in 2 shop and save and load content.
TagsInternationalization Rework
Theme
Browser
PHP Version
Database Version

Activities

SvenBrunk

2024-10-15 13:00

administrator   ~0017635

Moved to main project, as this is not a VisualCMS issue