cancel
Showing results for 
Search instead for 
Did you mean: 

PRODUCT SEARCH USING XMLCONNECT ON MOBILE aPP

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";}