You are viewing an old revision of this post, from August 18, 2015 @ 16:05:33. See below for differences between this version and the current revision.

CANNOT INITIALIZE THE INDEXER PROCESS IN MAGENTO

This phrase gave me nightmares for days as I was building the new website.  We installed a ton of extensions to automate the website, and somewhere along the line some database tables got corrupted, so I had to start a what seemed like an endless game of cat and mouse chasing down what was really wrong with the site.  I’ve compiled a list of everything I tried along the way to fix the issue:

    1. Make sure the var/locks folder is writable.  Test out full permissions (chmod 777).
    2. Delete all of the .locks files from the var/locks folder.
    3. Backup your database, then run this query in phpmyadmin: DELETE FROM catalog_category_product_index;
    4. Try the magento cleanup tool 
    5. Try the magento database repair tool
    6. Backup your database and run this query in phpmyadmin:

       

      1. DELETE cpop.* FROM catalog_product_option_price AS cpop
      2. INNER JOIN catalog_product_option AS cpo
      3. ON cpo.option_id = cpop.option_id
      4. WHERE
      5. cpo.type = ‘checkbox’ OR
      6. cpo.type = ‘radio’ OR
      7. cpo.type = ‘drop_down’;DELETE cpotp.* FROM catalog_product_option_type_price AS cpotp
      8. INNER JOIN catalog_product_option_type_value AS cpotv
      9. ON cpotv.option_type_id = cpotp.option_type_id
      10. INNER JOIN catalog_product_option AS cpo
      11. ON cpotv.option_id = cpo.option_id
      12. WHERE
      13. cpo.type <> ‘checkbox’ AND
      14. cpo.type <> ‘radio’ AND
      15. cpo.type <> ‘drop_down’;

       

       

After running all of these options and still not having any luck in the admin, I decided to try and reindex by command line.  Just SSH into your site, and run this command:

  1. php /path/to/magento/shell/indexer.php reindexall

 

Magento will then start to run the reindex process, updating the command line as it progresses.  When it hits the error mark, it will show you what the actual error is.  In my case, this is what I got:

 

 

 

  1. Product Flat Data index process unknown error:
  2.  
  3. exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`alleight_bbcom/#sql-6d5d_2cb103`, 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/alleight/public_html/bbcom/lib/Zend/Db/Statement/Pdo.php:228

 

In the error, you can see that there’s a problem with the catalog product flat data.  We simply truncated the table catalog_flat_product_1, and voila.  Reindex successful.

Revisions

Revision Differences

August 18, 2015 @ 16:05:33Current Revision
Content
Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;"> Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;">
Unchanged: This phrase gave me nightmares for days as I was building the new&nbsp;website. &nbsp;We installed a ton of extensions to automate the website, and somewhere along the line some database tables got corrupted, so I had to start a what seemed like an endless game of cat and mouse chasing down what was really wrong with the site. &nbsp;I&rsquo;ve compiled a list of everything I tried along the way to fix the issue: Unchanged: This phrase gave me nightmares for days as I was building the new&nbsp;website. &nbsp;We installed a ton of extensions to automate the website, and somewhere along the line some database tables got corrupted, so I had to start a what seemed like an endless game of cat and mouse chasing down what was really wrong with the site. &nbsp;I&rsquo;ve compiled a list of everything I tried along the way to fix the issue:
Unchanged: </p> Unchanged: </p>
Unchanged: <ol style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; font-family: Abel; font-size: 20px; line-height: 24px;"> Unchanged: <ol style="box-sizing: border-box; margin-top: 0px; margin-bottom: 10px; font-family: Abel; font-size: 20px; line-height: 24px;">
Unchanged: <li> Unchanged: <li>
Unchanged: <ol style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px;"> Unchanged: <ol style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px;">
Unchanged: <li style="box-sizing: border-box;"> Unchanged: <li style="box-sizing: border-box;">
Unchanged: Make sure the var/locks folder is writable. &nbsp;Test out full permissions (chmod 777). Unchanged: Make sure the var/locks folder is writable. &nbsp;Test out full permissions (chmod 777).
Unchanged: </li> Unchanged: </li>
Unchanged: <li style="box-sizing: border-box;"> Unchanged: <li style="box-sizing: border-box;">
Unchanged: Delete all of the .locks files from the var/locks folder. Unchanged: Delete all of the .locks files from the var/locks folder.
Unchanged: </li> Unchanged: </li>
Unchanged: <li style="box-sizing: border-box;"> Unchanged: <li style="box-sizing: border-box;">
Unchanged: Backup your database, then run this query in phpmyadmin: DELETE FROM catalog_category_ product_index; Unchanged: Backup your database, then run this query in phpmyadmin: DELETE FROM catalog_category_ product_index;
Unchanged: </li> Unchanged: </li>
Unchanged: <li style="box-sizing: border-box;"> Unchanged: <li style="box-sizing: border-box;">
Unchanged: Try the&nbsp;<a href="http:// www.magentocommerce.com/wiki/ groups/227/resetting_file_ permissions" style="box-sizing: border-box; color: rgb(66, 139, 202); text-decoration: none; background: transparent;">magento cleanup tool&nbsp;</a> Unchanged: Try the&nbsp;<a href="http:// www.magentocommerce.com/wiki/ groups/227/resetting_file_ permissions" style="box-sizing: border-box; color: rgb(66, 139, 202); text-decoration: none; background: transparent;">magento cleanup tool&nbsp;</a>
Unchanged: </li> Unchanged: </li>
Unchanged: <li style="box-sizing: border-box;"> Unchanged: <li style="box-sizing: border-box;">
Unchanged: Try the magento database repair tool Unchanged: Try the magento database repair tool
Unchanged: </li> Unchanged: </li>
Unchanged: <li style="box-sizing: border-box;"> Unchanged: <li style="box-sizing: border-box;">
Unchanged: Backup your database and run this query in phpmyadmin: Unchanged: Backup your database and run this query in phpmyadmin:
  Added: <p>
  Added: &nbsp;
  Added: </p>
Unchanged: <div class="bwp-syntax-block clearfix" style="box-sizing: border-box; margin: 10px 0px; position: relative; color: rgb(0, 0, 0); font-size: 12px; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; zoom: 1;"> Unchanged: <div class="bwp-syntax-block clearfix" style="box-sizing: border-box; margin: 10px 0px; position: relative; color: rgb(0, 0, 0); font-size: 12px; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; zoom: 1;">
Unchanged: <div class="bwp-syntax-wrapper clearfix bwp-syntax-advanced" style="box-sizing: border-box; width: 687.5px; overflow: auto; position: relative; margin: 0px; zoom: 1; height: 252px;"> Unchanged: <div class="bwp-syntax-wrapper clearfix bwp-syntax-advanced" style="box-sizing: border-box; width: 687.5px; overflow: auto; position: relative; margin: 0px; zoom: 1; height: 252px;">
Unchanged: <div class="php" style="box-sizing: border-box; font-family: monospace; margin: 0px; zoom: 1;"> Unchanged: <div class="php" style="box-sizing: border-box; font-family: monospace; margin: 0px; zoom: 1;">
Unchanged: <ol style="box-sizing: border-box; margin: 0px; padding-right: 0px; padding-left: 0px;"> Unchanged: <ol style="box-sizing: border-box; margin: 0px; padding-right: 0px; padding-left: 0px;">
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: DELETE cpop<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.*</span>&nbsp;FROM catalog_product_ option_price&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpop Unchanged: DELETE cpop<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.*</span>&nbsp;FROM catalog_product_ option_price&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpop
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);"> Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);">
Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: INNER&nbsp;<span class="kw3" style="box-sizing: border-box; color: rgb(153, 0, 0);">JOIN</span> &nbsp;catalog_ product_option&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpo Unchanged: INNER&nbsp;<span class="kw3" style="box-sizing: border-box; color: rgb(153, 0, 0);">JOIN</span> &nbsp;catalog_ product_option&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpo
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: ON cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> option_id&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span> &nbsp;cpop<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span>option_id Unchanged: ON cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> option_id&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span> &nbsp;cpop<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span>option_id
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);"> Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);">
Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: WHERE Unchanged: WHERE
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; checkbox&rsquo; </span>&nbsp;OR Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; checkbox&rsquo; </span>&nbsp;OR
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);"> Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);">
Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; radio&rsquo;< /span>&nbsp;OR Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; radio&rsquo;< /span>&nbsp;OR
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; drop_down&rsquo; </span><span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">;</span>DELETE cpotp<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.*</span>&nbsp;FROM catalog_product_ option_type_price&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpotp Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; drop_down&rsquo; </span><span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">;</span>DELETE cpotp<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.*</span>&nbsp;FROM catalog_product_ option_type_price&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpotp
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);"> Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);">
Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: INNER&nbsp;<span class="kw3" style="box-sizing: border-box; color: rgb(153, 0, 0);">JOIN</span> &nbsp;catalog_ product_option_ type_value&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpotv Unchanged: INNER&nbsp;<span class="kw3" style="box-sizing: border-box; color: rgb(153, 0, 0);">JOIN</span> &nbsp;catalog_ product_option_ type_value&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpotv
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: ON cpotv<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> option_type_id&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span> &nbsp;cpotp<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> option_type_id Unchanged: ON cpotv<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> option_type_id&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span> &nbsp;cpotp<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> option_type_id
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);"> Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);">
Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: INNER&nbsp;<span class="kw3" style="box-sizing: border-box; color: rgb(153, 0, 0);">JOIN</span> &nbsp;catalog_ product_option&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpo Unchanged: INNER&nbsp;<span class="kw3" style="box-sizing: border-box; color: rgb(153, 0, 0);">JOIN</span> &nbsp;catalog_ product_option&nbsp;<span class="kw1" style="box-sizing: border-box; color: rgb(177, 177, 0);">AS</span>&nbsp;cpo
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: ON cpotv<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> option_id&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span> &nbsp;cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span>option_id Unchanged: ON cpotv<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> option_id&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">=</span> &nbsp;cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span>option_id
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);"> Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);">
Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: WHERE Unchanged: WHERE
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">&lt;&gt; </span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; checkbox&rsquo; </span>&nbsp;AND Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">&lt;&gt; </span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; checkbox&rsquo; </span>&nbsp;AND
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);"> Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);">
Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">&lt;&gt; </span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; radio&rsquo;< /span>&nbsp;AND Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">&lt;&gt; </span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; radio&rsquo;< /span>&nbsp;AND
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">&lt;&gt; </span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; drop_down&rsquo; </span><span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">;</span> Unchanged: cpo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span> type&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">&lt;&gt; </span>&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; drop_down&rsquo; </span><span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">;</span>
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: </ol> Unchanged: </ol>
Unchanged: </div> Unchanged: </div>
  Added: <p>
  Added: &nbsp;
  Added: </p>
Unchanged: </div> Unchanged: </div>
  Added: <p>
  Added: &nbsp;
  Added: </p>
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: </ol> Unchanged: </ol>
Unchanged: </li> Unchanged: </li>
Unchanged: </ol> Unchanged: </ol>
Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;"> Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;">
Unchanged: After running all of these options and still not having any luck in the admin, I decided to try and reindex by command line. &nbsp;Just SSH into your site, and run this command: Unchanged: After running all of these options and still not having any luck in the admin, I decided to try and reindex by command line. &nbsp;Just SSH into your site, and run this command:
Unchanged: </p> Unchanged: </p>
Unchanged: <div class="adsxpls" id="adsxpls2" style="box-sizing: border-box; font-family: Abel; font-size: 20px; line-height: 24px; padding: 7px 0px 7px 7px; float: right; margin: 0px;"> Unchanged: <div class="adsxpls" id="adsxpls2" style="box-sizing: border-box; font-family: Abel; font-size: 20px; line-height: 24px; padding: 7px 0px 7px 7px; float: right; margin: 0px;">
Unchanged: <ins class="adsbygoogle" data-ad-client= "ca-pub-0320443245290735" data-ad-slot="" data-adsbygoogle- status="done" id="adsgoogle2" style="box-sizing: border-box; display: inline-block; width: 336px; height: 280px;"><ins id="aswift_1_expand" style="box-sizing: border-box; display: inline-table; border: none; height: 280px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 336px; background-color: transparent;"><ins id="aswift_1_anchor" style="box-sizing: border-box; display: block; border: none; height: 280px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 336px; background-color: transparent;"><iframe allowfullscreen="true" allowtransparency="true" frameborder="0" height="280" hspace="0" id="aswift_1" marginheight="0" marginwidth="0" name="aswift_1" scrolling="no" style="box-sizing: border-box; max-width: 100%; width: 336px; left: 0px; position: absolute; top: 0px;" vspace="0" width="336">< /iframe></ins> </ins></ins> Unchanged: <ins class="adsbygoogle" data-ad-client= "ca-pub-0320443245290735" data-ad-slot="" data-adsbygoogle- status="done" id="adsgoogle2" style="box-sizing: border-box; display: inline-block; width: 336px; height: 280px;"><ins id="aswift_1_expand" style="box-sizing: border-box; display: inline-table; border: none; height: 280px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 336px; background-color: transparent;"><ins id="aswift_1_anchor" style="box-sizing: border-box; display: block; border: none; height: 280px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 336px; background-color: transparent;"><iframe allowfullscreen="true" allowtransparency="true" frameborder="0" height="280" hspace="0" id="aswift_1" marginheight="0" marginwidth="0" name="aswift_1" scrolling="no" style="box-sizing: border-box; max-width: 100%; width: 336px; left: 0px; position: absolute; top: 0px;" vspace="0" width="336">< /iframe></ins> </ins></ins>
Unchanged: </div> Unchanged: </div>
Unchanged: <div class="bwp-syntax-block clearfix" style="box-sizing: border-box; margin: 10px 0px; position: relative; color: rgb(0, 0, 0); font-size: 12px; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; zoom: 1;"> Unchanged: <div class="bwp-syntax-block clearfix" style="box-sizing: border-box; margin: 10px 0px; position: relative; color: rgb(0, 0, 0); font-size: 12px; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; zoom: 1;">
Unchanged: <div class="bwp-syntax-wrapper clearfix bwp-syntax-advanced" style="box-sizing: border-box; width: 767.5px; overflow: auto; position: relative; margin: 0px; zoom: 1;"> Unchanged: <div class="bwp-syntax-wrapper clearfix bwp-syntax-advanced" style="box-sizing: border-box; width: 767.5px; overflow: auto; position: relative; margin: 0px; zoom: 1;">
Unchanged: <div class="php" style="box-sizing: border-box; font-family: monospace; margin: 0px; zoom: 1;"> Unchanged: <div class="php" style="box-sizing: border-box; font-family: monospace; margin: 0px; zoom: 1;">
Unchanged: <ol style="box-sizing: border-box; margin: 0px; padding-right: 0px; padding-left: 0px;"> Unchanged: <ol style="box-sizing: border-box; margin: 0px; padding-right: 0px; padding-left: 0px;">
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: php&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>path<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>to<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> magento<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>shell<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> indexer<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span>php reindexall Unchanged: php&nbsp;<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>path<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>to<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> magento<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>shell<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> indexer<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span>php reindexall
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: </ol> Unchanged: </ol>
Unchanged: </div> Unchanged: </div>
  Added: <p>
  Added: &nbsp;
  Added: </p>
Unchanged: </div> Unchanged: </div>
Unchanged: </div> Unchanged: </div>
Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;"> Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;">
Unchanged: Magento will then start to run the reindex process, updating the command line as it progresses. &nbsp;When it hits the error mark, it will show you what the actual error is. &nbsp;In my case, this is what I got: Unchanged: Magento will then start to run the reindex process, updating the command line as it progresses. &nbsp;When it hits the error mark, it will show you what the actual error is. &nbsp;In my case, this is what I got:
Unchanged: </p> Unchanged: </p>
Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;"> Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;">
Unchanged: &nbsp; Unchanged: &nbsp;
Unchanged: </p> Unchanged: </p>
Unchanged: <div class="bwp-syntax-block clearfix" style="box-sizing: border-box; margin: 10px 0px; position: relative; color: rgb(0, 0, 0); font-size: 12px; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; zoom: 1;"> Unchanged: <div class="bwp-syntax-block clearfix" style="box-sizing: border-box; margin: 10px 0px; position: relative; color: rgb(0, 0, 0); font-size: 12px; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; zoom: 1;">
Unchanged: <div class="bwp-syntax-toolbar" style="box-sizing: border-box; position: absolute; top: 0px; right: 0px; z-index: 10000; margin: 0px; opacity: 0.460770452136078;"> Unchanged: <div class="bwp-syntax-toolbar" style="box-sizing: border-box; position: absolute; top: 0px; right: 0px; z-index: 10000; margin: 0px; opacity: 0.460770452136078;">
Unchanged: <div class="bwp-syntax-control" style="box-sizing: border-box; line-height: 15px; margin: 0px;"> Unchanged: <div class="bwp-syntax-control" style="box-sizing: border-box; line-height: 15px; margin: 0px;">
  Added: &nbsp;
Unchanged: </div> Unchanged: </div>
  Added: <p>
  Added: &nbsp;
  Added: </p>
Unchanged: </div> Unchanged: </div>
Unchanged: <div class="bwp-syntax-wrapper clearfix bwp-syntax-advanced" style="box-sizing: border-box; width: 767.5px; overflow: auto; position: relative; margin: 0px; zoom: 1;"> Unchanged: <div class="bwp-syntax-wrapper clearfix bwp-syntax-advanced" style="box-sizing: border-box; width: 767.5px; overflow: auto; position: relative; margin: 0px; zoom: 1;">
Unchanged: <div class="php" style="box-sizing: border-box; font-family: monospace; margin: 0px; zoom: 1;"> Unchanged: <div class="php" style="box-sizing: border-box; font-family: monospace; margin: 0px; zoom: 1;">
Unchanged: <ol style="box-sizing: border-box; margin: 0px; padding-right: 0px; padding-left: 0px;"> Unchanged: <ol style="box-sizing: border-box; margin: 0px; padding-right: 0px; padding-left: 0px;">
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: Product Flat Data index process unknown error<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">:</span> Unchanged: Product Flat Data index process unknown error<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">:</span>
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);"> Unchanged: <li class="li2" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier; background-color: rgb(248, 248, 248);">
Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de2" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: &nbsp; Unchanged: &nbsp;
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;"> Unchanged: <li class="li1" style="box-sizing: border-box; color: rgb(175, 175, 175); list-style-position: outside; margin: 0px 0px 0px 45px; padding: 0px; border: none; line-height: 1.4; font-family: Consolas, 'Bitstream Vera Sans Mono', 'Courier New', Courier;">
Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);"> Unchanged: <div class="de1" style="box-sizing: border-box; margin: 0px; zoom: 1; border-left-width: 3px; border-left-style: solid; border-left-color: rgb(204, 204, 204); padding: 0px 5px; color: rgb(0, 0, 0);">
Unchanged: exception&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; PDOException&rsquo; </span>&nbsp;with message&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`alleight_bbcom/ #sql-6d5d_2cb103`, 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 )&rsquo;</span> &nbsp;in<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>home<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> alleight<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> public_html<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>bbcom<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>lib<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>Zend<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>Db<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> Statement<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>Pdo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span>php<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">:</span><span class="nu0" style="box-sizing: border-box; color: rgb(204, 102, 204);">228</span> Unchanged: exception&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; PDOException&rsquo; </span>&nbsp;with message&nbsp;<span class="st_h" style="box-sizing: border-box; color: rgb(0, 0, 255);">&lsquo; SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`alleight_bbcom/ #sql-6d5d_2cb103`, 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 )&rsquo;</span> &nbsp;in<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>home<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> alleight<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> public_html<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>bbcom<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>lib<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>Zend<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>Db<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span> Statement<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">/</span>Pdo<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">.</span>php<span class="sy0" style="box-sizing: border-box; color: rgb(51, 153, 51);">:</span><span class="nu0" style="box-sizing: border-box; color: rgb(204, 102, 204);">228</span>
Unchanged: </div> Unchanged: </div>
Unchanged: </li> Unchanged: </li>
Unchanged: </ol> Unchanged: </ol>
Unchanged: </div> Unchanged: </div>
  Added: <p>
  Added: &nbsp;
  Added: </p>
Unchanged: </div> Unchanged: </div>
Unchanged: </div> Unchanged: </div>
Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;"> Unchanged: <p style="box-sizing: border-box; margin: 0px 0px 10px; font-family: Abel; font-size: 20px; line-height: 24px;">
Unchanged: In the error, you can see that there&rsquo;s a problem with the catalog product flat data. &nbsp;We simply truncated the table catalog_flat_product_1, and voila. &nbsp;Reindex successful. Unchanged: In the error, you can see that there&rsquo;s a problem with the catalog product flat data. &nbsp;We simply truncated the table catalog_flat_product_1, and voila. &nbsp;Reindex successful.
Unchanged: </p> Unchanged: </p>

Note: Spaces may be added to comparison text to allow better line wrapping.

No comments yet.

Leave a Reply