Discussion :

[Eva06]

Bonjour,

Je suis sur la version 1.9 de Magento. J'ai mis il y a quelques temps un module permettant de faire fonctionner la recherche correctement, et pas avoir un résultat incohérent : Catalogue Research Refinement
Depuis 2-3 jours, lorsque l'on fait une recherche, j'ai un message d'erreur de Magento, comme si le site plantait... J'ai alors enlevé le module ainsi que tous ceux portant sur la recherche mais toujours rien.
Je dois refresh l'index correspondant mais impossible de le faire...
J'ai désactiver le module Mage_CatalogSearch et réactivé mais toujours rien.
J'ai également vidé tous les mots de recherche déjà utilisé.

Quelqu'un aurait une solution ?

Le rapport :

a:5:{i:0;s:129:"SQLSTATE[HY000]: General error: 145 Table './cosplayh_cosplay/catalogsearch_fulltext' is marked as crashed and should be repaired";i:1;s:4198:"
#0 /home/cosplayh/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/cosplayh/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 /home/cosplayh/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/cosplayh/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `ca...', Array)
#4 /home/cosplayh/public_html/lib/Varien/Db/Adapter/Pdo/Mysql.php(428): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `ca...', Array)
#5 /home/cosplayh/public_html/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext.php(393): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `ca...', Array)
#6 /home/cosplayh/public_html/app/code/core/Mage/CatalogSearch/Model/Fulltext.php(136): Mage_CatalogSearch_Model_Resource_Fulltext->prepareResult(Object(Mage_CatalogSearch_Model_Fulltext), 'worbla', Object(Mage_CatalogSearch_Model_Query))
#7 /home/cosplayh/public_html/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext/Collection.php(55): Mage_CatalogSearch_Model_Fulltext->prepareResult()
#8 /home/cosplayh/public_html/app/code/core/Mage/CatalogSearch/Model/Layer.php(58): Mage_CatalogSearch_Model_Resource_Fulltext_Collection->addSearchFilter('worbla')
#9 /home/cosplayh/public_html/app/code/core/Mage/CatalogSearch/Model/Layer.php(42): Mage_CatalogSearch_Model_Layer->prepareProductCollection(Object(Mage_CatalogSearch_Model_Resource_Fulltext_Collection))
#10 /home/cosplayh/public_html/app/code/core/Mage/Catalog/Model/Layer.php(290): Mage_CatalogSearch_Model_Layer->getProductCollection()
#11 /home/cosplayh/public_html/app/code/core/Mage/Catalog/Model/Layer.php(220): Mage_Catalog_Model_Layer->_getSetIds()
#12 /home/cosplayh/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(163): Mage_Catalog_Model_Layer->getFilterableAttributes()
#13 /home/cosplayh/public_html/app/code/core/Mage/Catalog/Block/Layer/View.php(122): Mage_Catalog_Block_Layer_View->_getFilterableAttributes()
#14 /home/cosplayh/public_html/app/code/core/Mage/Core/Block/Abstract.php(293): Mage_Catalog_Block_Layer_View->_prepareLayout()
#15 /home/cosplayh/public_html/app/code/core/Mage/Core/Model/Layout.php(456): Mage_Core_Block_Abstract->setLayout(Object(Mage_Core_Model_Layout))
#16 /home/cosplayh/public_html/app/code/core/Mage/Core/Model/Layout.php(472): Mage_Core_Model_Layout->createBlock('catalogsearch/l...', 'catalogsearch.l...')
#17 /home/cosplayh/public_html/app/code/core/Mage/Core/Model/Layout.php(239): Mage_Core_Model_Layout->addBlock('catalogsearch/l...', 'catalogsearch.l...')
#18 /home/cosplayh/public_html/app/code/core/Mage/Core/Model/Layout.php(205): Mage_Core_Model_Layout->_generateBlock(Object(Mage_Core_Model_Layout_Element), Object(Mage_Core_Model_Layout_Element))
#19 /home/cosplayh/public_html/app/code/core/Mage/Core/Model/Layout.php(210): Mage_Core_Model_Layout->generateBlocks(Object(Mage_Core_Model_Layout_Element))
#20 /home/cosplayh/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(344): Mage_Core_Model_Layout->generateBlocks()
#21 /home/cosplayh/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(269): Mage_Core_Controller_Varien_Action->generateLayoutBlocks()
#22 /home/cosplayh/public_html/app/code/core/Mage/CatalogSearch/controllers/ResultController.php(77): Mage_Core_Controller_Varien_Action->loadLayout()
#23 /home/cosplayh/public_html/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Mage_CatalogSearch_ResultController->indexAction()
#24 /home/cosplayh/public_html/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(250): Mage_Core_Controller_Varien_Action->dispatch('index')
#25 /home/cosplayh/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))
#26 /home/cosplayh/public_html/app/code/core/Mage/Core/Model/App.php(354): Mage_Core_Controller_Varien_Front->dispatch()
#27 /home/cosplayh/public_html/app/Mage.php(684): Mage_Core_Model_App->run(Array)
#28 /home/cosplayh/public_html/index.php(87): Mage::run('', 'store')
#29 {main}";s:3:"url";s:41:"/index.php/catalogsearch/result/?q=worbla";s:11:"script_name";s:10:"/index.php";s:4:"skin";s:7:"default";}

[NoSmoking]

Bonjour,
le message

a:5:{i:0;s:129:"SQLSTATE[HY000]: General error: 145 Table './cosplayh_cosplay/catalogsearch_fulltext' is marked as crashed and should be repaired";i:1;s:4198:"

ne te parais pas assez clair ?