Since 1.7.2 i am having trouble with the i18n behaviour. It changed and doesn't deliver the proper language object.
Code:
CategoryQuery::Create()->joinWithI18n(getLocale())->filterByIsMenu(true)->filterByParentId($category->getCategoryId())->useCategoryI18nQuery()->filterByIsactive(true)->enduse()->orderBySort()->find()
Executed query 1.7.1:
SELECT .. FROM categoryLEFT JOINcategory_i18nON (category.categoryId=category_i18n.categoryId AND category_i18n.locale = 'de_DE') WHERE category.isMenu=1 AND category.parentId_second=5 AND category_i18n.isActive=1 ORDER BY category.sort_second ASC;
Executed query 1.7.2:
SELECT ... FROM categoryLEFT JOINcategory_i18nON (category.categoryId=category_i18n.categoryId) WHERE category.isMenu=1 AND category.parentId=10 AND category_i18n.isActive=1 ORDER BY category.sort ASC;
The Problem lies in class Join.php line 580;
return $join !== null
&& $join instanceof Join
&& $this->getJoinType() == $join->getJoinType()
&& $this->getConditions() == $join->getConditions()
**&& $this->getClause($parametersOfThisClauses) == $join-> >getClause($parametersOfJoinClauses);** //this line has been added
}
Since 1.7.2 i am having trouble with the i18n behaviour. It changed and doesn't deliver the proper language object.
Code:
CategoryQuery::Create()->joinWithI18n(getLocale())->filterByIsMenu(true)->filterByParentId($category->getCategoryId())->useCategoryI18nQuery()->filterByIsactive(true)->enduse()->orderBySort()->find()Executed query 1.7.1:
SELECT .. FROMcategoryLEFT JOINcategory_i18nON (category.categoryId=category_i18n.categoryId AND category_i18n.locale = 'de_DE') WHERE category.isMenu=1 AND category.parentId_second=5 AND category_i18n.isActive=1 ORDER BY category.sort_second ASC;Executed query 1.7.2:
SELECT ... FROMcategoryLEFT JOINcategory_i18nON (category.categoryId=category_i18n.categoryId) WHERE category.isMenu=1 AND category.parentId=10 AND category_i18n.isActive=1 ORDER BY category.sort ASC;The Problem lies in class Join.php line 580;