Troubleshoot Magento Indexing Error

Hi, We have a very old Magento 1.6 site and we are trying to Reindex through command line and getting these errors: PHP Deprecated: Comments starting with '#' are deprecated in /usr/local/lib/[login to view URL] on line 431 in Unknown on line 0 Product Flat Data index process unknown error: exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs' in /home/dddsite/public_html/oldgreen/lib/Zend/Db/Statement/[login to view URL] Stack trace: #0 /home/dddsite/public_html/oldgreen/lib/Zend/Db/Statement/[login to view URL](228): PDOStatement->execute(Array) #1 /home/dddsite/public_html/oldgreen/lib/Varien/Db/Statement/Pdo/[login to view URL](110): Zend_Db_Statement_Pdo->_execute(Array) #2 /home/dddsite/public_html/oldgreen/lib/Zend/Db/[login to view URL](300): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3 /home/dddsite/public_html/oldgreen/lib/Zend/Db/Adapter/[login to view URL](479): Zend_Db_Statement->execute(Array) #4 /home/dddsite/public_html/oldgreen/lib/Zend/Db/Adapter/Pdo/[login to view URL](238): Zend_Db_Adapter_Abstract->query('ALTER TABLE `ca...', Array) #5 /home/dddsite/public_html/oldgreen/lib/Varien/Db/Adapter/Pdo/[login to view URL](389): Zend_Db_Adapter_Pdo_Abstract->query('ALTER TABLE `ca...', Array) #6 /home/dddsite/public_html/oldgreen/lib/Varien/Db/Adapter/Pdo/[login to view URL](327): Varien_Db_Adapter_Pdo_Mysql->query('ALTER TABLE `ca...') #7 /home/dddsite/public_html/oldgreen/lib/Varien/Db/Adapter/Pdo/[login to view URL](822): Varien_Db_Adapter_Pdo_Mysql->raw_query('ALTER TABLE `ca...') #8 /home/dddsite/public_html/oldgreen/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/[login to view URL](789): Varien_Db_Adapter_Pdo_Mysql->addColumn('catalog_product...', 'women_new_dem_l...', Array) #9 /home/dddsite/public_html/oldgreen/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/[login to view URL](125): Mage_Catalog_Model_Resource_Product_Flat_Indexer->prepareFlatTable(1) #10 /home/dddsite/public_html/oldgreen/app/code/core/Mage/Catalog/Model/Resource/Product/Flat/[login to view URL](115): Mage_Catalog_Model_Resource_Product_Flat_Indexer->rebuild('1') #11 /home/dddsite/public_html/oldgreen/app/code/core/Mage/Catalog/Model/Product/Flat/[login to view URL](73): Mage_Catalog_Model_Resource_Product_Flat_Indexer->rebuild(NULL) #12 /home/dddsite/public_html/oldgreen/app/code/core/Mage/Catalog/Model/Product/Indexer/[login to view URL](303): Mage_Catalog_Model_Product_Flat_Indexer->rebuild() #13 /home/dddsite/public_html/oldgreen/app/code/core/Mage/Index/Model/[login to view URL](166): Mage_Catalog_Model_Product_Indexer_Flat->reindexAll() #14 /home/dddsite/public_html/oldgreen/app/code/core/Mage/Index/Model/[login to view URL](194): Mage_Index_Model_Process->reindexAll() #15 /home/dddsite/public_html/oldgreen/shell/[login to view URL](158): Mage_Index_Model_Process->reindexEverything() #16 /home/dddsite/public_html/oldgreen/shell/[login to view URL](198): Mage_Shell_Compiler->run() #17 {main} In the back end of Magento the Product Flat data index is stuck. We've tried several things, with no luck. I know this is because we have a lot of attributes or attribute options. I think there may be some limit in MySQL or PHP. Can you help me troubleshoot this?