cancel
Showing results for 
Search instead for 
Did you mean: 

Search system not work

Search system not work

Rapazes,

Eu preciso de ajuda, quando eu inserir qualquer coisa na barra de pesquisa,

o próximo show da página

 

a: 5: {i: 0; s: 1469: "SELECIONE` e`. *, `search_result`.`relevance`,` price_index`.`price`, `price_index`.`tax_class_id`,` price_index`.` final_price`, IF (price_index.tier_price IS NOT NULL, MENOS (price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`,` price_index`.`min_price`, `price_index`.`max_price`,` price_index `.`tier_price`,` cat_index`.`position` COMO `cat_index_position`,` _inventory_table`.`is_in_stock`, `_ventual_table```manage_stock`, (CASE WHEN (((_inventory_table.use_config_manage_stock = 1) AND (_inventory_table. is_in_stock = 1)) OU ((_inventory_table.use_config_manage_stock = 0) AND (1 - _inventory_table.manage_stock + _inventory_table.is_in_stock> = 1))) ENCONTRO 1 ELSE 0 END) COMO `is_outofstock` FROM` catalog_product_entity` AS `e` INNER JOIN `catalogsearch_result` COMO` search_result` ON search_result.product_id = e.entity_id AND search_result.query_id = '8' INNER JOIN `catalog_product_index_price` COMO` price_index` ON price_index.entity_id = e.entity_id E price_index.website_id = '1' E price_index.customer_group_id = 0 INNER JOIN `catalog_category_product_index` COMO` cat_index` ON cat_index.product_id = e.entity_id AND cat_index.store_id = '1' e cat_index.visibility IN (3, 4) E cat_index.category_id = '2' LEFT JOIN `cataloginventory_stock_item` COMO '_inventory_table` ON _inventory_table.product_id = e.entity_id WHERE ((1 = 1) OU (o preço final é NULL)) ORDEM POR` is_outofstock` DESC, `on_top` DESC,` relevance` desc LIMIT 12
"; i: 1; s: 6065:" # 0 /home/hg7so680/public_html/lojakok.com.br/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo -> _ execute (Array)# 1 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql -> _ execute (Array)# 2 /home/hg7so680/public_html/lojakok.com.br/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement-> execute (Array)# 3 /home/hg7so680/public_html/lojakok.com.br/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract-> query ('SELECT `e`. *,` ...' , Array)# 4 /home/hg7so680/public_html/lojakok.com.br/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract-> consulta ('SELECIONAR `e`. *,` ...' , Array)# 5 /home/hg7so680/public_html/lojakok.com.br/lib/Zend/Db/Adapter/Abstract.php(737): Varien_Db_Adapter_Pdo_Mysql-> query ('SELECIONAR `e`. *,` ...', Array )# 6 /home/hg7so680/public_html/lojakok.com.br/lib/Varien/Data/Collection/Db.php(740): Zend_Db_Adapter_Abstract-> fetchAll ('SELECIONAR `e`. *,` ...', Array )# 7 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(1045): Varien_Data_Collection_Db -> _ fetchAll ('SELECIONAR `e`. * , `... ')# 8 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Eav/Model/Entity/Collection/Abstract.php(871): Mage_Eav_Model_Entity_Collection_Abstract -> _ loadEntities (falso, falso)# 9 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Review/Model/Observer.php(78): Mage_Eav_Model_Entity_Collection_Abstract-> load ()# 10 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Model/App.php(1358): Mage_Review_Model_Observer-> catalogBlockProductCollectionBeforeToHtml (Object (Varien_Event_Observer))# 11 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Model/App.php(1331): Mage_Core_Model_App -> _ callObserverMethod (Objeto (Mage_Review_Model_Observer), 'catalogBlockPro ...' , Object (Varien_Event_Observer))# 12 /home/hg7so680/public_html/lojakok.com.br/app/Mage.php(448): Mage_Core_Model_App-> dispatchEvent ('catalog_block_p ...', Array)# 13 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Catalog/Block/Product/List.php(165): Mage :: dispatchEvent ('catalog_block_p ...', Array)# 14 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Abstract.php(918): Mage_Catalog_Block_Product_List -> _ beforeToHtml ()# 15 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract-> toHtml ()# 16 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract -> _ getChildHtml ('search_result_l ...', true)# 17 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/CatalogSearch/Block/Result.php(161): Mage_Core_Block_Abstract-> getChildHtml ('search_result_l ...')# 18 /home/hg7so680/public_html/lojakok.com.br/app/design/frontend/base/default/template/catalogsearch/result.phtml(42): Mage_CatalogSearch_Block_Result-> getProductListHtml ()# 19 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Template.php(241): include ('/ home / hg7so680 / ...')# 20 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template-> fetchView ('frontend / base / d ...')# 21 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template-> renderView ()# 22 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template -> _ toHtml ()# 23 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract-> toHtml ()# 24 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Text_List -> _ toHtml ()# 25 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Abstract.php(637): Mage_Core_Block_Abstract-> toHtml ()# 26 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Abstract.php(581): Mage_Core_Block_Abstract -> _ getChildHtml ('content', true)# 27 /home/hg7so680/public_html/lojakok.com.br/app/design/frontend/smartwave/porto/template/page/2columns-left.phtml(50): Mage_Core_Block_Abstract-> getChildHtml ('conteúdo')# 28 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Template.php(241): include ('/ home / hg7so680 / ...')# 29 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template-> fetchView ('frontend / smartw ...')# 30 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template-> renderView ()# 31 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Block/Abstract.php(919): Mage_Core_Block_Template -> _ toHtml ()# 32 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract-> toHtml ()# 33 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout-> getOutput ()# 34 /home/hg7so680/public_html/lojakok.com.br/app/code/local/Smartwave/Ajaxcatalog/controllers/CatalogSearch/ResultController.php(99): Mage_Core_Controller_Varien_Action-> renderLayout ()# 35 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Smartwave_Ajaxcatalog_CatalogSearch_ResultController-> indexAction ()# 36 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action-> dispatch ('index')# 37 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard-> match (Object (Mage_Core_Controller_Request_Http))# 38 /home/hg7so680/public_html/lojakok.com.br/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front-> despachar ()# 39 /home/hg7so680/public_html/lojakok.com.br/app/Mage.php(684): Mage_Core_Model_App-> run (Array)# 40 /home/hg7so680/public_html/lojakok.com.br/index.php(83): Mage :: run ('', 'store')# 41 {main} "; s: 3:" url "; s: 31:" / catalogsearch / result /? Q = teste + "; s: 11:" script_name "; s: 10:" / index.php "; s: 4: "skin"; s: 9: "portugues";}
1 REPLY

Re: Search system not work

Oi valterjrf,

 

Tenta o seguinte, vai no banco de dados, duplica a tabela catalogsearch_fulltext ou faz um backup dela. Após isso da um trucate com o comando abaixo:

 

TRUNCATE TABLE catalogsearch_fulltext;

Limpa o cache e testa novamente.

 

Canal Mestre Magento!
Toda Segunda e Quinta um novo vídeo!