Magento Product Indexing Issue - SQL

We are having a problem where Magento will not index product flat data. Magento is also throwing an error when we try to add over 100 products to a group product. Here is the indexing error. [~/public_html/shell]# php ./[login to view URL] -reindex catalog_product_flat Product Flat Data index process unknown error: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`test_testm/#sql-6584_6aa1a6`, CONSTRAINT `FK_CAT_PRD_FLAT_1_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE ON )' in /home/test/public_html/lib/Zend/Db/Statement/[login to view URL] Stack trace: #0 /home/test/public_html/lib/Zend/Db/Statement/[login to view URL](228): PDOStatement->execute(Array) #1 /home/test/public_html/lib/Varien/Db/Statement/Pdo/[login to view URL](110): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/test/public_html/lib/Zend/Db/[login to view URL](300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3 /home/test/public_html/lib/Zend/Db/Adapter/[login to view URL](479): Zend_Db_Statement->execute(Array) #4 /home/test/public_html/lib/Zend/Db/Adapter/Pdo/[login to view URL](238): Zend_Db_Adapter_Abstract->query('ALTER TABLE `ca...', Array) #5 /home/test/public_html/lib/Varien/Db/Adapter/Pdo/[login to view URL](419): Zend_Db_Adapter_Pdo_Abstract->query('ALTER TABLE `ca...', Array) #6 /home/test/public_html/lib/Varien/Db/Adapter/Pdo/[login to view URL](340): Varien_Db_Adapter_Pdo_Mysql->query('ALTER TABLE `ca...') #7 /home/test/public_html/lib/Varien/Db/Adapter/Pdo/[login to view URL](2569): Varien_Db_Adapter_Pdo_Mysql->raw_query('ALTER TABLE `ca...') #8 /home/test/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/[login to view URL](816): Varien_Db_Adapter_Pdo_Mysql->addForeignKey('FK_CAT_PRD_FLAT...', 'catalog_product...', 'entity_id', 'catalog_product...', 'entity_id', 'CASCADE', 'CASCADE') #9 /home/test/public_html/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/[login to view URL](1390): Mage_Catalog_Model_Resource_Product_Flat_Indexer->prepareFlatTable(1) #10 /home/test/public_html/app/code/core/Mage/Catalog/Model/Product/Flat/[login to view URL](296): Mage_Catalog_Model_Resource_Product_Flat_Indexer->reindexAll() #11 /home/test/public_html/app/code/core/Mage/Catalog/Model/Product/Indexer/[login to view URL](336): Mage_Catalog_Model_Product_Flat_Indexer->reindexAll() #12 /home/test/public_html/app/code/core/Mage/Index/Model/[login to view URL](209): Mage_Catalog_Model_Product_Indexer_Flat->reindexAll() #13 /home/test/public_html/app/code/core/Mage/Index/Model/[login to view URL](255): Mage_Index_Model_Process->reindexAll() #14 /home/test/public_html/shell/[login to view URL](158): Mage_Index_Model_Process->reindexEverything() #15 /home/test/public_html/shell/[login to view URL](198): Mage_Shell_Compiler->run() #16 {main} Do not bid unless you can guarantee fixing this problem. We will not pay out the project without it fixed. You will have full cPanel access.