Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

admin search not work
 
G_Mehta
Guru
 
Avatar
Total Posts:  418
Joined:  2010-01-27
India
 

hi, guys

please note i used magento 1.3.2.4.

internal search not working at admin side in my site,
this will happen second time.. currently i am rebuild it. so it should work fine ..
but what is permanent solution for this…

it give following error while searching…

SQLSTATE[HY000]: General error: 145 Table ‘./my DB/catalogsearch_fulltext’ is marked as crashed and should be repaired

#0 /home/efashion/public_html/lib/Zend/Db/Statement.php(283): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/efashion/public_html/lib/Zend/Db/Adapter/Abstract.php(457): Zend_Db_Statement->execute(Array)
#2 /home/efashion/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(230): Zend_Db_Adapter_Abstract->query(’REPLACE INTO `c...’, Array)
#3 /home/efashion/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(281): Zend_Db_Adapter_Pdo_Abstract->query(’REPLACE INTO `c...’, Array)
#4 /home/efashion/public_html/app/code/core/Mage/CatalogSearch/Model/Mysql4/Fulltext.php(309): Varien_Db_Adapter_Pdo_Mysql->query(’REPLACE INTO `c...’, Array)
#5 /home/efashion/public_html/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(110): Mage_CatalogSearch_Model_Mysql4_Fulltext->prepareResult(Object(Mage_CatalogSearch_Model_Fulltext), ‘skiny original ...’, Object(Mage_CatalogSearch_Model_Query))
#6 /home/efashion/public_html/app/code/core/Mage/CatalogSearch/Model/Mysql4/Fulltext/Collection.php(49): Mage_CatalogSearch_Model_Fulltext->prepareResult()
#7 /home/efashion/public_html/app/code/core/Mage/CatalogSearch/Model/Layer.php(59): Mage_CatalogSearch_Model_Mysql4_Fulltext_Collection->addSearchFilter(’skiny original ...’)
#8 /home/efashion/public_html/app/code/core/Mage/CatalogSearch/Model/Layer.php(43): Mage_CatalogSearch_Model_Layer->prepareProductCollection(Object(Mage_CatalogSearch_Model_Mysql4_Fulltext_Collection))
#9 /home/efashion/public_html/app/code/core/Mage/Catalog/Model/Layer.php(293): Mage_CatalogSearch_Model_Layer->getProductCollection()
#10 /home/efashion/public_html/app/code/core/Mage/Catalog/Model/Layer.php(220): Mage_Catalog_Model_Layer->_getSetIds()
#11 /home/efashion/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(90): Mage_Catalog_Model_Layer->getFilterableAttributes()
#12 /home/efashion/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(53): Mage_Catalog_Block_Layer_View->_getFilterableAttributes()
#13 /home/efashion/public_html/app/code/core/Mage/Core/Block/Abstract.php(199): Mage_Catalog_Block_Layer_View->_prepareLayout()
#14 /home/efashion/public_html/app/code/core/Mage/Core/Model/Layout.php(445): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#15 /home/efashion/public_html/app/code/core/Mage/Core/Model/Layout.php(229): Mage_Core_Model_Layout->addBlock(’Mage_CatalogSea...’, ‘catalogsearch.l...’)
#16 /home/efashion/public_html/app/code/core/Mage/Core/Model/Layout.php(195): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#17 /home/efashion/public_html/app/code/core/Mage/Core/Model/Layout.php(200): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#18 /home/efashion/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(303): Mage_Core_Model_Layout->generateBlocks()
#19 /home/efashion/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(231): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#20 /home/efashion/public_html/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(77): Mage_Core_Controller_Varien_Action->loadLayout()
#21 /home/efashion/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(376): Mage_CatalogSearch_ResultController->indexAction()
#22 /home/efashion/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(248): Mage_Core_Controller_Varien_Action->dispatch(’index’)
#23 /home/efashion/public_html/app/code/core/Mage/Core/Controller/Varien/Front.php(158): Mage_Core_Controller_Varien_Router_Standard->match(Object(Mage_Core_Controller_Request_Http))
#24 /home/efashion/public_html/app/Mage.php(459): Mage_Core_Controller_Varien_Front->dispatch()
#25 /home/efashion/public_html/index.php(83): Mage::run()
#26 {main}

please help me to came out this error.

thanks

 
Magento Community Magento Community
Magento Community
Magento Community
 
Tom Robertshaw
Guru
 
Avatar
Total Posts:  485
Joined:  2009-05-17
Bath, UK
 

Hi,

It seems another forum user has had a similar error in the past: http://www.magentocommerce.com/boards/viewthread/39120/

Do you have a database frontend application like phpmyadmin or perhaps options in a cpanel hosting account in order to perform a database repair?  This looks like it might solve your issue.  Alternatively you can always use mysql cli to do a database repair.

Hope that helps,

Tom

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top