Tickets :: Comment on [#10439] Content_Tagger->getObjects: sql inner joins error

* Your Email Address
* Spam protection	Enter the letters below: __ .__ . ..__..___ / `\| \\ /\| \|[__ \__.\|__/ \/ \|__\|\|
Comment	> in the class Content_Tagger the > public function getObjects has a some error in the sql. --> inner join. > > The _ensureObject($args['objectId']) is not working this way. > > this patch should fix it. > > > > getObjects($args){ > > if (isset($args['objectId'])) { > > //$args['objectId'] = > current($this->_objectManager->ensureObject($args['objectId'])); > (int)$objectId = $this->_ensureObject($args['objectId']); > > $sql = $this->_db->addLimitOffset(' > > SELECT tagged2.object_id AS object_id, object_name > FROM (' . $inner . ') AS t1 > INNER JOIN ' . $this->_tagged . ' AS tagged2 > ON t1.tag_id = tagged2.tag_id > INNER JOIN ' . $this->_t('objects') . ' AS objects > ON objects.object_id = tagged2.object_id > WHERE tagged2.object_id != ' . $objectId . ' > GROUP BY t2.object_id', > array('limit' => $radius) > ); > > } > }
Attachment
Watch this ticket