cancel
Showing results for 
Search instead for 
Did you mean: 

catalog search index error

catalog search index error

Cannot initialize the indexer process for catalog search index

3 REPLIES

Re: catalog search index error

Hi @ABSenterprise,

 

 

The first question I have is:

Is this a production or development server?

Is it the local implementation of the Magento website in your local machine?


Best regards.
Gabriel

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".

Re: catalog search index error

Hello Gabriel,   I not sure to the two questions you asked. Where would i look to find that out for you?

Re: catalog search index error

I typed a word in the search box at the top of my site and I received this error.

 

There has been an error processing your request
SQLSTATE[HY000]: General error: 145 Table './advanced_mg1/catalogsearch_fulltext' is marked as crashed and should be repaired, query was: SELECT `s`.`product_id`, 0 AS `relevance` FROM `catalogsearch_fulltext` AS `s`
INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = s.product_id WHERE (s.store_id = 1) AND ((`s`.`data_index` LIKE '%dhea%'))

Trace:
#0 /home/advancedbodybuil/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/advancedbodybuil/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/advancedbodybuil/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/advancedbodybuil/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `s`.`pro...', Array)
#4 /home/advancedbodybuil/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('SELECT `s`.`pro...', Array)
#5 /home/advancedbodybuil/public_html/lib/Zend/Db/Adapter/Abstract.php(811): Varien_Db_Adapter_Pdo_Mysql->query(Object(Varien_Db_Select), Array)
#6 /home/advancedbodybuil/public_html/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php(383): Zend_Db_Adapter_Abstract->fetchPairs(Object(Varien_Db_Select), Array)
#7 /home/advancedbodybuil/public_html/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(136): Mage_CatalogSearch_Model_Resource_Fulltext->prepareResult(Object(Mage_CatalogSearch_Model_Fulltext), 'dhea', Object(Mage_CatalogSearch_Model_Query))
#8 /home/advancedbodybuil/public_html/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext/Collection.php(147): Mage_CatalogSearch_Model_Fulltext->prepareResult()
#9 /home/advancedbodybuil/public_html/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext/Collection.php(126): Mage_CatalogSearch_Model_Resource_Fulltext_Collection->getFoundIds()
#10 /home/advancedbodybuil/public_html/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext/Collection.php(113): Mage_CatalogSearch_Model_Resource_Fulltext_Collection->_applySearchFilters()
#11 /home/advancedbodybuil/public_html/app/code/core/Mage/CatalogSearch/Block/Result.php(186): Mage_CatalogSearch_Model_Resource_Fulltext_Collection->getSize()
#12 /home/advancedbodybuil/public_html/app/design/frontend/base/default/template/catalogsearch/result.phtml(27): Mage_CatalogSearch_Block_Result->getResultCount()
#13 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/advancedb...')
#14 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/base/d...')
#15 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#16 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#17 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml()
#18 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml()
#19 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml()
#20 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml('content', true)
#21 /home/advancedbodybuil/public_html/app/design/frontend/default/theme676/template/page/2columns-right.phtml(54): Mage_Core_Block_Abstract->getChildHtml('content')
#22 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Template.php(241): include('/home/advancedb...')
#23 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView('frontend/defaul...')
#24 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView()
#25 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml()
#26 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml()
#27 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput()
#28 /home/advancedbodybuil/public_html/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(80): Mage_Core_Controller_Varien_Action->renderLayout()
#29 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_CatalogSearch_ResultController->indexAction()
#30 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch('index')
#31 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#32 /home/advancedbodybuil/public_html/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch()
#33 /home/advancedbodybuil/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#34 /home/advancedbodybuil/public_html/index.php(83): Mage::run('', 'store')
#35 {main}

Error log record number: 955263670616