There has been an error processing your request

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`codingbooks`.`catalogsearch_result`, CONSTRAINT `FK_CATALOGSEARCH_RESULT_QUERY_ID_CATALOGSEARCH_QUERY_QUERY_ID` FOREIGN KEY (`query_id`) REFERENCES `catalogsearch_query` (`query_id`) ON DELET), query was: INSERT INTO `catalogsearch_result` SELECT 121347 AS `query_id`, `s`.`product_id`, MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE) + MATCH (bss_index.tag) AGAINST (:query IN BOOLEAN MODE) + MATCH (bss_index.categories) AGAINST (:query IN BOOLEAN MODE) + MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE) + MATCH (bss_index.tag) AGAINST (:query IN BOOLEAN MODE) + MATCH (bss_index.categories) AGAINST (:query IN BOOLEAN MODE) AS `relevance` FROM `catalogsearch_fulltext` AS `s`
 INNER JOIN `catalog_product_entity` AS `e` ON e.entity_id = s.product_id
 LEFT JOIN `bss_index` ON bss_index.product_id = s.product_id WHERE ((`s`.`data_index` LIKE '%e/m%' OR `bss_index`.`tag` LIKE '%e/m%' OR `bss_index`.`categories` LIKE '%e/m%') OR (MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE) OR MATCH (bss_index.tag) AGAINST (:query IN BOOLEAN MODE) OR MATCH (bss_index.categories) AGAINST (:query IN BOOLEAN MODE)) OR (`s`.`data_index` LIKE '%e/m%' OR `bss_index`.`tag` LIKE '%e/m%' OR `bss_index`.`categories` LIKE '%e/m%') OR (MATCH (s.data_index) AGAINST (:query IN BOOLEAN MODE) OR MATCH (bss_index.tag) AGAINST (:query IN BOOLEAN MODE) OR MATCH (bss_index.categories) AGAINST (:query IN BOOLEAN MODE))) ON DUPLICATE KEY UPDATE `relevance` = VALUES(`relevance`)
Trace: #0 /data/web/magento/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute() #1 /data/web/magento/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute() #2 /data/web/magento/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute() #3 /data/web/magento/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query() #4 /data/web/magento/lib/Varien/Db/Adapter/Pdo/Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query() #5 /data/web/magento/app/code/community/TBT/Bss/Model/CatalogSearch/Mysql4/Fulltext.php(317): Varien_Db_Adapter_Pdo_Mysql->query() #6 /data/web/magento/app/code/community/TBT/Bss/Model/CatalogSearch/Mysql4/Fulltext.php(88): TBT_Bss_Model_CatalogSearch_Mysql4_Fulltext->insertSearchData() #7 /data/web/magento/app/code/community/TBT/Bss/Model/CatalogSearch/Fulltext.php(49): TBT_Bss_Model_CatalogSearch_Mysql4_Fulltext->prepareResult() #8 /data/web/magento/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext/Collection.php(147): TBT_Bss_Model_CatalogSearch_Fulltext->prepareResult() #9 /data/web/magento/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext/Collection.php(126): Mage_CatalogSearch_Model_Resource_Fulltext_Collection->getFoundIds() #10 /data/web/magento/app/code/core/Mage/CatalogSearch/Model/Resource/Fulltext/Collection.php(113): Mage_CatalogSearch_Model_Resource_Fulltext_Collection->_applySearchFilters() #11 /data/web/magento/app/code/core/Mage/CatalogSearch/Block/Result.php(186): Mage_CatalogSearch_Model_Resource_Fulltext_Collection->getSize() #12 /data/web/magento/app/code/local/Blr/Base/Block/Rewrite/CatalogSearch/Result.php(8): Mage_CatalogSearch_Block_Result->getResultCount() #13 /data/web/magento/app/code/core/Mage/Core/Block/Abstract.php(922): Blr_Base_Block_Rewrite_CatalogSearch_Result->_beforeToHtml() #14 /data/web/magento/app/code/core/Mage/Core/Block/Text/List.php(43): Mage_Core_Block_Abstract->toHtml() #15 /data/web/magento/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Text_List->_toHtml() #16 /data/web/magento/app/code/core/Mage/Core/Block/Abstract.php(641): Mage_Core_Block_Abstract->toHtml() #17 /data/web/magento/app/code/core/Mage/Core/Block/Abstract.php(585): Mage_Core_Block_Abstract->_getChildHtml() #18 /data/web/magento/app/design/frontend/cb/default/template/page/2columns-left.phtml(47): Mage_Core_Block_Abstract->getChildHtml() #19 /data/web/magento/app/code/core/Mage/Core/Block/Template.php(241): include('/data/web/magen...') #20 /data/web/magento/app/code/core/Mage/Core/Block/Template.php(272): Mage_Core_Block_Template->fetchView() #21 /data/web/magento/app/code/core/Mage/Core/Block/Template.php(286): Mage_Core_Block_Template->renderView() #22 /data/web/magento/app/code/core/Mage/Core/Block/Abstract.php(923): Mage_Core_Block_Template->_toHtml() #23 /data/web/magento/app/code/core/Mage/Core/Model/Layout.php(555): Mage_Core_Block_Abstract->toHtml() #24 /data/web/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(390): Mage_Core_Model_Layout->getOutput() #25 /data/web/magento/app/code/local/Blr/Base/controllers/Catalogsearch/ResultController.php(89): Mage_Core_Controller_Varien_Action->renderLayout() #26 /data/web/magento/app/code/core/Mage/Core/Controller/Varien/Action.php(418): Blr_Base_Catalogsearch_ResultController->indexAction() #27 /data/web/magento/app/code/core/Mage/Core/Controller/Varien/Router/Standard.php(254): Mage_Core_Controller_Varien_Action->dispatch() #28 /data/web/magento/app/code/core/Mage/Core/Controller/Varien/Front.php(172): Mage_Core_Controller_Varien_Router_Standard->match() #29 /data/web/magento/app/code/core/Mage/Core/Model/App.php(365): Mage_Core_Controller_Varien_Front->dispatch() #30 /data/web/magento/app/Mage.php(686): Mage_Core_Model_App->run() #31 /data/web/magento/index.php(95): Mage::run() #32 {main}

Error log record number: 712057102783