View Issue Details

IDProjectCategoryView StatusLast Update
0001638OXID eShop (all versions)1.01. Products (product, categories, manufacturer, promotions etc.)public2012-12-07 14:13
Reporterandreas_ziethen Assigned To 
PriorityurgentSeverityblockReproducibilityalways
Status resolvedResolutionfixed 
Summary0001638: EE: mall functionality is ignored in oxcategorylist
DescriptionThis bug is there up from version 4.1.6:
In oxcategorylist::_getDepthSqlUnion() the category view is not used - so mall shops are ignored.

We have had a case where after the update from 4.1.5 to 4.2 suddenly in tow subshops categories appeared which did belong to other shops.

These two lines should be changed:
." FROM oxcategories AS subcats"
                ." LEFT JOIN oxcategories AS maincats on maincats.oxparentid = subcats.oxparentid"

to:
$sViewName = $this->getBaseObject()->getViewName();
(...)
." FROM $sViewName AS subcats"
                ." LEFT JOIN $sViewName AS maincats on maincats.oxparentid = subcats.oxparentid"
TagsCategory
Theme
BrowserAll
PHP Versionany
Database Versionany

Activities

tomas_liubinas

2010-02-05 10:05

reporter   ~0002338

The propossed fix is correct and I implemented it. Just I didn't really understand the scenario how it could happen. Having in mind that you could assign only full category branch to subshop, how it could happen that categories having same oxrootid appears in different subshops?