Magento Forum

   
Search just stopped working. 
 
nickdev
Jr. Member
 
Total Posts:  12
Joined:  2008-08-06
 

I just finished uploading new products and my search now throws an error reprinted below.

The batch upload was not completely successful - i can’t see anything wrong with the 3 rows that didn’t upload. So, I’m not sure if it is related or coincidental.

Everything else on the site seems to be fine. Any ideas?

SELECT `e`.*, `_table_website_id`.`website_id`, IFNULL(_table_status.value_table_status_default.value) AS `status`, IFNULL(_table_visibility.value_table_visibility_default.value) AS `visibility`, IFNULL(_table_name.value_table_name_default.value) AS `nameFROM `catalog_product_entity` AS `e`
 
INNER JOIN `catalog_product_website` AS `_table_website_idON (_table_website_id.product_id=e.entity_id) AND (_table_website_id.website_id=1)
 
INNER JOIN `catalog_product_entity_int` AS `_table_status_defaultON (_table_status_default.entity_id e.entity_id) AND (_table_status_default.attribute_id='69') AND _table_status_default.store_id=0
 LEFT JOIN 
`catalog_product_entity_int` AS `_table_statusON (_table_status.entity_id e.entity_id) AND (_table_status.attribute_id='69') AND (_table_status.store_id='1')
 
INNER JOIN `catalog_product_entity_int` AS `_table_visibility_defaultON (_table_visibility_default.entity_id e.entity_id) AND (_table_visibility_default.attribute_id='74') AND _table_visibility_default.store_id=0
 LEFT JOIN 
`catalog_product_entity_int` AS `_table_visibilityON (_table_visibility.entity_id e.entity_id) AND (_table_visibility.attribute_id='74') AND (_table_visibility.store_id='1')
 
INNER JOIN `catalog_product_entity_varchar` AS `_table_name_defaultON (_table_name_default.entity_id e.entity_id) AND (_table_name_default.attribute_id='45') AND _table_name_default.store_id=0
 LEFT JOIN 
`catalog_product_entity_varchar` AS `_table_nameON (_table_name.entity_id e.entity_id) AND (_table_name.attribute_id='45') AND (_table_name.store_id='1'WHERE (e.entity_type_id '4') AND (e.entity_id in (SELECT `catalog_product_entity`.`entity_idFROM `catalog_product_entityWHERE (sku LIKE :sku_search_queryUNION SELECT `t1`.`entity_idFROM `catalog_product_entity_text` AS `t1`
 
LEFT JOIN `catalog_product_entity_text` AS `t2ON t1.entity_id t2.entity_id AND t1.attribute_id t2.attribute_id AND t2.store_id='1' WHERE (t1.attribute_id IN ('46''47')) AND (t1.store_id 0) AND (IFNULL(t2.valuet1.valueLIKE :catalog_product_entity_text_search_queryUNION SELECT `t1`.`entity_idFROM `catalog_product_entity_varchar` AS `t1`
 
LEFT JOIN `catalog_product_entity_varchar` AS `t2ON t1.entity_id t2.entity_id AND t1.attribute_id t2.attribute_id AND t2.store_id='1' WHERE (t1.attribute_id IN ('45')) AND (t1.store_id 0) AND (IFNULL(t2.valuet1.valueLIKE :catalog_product_entity_varchar_search_query))) AND (IFNULL(_table_status.value_table_status_default.valuein (1)) AND (IFNULL(_table_visibility.value_table_visibility_default.valuein (34)) ORDER BY `nameasc LIMIT 60


Trace
:
#0 /home/public_html/store/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/public_html/store/lib/Zend/Db/Adapter/Abstract.php(406): Zend_Db_Statement->execute(Array)
#2 /home/public_html/store/lib/Zend/Db/Adapter/Pdo/Abstract.php(206): Zend_Db_Adapter_Abstract->query(Object(Varien_Db_Select), Array)
#3 /home/public_html/store/lib/Zend/Db/Adapter/Abstract.php(617): Zend_Db_Adapter_Pdo_Abstract->query(Object(Varien_Db_Select), Array)
#4 /home/public_html/store/lib/Varien/Data/Collection/Db.php(657): Zend_Db_Adapter_Abstract->fetchAll(Object(Varien_Db_Select), Array)
#5 /home/public_html/store/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(838): Varien_Data_Collection_Db->_fetchAll(Object(Varien_Db_Select))
#6 /home/public_html/store/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(696): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#7 /home/public_html/store/app/code/core/Mage/Catalog/Block/Product/List.php(112): Mage_Eav_Model_Entity_Collection_Abstract->load()
#8 /home/public_html/store/app/code/core/Mage/Core/Block/Abstract.php(553): Mage_Catalog_Block_Product_List->_beforeToHtml()
#9 /home/public_html/store/app/code/core/Mage/Core/Block/Abstract.php(431): Mage_Core_Block_Abstract->toHtml()
#10 /home/public_html/store/app/code/core/Mage/Core/Block/Abstract.php(408): Mage_Core_Block_Abstract->_getChildHtml('search_result_l...', true)
#11 /home/public_html/store/app/code/core/Mage/CatalogSearch/Block/Result.php(77): Mage_Core_Block_Abstract->getChildHtml('search_result_l...')
#12 /home/public_html/store/app/design/frontend/default/default/template/catalogsearch/result.phtml(26): Mage_CatalogSearch_Block_Result->getProductListHtml()
#13 /home/public_html/store/app/code/core/Mage/Core/Block/Template.php(131): include('/home/p...')
#14 /home/public_html/store/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#15 /home/public_html/store/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#16 /home/public_html/store/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#17 /home/public_html/store/app/code/core/Mage/Core/Block/Text/List.php(37): Mage_Core_Block_Abstract->toHtml()
#18 /home/public_html/store/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Text_List->_toHtml()
#19 /home/public_html/store/app/code/core/Mage/Core/Block/Abstract.php(431): Mage_Core_Block_Abstract->toHtml()
#20 /home/public_html/store/app/code/core/Mage/Core/Block/Abstract.php(408): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#21 /home/public_html/store/app/design/frontend/default/default/template/page/3columns.phtml(54): Mage_Core_Block_Abstract->getChildHtml('content')
#22 /home/public_html/store/app/code/core/Mage/Core/Block/Template.php(131): include('/home/p...')
#23 /home/public_html/store/app/code/core/Mage/Core/Block/Template.php(163): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#24 /home/public_html/store/app/code/core/Mage/Core/Block/Template.php(180): Mage_Core_Block_Template->renderView()
#25 /home/public_html/store/app/code/core/Mage/Core/Block/Abstract.php(554): Mage_Core_Block_Template->_toHtml()
#26 /home/public_html/store/app/code/core/Mage/Core/Model/Layout.php(505): Mage_Core_Block_Abstract->toHtml()
#27 /home/public_html/store/app/code/core/Mage/Core/Controller/Varien/Action.php(319): Mage_Core_Model_Layout->getOutput()
#28 /home/public_html/store/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(51): Mage_Core_Controller_Varien_Action->renderLayout()
#29 /home/public_html/store/app/code/core/Mage/Core/Controller/Varien/Action.php(342): Mage_CatalogSearch_ResultController->indexAction()
#30 /home/public_html/store/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(159): Mage_Core_Controller_Varien_Action->dispatch('index')
#31 /home/public_html/store/app/code/core/Mage/Core/Controller/Varien/Front.php(146): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#32 /home/public_html/store/app/Mage.php(427): Mage_Core_Controller_Varien_Front->dispatch()
#33 /home/public_html/store/index.php(43): Mage::run()
#34 {main}

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