Troubleshoot Magento Indexing Error


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?

Taidot: Linux, Magento, MySQL, PHP, Zend

Näytä lisää: magento indexing error category flat data, magento category flat data indexing error, magento cms error, php, mysql, html, website design, magento, wordpress, shopping carts, magento developer, e-commerce, magento paypal error checkout, magento category error product, magento fatal error redeclare _pear_call_destructors, magento categories error, magento category error, magento configuration error, magento custom error handler, magento pear error install

Tietoa työnantajasta:
( 5 arvostelua ) Atlanta, United States

Projektin tunnus: #16062174

20 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Hello Sir, I have gone through your requirements in brief and understand your idea and preference for job as you are looking for. I have more than 5+ years of experience in Magento. I have developed more than 100 w Lisää

$54 USD 1 päivässä
(526 arvostelua)

A proposal has not yet been provided

$50 USD 1 päivässä
(223 arvostelua)

Hello >> I have checked your requirement clearly and ready to move forward with work. >> will resolve command line error >> will resolve Magento the Product Flat data index. >> i am working with magento 1x last Lisää

$70 USD 1 päivässä
(125 arvostelua)

Hi sir, Thank you for giving opportunity for biding... we have gone through your requirements and we can fix your magento indexing error according to your exact requirements. Please Before Awarding this projec Lisää

$35 USD 1 päivässä
(208 arvostelua)

A proposal has not yet been provided

$25 USD 1 päivässä
(300 arvostelua)

Hi can I help you ? I am magento developer and designer, I am interested to work with you, I will do this job, can we discuss ? waiting for your reply. bye.

$30 USD 1 päivässä
(151 arvostelua)

I can trouble shoot your magento indexing issue. I am Magento expert with more than 5 years of experience. Over this time period I have worked over more than 100 shopping store and developed many stores from scratch.

$30 USD 1 päivässä
(149 arvostelua)

Hello, I have read the project description and understand the requirement. I am interested and ready to start work on your project. you need magento developer to fix your site, I have 7+ year of experience in magent Lisää

$50 USD 1 päivässä
(104 arvostelua)
$25 USD 0 päivässä
(55 arvostelua)
$35 USD 1 päivässä
(142 arvostelua)

Hello Mate, Hope you are doing well !! I Am Magento Certified Developer. Certification URL :- [login to view URL] and Your job posting has caught my attention r Lisää

$30 USD 1 päivässä
(15 arvostelua)

Hello, I have 6+ year experience in Magento, Wordpress, PHP. Creation custom module, Magento extentions, Magento Theme Customization, Magenhaving to Theme Creation, Wordpress Plugin and many other task. 1) Wordpres Lisää

$30 USD 1 päivässä
(33 arvostelua)

Hello yes i can fix this please provide me some extra details I am a contemporary and excellent Website designer and developer with a focus on user-centered design while helping clients to achieve the desired resu Lisää

$50 USD 2 päivässä
(19 arvostelua)

A proposal has not yet been provided

$15 USD 1 päivässä
(77 arvostelua)

I noticed you were having problems with Magento and the DB, please let me know if I can help you with that.

$100 USD 0 päivässä
(13 arvostelua)

Dear Sir, I am magento bug fixing expet. I have solved this type of indexing issue before. Let me handle the issue for you and give you a quick output. Eagerly waiting to hear from you. kind regards Aminul

$25 USD 0 päivässä
(34 arvostelua)

Hello, Thank for looking my proposal I am ready to start work on your project. I have 6+ years of experience in “web development” with the specialized experience in MAGENTO, WORDPRESS, PHP, MYSQL, CSS3, HTML5, JAVASCR Lisää

$30 USD 1 päivässä
(10 arvostelua)

Hi there! Did go through your Job Description and glad to share that I have experience in working with php and Magento (1&2) platform.  I also have expertise with Joomla, WordPress, PHP, PHP Scripting, laravel and Code Lisää

$10 USD 2 päivässä
(17 arvostelua)
$27 USD 1 päivässä
(1 arvostelu)

Hello, Work Experience : Total 8+ Years I understand you are looking for an experienced person to work on your project. I am highly qualified Web Designer and Developer having 8+ years experience and  have comple Lisää

$25 USD 1 päivässä
(2 arvostelua)