cancel
Showing results for 
Search instead for 
Did you mean: 

PRODUCT SEARCH USING XMLCONNECT ON MOBILE aPP

   Did you know you can see the translated content as per your choice?

Translation is in progress. Please check again after few minutes.

PRODUCT SEARCH USING XMLCONNECT ON MOBILE aPP

Product search is not working on mobile app that uses xmlconnect and i get the following error log when I try to search for a product. I can't figure out whats wrong

 

a:5:{i:0;s:824:"SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.ti$
 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
 INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id='1' AND cat_index.visibility IN(3, 4) AND cat_index.category_id = '2' WHERE$
";i:1;s:2437:"#0 /var/www/html/includes/src/Varien_Db_Statement_Pdo_Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /var/www/html/includes/src/__default.php(65883): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /var/www/html/includes/src/__default.php(55072): Zend_Db_Statement->execute(Array)
#3 /var/www/html/includes/src/__default.php(56109): Zend_Db_Adapter_Abstract->query('SELECT `e`.*, `...', Array)
#4 /var/www/html/includes/src/__default.php(57047): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `e`.*, `...', Array)
#5 /var/www/html/includes/src/__default.php(55329): Varien_Db_Adapter_Pdo_Mysql->query('SELECT `e`.*, `...', Array)
#6 /var/www/html/includes/src/__default.php(32599): Zend_Db_Adapter_Abstract->fetchAll('SELECT `e`.*, `...', Array)
#7 /var/www/html/includes/src/Mage_Eav_Model_Entity_Collection_Abstract.php(1046): Varien_Data_Collection_Db->_fetchAll('SELECT `e`.*, `...')
#8 /var/www/html/includes/src/Mage_Eav_Model_Entity_Collection_Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract->_loadEntities(false, false)
#9 /var/www/html/includes/src/__default.php(31344): Mage_Eav_Model_Entity_Collection_Abstract->load()
#10 /var/www/html/includes/src/Mage_XmlConnect_Block_Catalog_Product_List.php(63): Varien_Data_Collection->getItems()
#11 /var/www/html/includes/src/Mage_XmlConnect_Block_Catalog_Search.php(69): Mage_XmlConnect_Block_Catalog_Product_List->getProductsXmlObject()
#12 /var/www/html/includes/src/__default.php(2617): Mage_XmlConnect_Block_Catalog_Search->_toHtml()
#13 /var/www/html/includes/src/__default.php(28827): Mage_Core_Block_Abstract->toHtml()
#14 /var/www/html/includes/src/__default.php(14306): Mage_Core_Model_Layout->getOutput()
#15 /var/www/html/app/code/core/Mage/XmlConnect/controllers/CatalogController.php(341): Mage_Core_Controller_Varien_Action->renderLayout()
#16 /var/www/html/includes/src/__default.php(14334): Mage_XmlConnect_CatalogController->searchDetailsAction()
#17 /var/www/html/includes/src/__default.php(18826): Mage_Core_Controller_Varien_Action->dispatch('searchDetails')
#18 /var/www/html/includes/src/__default.php(18356): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#19 /var/www/html/includes/src/__default.php(21292): Mage_Core_Controller_Varien_Front->dispatch()
#20 /var/www/html/app/Mage.php(683): Mage_Core_Model_App->run(Array)
#21 /var/www/html/index.php(85): Mage::run('', 'store')
#22 {main}";s:3:"url";s:34:"/xmlconnect/catalog/searchDetails/";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}