Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

customizing Amasty/Finder module to show record of custom field , the sql it generates takes a long time to load
 
dinarlol
Jr. Member
 
Total Posts:  1
Joined:  2012-07-21
 

Trying to change Amasty/Finder module class Amasty_Finder_Model_Finder

function applyFilter()

$collection = Mage::getSingleton(’catalog/layer’)->getProductCollection();

$select = $collection->getSelect();

$select
->joinInner(array($alias=>$collection->getTable(’amfinder/map’)), $alias.’.pid=e.entity_id ‘, array(’value_id’,’pid’,’sku’,’import_universal’))
->where($alias.’.value_id = ?’, $id)

If i add the or where condition or even if i chaneg a condition to use
->where($alias.’.import_universal = ?’,1)

i get this error

a:5:{i:0;s:71:"Item (Mage_Catalog_Model_Product) with the same id “2462” already exist";i:1;s:5513:"#0

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top