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 3

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

Welcome to the Magento Forums. Remember to introduce yourself and read the Magento Forums Guidelines.

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