How to fix magento reindexing with PDOException error?

I got an error when I reindex data. I have been working for about 3 days with this problem still can't find the solution. here is the log error I have received:

Default Values (MANAdev) 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 (glasseso_magento.m_filter2_value, CONSTRAINT FK_m_filter2_value_mana_db?edit_session FOREIGN KEY (edit_session_id) REFERENCES m_edit_session (id) ON DELETE CASCADE ON UPDATE CASCAD)' in /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Statement/Pdo.php:228 Stack trace:

0 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)

1 /Applications/MAMP/htdocs/magestore/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

2 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)

3 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)

4 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `m_...', Array)

5 /Applications/MAMP/htdocs/magestore/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `m_...', Array)

6 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `m_...', Array)

7 /Applications/MAMP/htdocs/magestore/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('m_filter2_value', Array)

8 /Applications/MAMP/htdocs/magestore/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mana_Filters_Model_Filter2_Value))

9 /Applications/MAMP/htdocs/magestore/app/code/local/Mana/Db/Helper/Data.php(217): Mage_Core_Model_Abstract->save()

10 /Applications/MAMP/htdocs/magestore/app/code/local/Mana/Db/Model/Indexer.php(36): Mana_Db_Helper_Data->replicate()

11 /Applications/MAMP/htdocs/magestore/app/code/core/Mage/Index/Model/Process.php(209): Mana_Db_Model_Indexer->reindexAll()

12 /Applications/MAMP/htdocs/magestore/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()

13 /Applications/MAMP/htdocs/magestore/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()

14 /Applications/MAMP/htdocs/magestore/shell/indexer.php(198): Mage_Shell_Compiler->run()

15 {main}

Next exception 'Zend_Db_Statement_Exception' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (glasseso_magento.m_filter2_value, CONSTRAINT FK_m_filter2_value_mana_db?edit_sessionFOREIGN KEY (edit_session_id) REFERENCES m_edit_session (id) ON DELETE CASCADE ON UPDATE CASCAD)' in /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Statement/Pdo.php:234 Stack trace:

0 /Applications/MAMP/htdocs/magestore/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)

1 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Statement.php(300): Varien_Db_Statement_Pdo_Mysql->_execute(Array)

2 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array)

3 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `m_...', Array)

4 /Applications/MAMP/htdocs/magestore/lib/Varien/Db/Adapter/Pdo/Mysql.php(419): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `m_...', Array)

5 /Applications/MAMP/htdocs/magestore/lib/Zend/Db/Adapter/Abstract.php(574): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `m_...', Array)

6 /Applications/MAMP/htdocs/magestore/app/code/core/Mage/Core/Model/Resource/Db/Abstract.php(453): Zend_Db_Adapter_Abstract->insert('m_filter2_value', Array)

7 /Applications/MAMP/htdocs/magestore/app/code/core/Mage/Core/Model/Abstract.php(318): Mage_Core_Model_Resource_Db_Abstract->save(Object(Mana_Filters_Model_Filter2_Value))

8 /Applications/MAMP/htdocs/magestore/app/code/local/Mana/Db/Helper/Data.php(217): Mage_Core_Model_Abstract->save()

9 /Applications/MAMP/htdocs/magestore/app/code/local/Mana/Db/Model/Indexer.php(36): Mana_Db_Helper_Data->replicate()

10 /Applications/MAMP/htdocs/magestore/app/code/core/Mage/Index/Model/Process.php(209): Mana_Db_Model_Indexer->reindexAll()

11 /Applications/MAMP/htdocs/magestore/app/code/core/Mage/Index/Model/Process.php(255): Mage_Index_Model_Process->reindexAll()

12 /Applications/MAMP/htdocs/magestore/shell/indexer.php(158): Mage_Index_Model_Process->reindexEverything()

13 /Applications/MAMP/htdocs/magestore/shell/indexer.php(198): Mage_Shell_Compiler->run()

14 {main}

--------------------------------------------------------------

Here is the solution:

I took at a look of the contents of m_edit_session, and there was just one line with an ID of 1, and a timestamp under created_at.

I changed the ID of that one and only row to 0 (instead of 1) and this error went away.

Revisions

August 4, 2015 @ 16:51:19 [Current Revision] by admin
August 4, 2015 @ 16:51:19 by admin
August 4, 2015 @ 16:51:04 by admin
August 4, 2015 @ 16:50:41 by admin

Revision Differences

--- August 4, 2015 @ 16:50:41
+++ Current Revision
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
-Deleted:  I got an error when I reindex data. I have been working for about 3 days with this problem still can&#39;t find the solution. here is the log error I have received:
+Added:  <span style="font-family: arial,helvetica,sans-serif;">I got an error when I reindex data. I have been working for about 3 days with this problem still can&#39;t find the solution. here is the log error I have received:</span>
 Unchanged: </p>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
-Deleted:  Default Values (MANAdev) index process unknown error: exception &#39;PDOException&#39; with message &#39;SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">glasseso_ magento</code>.<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">m_filter2_ value</code>, CONSTRAINT&nbsp;<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">FK_m_filter2_ value_mana_db?edit_session< /code>&nbsp;FOREIGN KEY (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">edit_session_id</code>) REFERENCES&nbsp;<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">m_edit_ session</code> &nbsp;(<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">id</code>) ON DELETE CASCADE ON UPDATE CASCAD)&#39; in /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement/Pdo.php:228 Stack trace:
+Added:  <span style="font-family: arial,helvetica,sans- serif;">Default Values (MANAdev) index process unknown error: exception &#39;PDOException&#39; with message &#39;SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">glasseso_ magento</code>.<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">m_filter2_ value</code>, CONSTRAINT&nbsp;<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">FK_m_filter2_ value_mana_db?edit_session< /code>&nbsp;FOREIGN KEY (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">edit_session_id</code>) REFERENCES&nbsp;<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">m_edit_ session</code> &nbsp;(<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">id</code>) ON DELETE CASCADE ON UPDATE CASCAD)&#39; in /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement/Pdo.php:228 Stack trace:</span>
 Unchanged: </p>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  0 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement/ Pdo.php(228): PDOStatement- &gt;execute(Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">0 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement/ Pdo.php(228): PDOStatement- &gt;execute(Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  1 /Applications/ MAMP/htdocs/magestore/lib/ Varien/Db/Statement/ Pdo/Mysql.php(110): Zend_Db_Statement_ Pdo-&gt;_execute(Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">1 /Applications/ MAMP/htdocs/magestore/lib/ Varien/Db/Statement/ Pdo/Mysql.php(110): Zend_Db_Statement_ Pdo-&gt;_execute( Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  2 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement.php(300): Varien_Db_Statement_ Pdo_Mysql-&gt; _execute(Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">2 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement.php(300): Varien_Db_Statement_ Pdo_Mysql-&gt; _execute(Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  3 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Abstract.php(479): Zend_Db_Statement- &gt;execute(Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">3 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Abstract.php(479): Zend_Db_Statement- &gt;execute(Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  4 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Pdo/Abstract.php(238): Zend_Db_Adapter_ Abstract-&gt; query(&#39;INSERT INTO `m_...&#39;, Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">4 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Pdo/Abstract.php(238): Zend_Db_Adapter_ Abstract-&gt; query(&#39;INSERT INTO `m_...&#39;, Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  5 /Applications/ MAMP/htdocs/magestore/lib/ Varien/Db/Adapter/ Pdo/Mysql.php(419): Zend_Db_Adapter_ Pdo_Abstract- &gt;query(&#39;INSERT INTO `m_...&#39;, Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">5 /Applications/ MAMP/htdocs/magestore/lib/ Varien/Db/Adapter/ Pdo/Mysql.php(419): Zend_Db_Adapter_ Pdo_Abstract- &gt;query(&#39;INSERT INTO `m_...&#39;, Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  6 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Abstract.php(574): Varien_Db_Adapter_ Pdo_Mysql-&gt; query(&#39;INSERT INTO `m_...&#39;, Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">6 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Abstract.php(574): Varien_Db_Adapter_ Pdo_Mysql-&gt; query(&#39;INSERT INTO `m_...&#39;, Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  7 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/Core/Model/ Resource/Db/Abstract.php(453): Zend_Db_Adapter_ Abstract-&gt; insert(&#39; m_filter2_value&#39;, Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">7 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/Core/Model/ Resource/Db/Abstract.php(453): Zend_Db_Adapter_ Abstract-&gt; insert(&#39; m_filter2_value&#39;, Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  8 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/Core/Model/ Abstract.php(318): Mage_Core_Model_ Resource_Db_Abstract-&gt; save(Object(Mana_Filters_ Model_Filter2_Value))
+Added:  <span style="font-family: arial,helvetica,sans-serif;">8 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/Core/Model/ Abstract.php(318): Mage_Core_Model_ Resource_Db_Abstract-&gt; save(Object(Mana_Filters_ Model_Filter2_ Value))</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  9 /Applications/ MAMP/htdocs/magestore/app/ code/local/Mana/Db/Helper/ Data.php(217): Mage_Core_Model_ Abstract-&gt;save()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">9 /Applications/ MAMP/htdocs/magestore/app/ code/local/Mana/Db/Helper/ Data.php(217): Mage_Core_Model_ Abstract-&gt; save()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  10 /Applications/ MAMP/htdocs/magestore/app/ code/local/Mana/Db/Model/ Indexer.php(36): Mana_Db_Helper_ Data-&gt;replicate()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">10 /Applications/ MAMP/htdocs/magestore/app/ code/local/Mana/Db/Model/ Indexer.php(36): Mana_Db_Helper_ Data-&gt;replicate()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  11 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/ Index/Model/ Process.php(209): Mana_Db_Model_ Indexer-&gt;reindexAll()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">11 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/ Index/Model/ Process.php(209): Mana_Db_Model_ Indexer-&gt;reindexAll()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  12 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/ Index/Model/ Process.php(255): Mage_Index_Model_ Process-&gt;reindexAll()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">12 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/ Index/Model/ Process.php(255): Mage_Index_Model_ Process-&gt;reindexAll()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  13 /Applications/ MAMP/htdocs/magestore/shell/ indexer.php(158): Mage_Index_Model_ Process-&gt;reindexEverything()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">13 /Applications/ MAMP/htdocs/magestore/shell/ indexer.php(158): Mage_Index_Model_ Process-&gt;reindexEverything()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  14 /Applications/ MAMP/htdocs/magestore/shell/ indexer.php(198): Mage_Shell_Compiler-&gt;run()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">14 /Applications/ MAMP/htdocs/magestore/shell/ indexer.php(198): Mage_Shell_Compiler- &gt;run()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  15 {main}
+Added:  <span style="font-family: arial,helvetica,sans-serif;">15 {main}</span>
 Unchanged: </h1>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
-Deleted:  Next exception &#39;Zend_Db_ Statement_Exception&#39; with message &#39;SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">glasseso_ magento</code>.<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">m_filter2_ value</code>, CONSTRAINT&nbsp;<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">FK_m_filter2_ value_mana_db?edit_session< /code>FOREIGN KEY (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">edit_session_id</code>) REFERENCES&nbsp;<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">m_edit_ session</code> &nbsp;(<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">id</code>) ON DELETE CASCADE ON UPDATE CASCAD)&#39; in /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement/Pdo.php:234 Stack trace:
+Added:  <span style="font-family: arial,helvetica,sans- serif;">Next exception &#39;Zend_Db_ Statement_Exception&#39; with message &#39;SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">glasseso_ magento</code>.<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">m_filter2_ value</code>, CONSTRAINT&nbsp;<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">FK_m_filter2_ value_mana_db?edit_session< /code>FOREIGN KEY (<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">edit_session_id</code>) REFERENCES&nbsp;<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">m_edit_ session</code> &nbsp;(<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">id</code>) ON DELETE CASCADE ON UPDATE CASCAD)&#39; in /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement/Pdo.php:234 Stack trace:</span>
 Unchanged: </p>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  0 /Applications/ MAMP/htdocs/magestore/lib/ Varien/Db/Statement/ Pdo/Mysql.php(110): Zend_Db_Statement_ Pdo-&gt;_execute(Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">0 /Applications/ MAMP/htdocs/magestore/lib/ Varien/Db/Statement/ Pdo/Mysql.php(110): Zend_Db_Statement_ Pdo-&gt;_execute( Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  1 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement.php(300): Varien_Db_Statement_ Pdo_Mysql-&gt; _execute(Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">1 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Statement.php(300): Varien_Db_Statement_ Pdo_Mysql-&gt; _execute(Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  2 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Abstract.php(479): Zend_Db_Statement- &gt;execute(Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">2 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Abstract.php(479): Zend_Db_Statement- &gt;execute(Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  3 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Pdo/Abstract.php(238): Zend_Db_Adapter_ Abstract-&gt; query(&#39;INSERT INTO `m_...&#39;, Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">3 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Pdo/Abstract.php(238): Zend_Db_Adapter_ Abstract-&gt; query(&#39;INSERT INTO `m_...&#39;, Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  4 /Applications/ MAMP/htdocs/magestore/lib/ Varien/Db/Adapter/ Pdo/Mysql.php(419): Zend_Db_Adapter_ Pdo_Abstract- &gt;query(&#39;INSERT INTO `m_...&#39;, Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">4 /Applications/ MAMP/htdocs/magestore/lib/ Varien/Db/Adapter/ Pdo/Mysql.php(419): Zend_Db_Adapter_ Pdo_Abstract- &gt;query(&#39;INSERT INTO `m_...&#39;, Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  5 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Abstract.php(574): Varien_Db_Adapter_ Pdo_Mysql-&gt; query(&#39;INSERT INTO `m_...&#39;, Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">5 /Applications/ MAMP/htdocs/magestore/lib/ Zend/Db/Adapter/ Abstract.php(574): Varien_Db_Adapter_ Pdo_Mysql-&gt; query(&#39;INSERT INTO `m_...&#39;, Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  6 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/Core/Model/ Resource/Db/Abstract.php(453): Zend_Db_Adapter_ Abstract-&gt; insert(&#39; m_filter2_value&#39;, Array)
+Added:  <span style="font-family: arial,helvetica,sans-serif;">6 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/Core/Model/ Resource/Db/Abstract.php(453): Zend_Db_Adapter_ Abstract-&gt; insert(&#39; m_filter2_value&#39;, Array)</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  7 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/Core/Model/ Abstract.php(318): Mage_Core_Model_ Resource_Db_Abstract-&gt; save(Object(Mana_Filters_ Model_Filter2_Value))
+Added:  <span style="font-family: arial,helvetica,sans-serif;">7 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/Core/Model/ Abstract.php(318): Mage_Core_Model_ Resource_Db_Abstract-&gt; save(Object(Mana_Filters_ Model_Filter2_ Value))</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  8 /Applications/ MAMP/htdocs/magestore/app/ code/local/Mana/Db/Helper/ Data.php(217): Mage_Core_Model_ Abstract-&gt;save()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">8 /Applications/ MAMP/htdocs/magestore/app/ code/local/Mana/Db/Helper/ Data.php(217): Mage_Core_Model_ Abstract-&gt; save()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  9 /Applications/ MAMP/htdocs/magestore/app/ code/local/Mana/Db/Model/ Indexer.php(36): Mana_Db_Helper_ Data-&gt;replicate()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">9 /Applications/ MAMP/htdocs/magestore/app/ code/local/Mana/Db/Model/ Indexer.php(36): Mana_Db_Helper_ Data-&gt;replicate()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  10 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/ Index/Model/ Process.php(209): Mana_Db_Model_ Indexer-&gt;reindexAll()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">10 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/ Index/Model/ Process.php(209): Mana_Db_Model_ Indexer-&gt;reindexAll()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  11 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/ Index/Model/ Process.php(255): Mage_Index_Model_ Process-&gt;reindexAll()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">11 /Applications/ MAMP/htdocs/magestore/app/ code/core/Mage/ Index/Model/ Process.php(255): Mage_Index_Model_ Process-&gt;reindexAll()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  12 /Applications/ MAMP/htdocs/magestore/shell/ indexer.php(158): Mage_Index_Model_ Process-&gt;reindexEverything()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">12 /Applications/ MAMP/htdocs/magestore/shell/ indexer.php(158): Mage_Index_Model_ Process-&gt;reindexEverything()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  13 /Applications/ MAMP/htdocs/magestore/shell/ indexer.php(198): Mage_Shell_Compiler-&gt;run()
+Added:  <span style="font-family: arial,helvetica,sans-serif;">13 /Applications/ MAMP/htdocs/magestore/shell/ indexer.php(198): Mage_Shell_Compiler- &gt;run()</span>
 Unchanged: </h1>
 Unchanged: <h1 style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 21px; line-height: 1.3; word-wrap: break-word; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-weight: bold !important;">
-Deleted:  14 {main}
+Added:  <span style="font-family: arial,helvetica,sans-serif;">14 {main}</span>
 Unchanged: </h1>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
 Unchanged:  &nbsp;
 Unchanged: </p>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
-Deleted:  ------------- ------------- ------------ ------------------------
+Added:  <span style="font-family: arial,helvetica,sans-serif; ">----------- ------------ ------------- ------------ --------------</span>
 Unchanged: </p>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
 Unchanged:  &nbsp;
 Unchanged: </p>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
-Deleted:  <strong>Solution:</strong>
+Added:  <span style="font-family: arial,helvetica,sans-serif; "><strong>Here is the solution:</strong></span>
 Unchanged: </p>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
-Deleted:  <span style="color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 13px;">I took at a look of the contents of m_edit_session, and there was just one line with an ID of 1, and a timestamp under created_at.</span>
+Added:  <span style="font-family: arial,helvetica,sans- serif;"><span style="color: rgb(34, 34, 34); font-size: 15px; line-height: 13px;">I took at a look of the contents of m_edit_session, and there was just one line with an ID of 1, and a timestamp under created_at.</ span></span>
 Unchanged: </p>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
-Deleted:  <span style="color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: 15px; line-height: 13px;">I changed the ID of that one and only row to 0 (instead of 1) and this error went away.</span>
+Added:  <span style="font-family: arial,helvetica,sans- serif;"><span style="color: rgb(34, 34, 34); font-size: 15px; line-height: 13px;">I changed the ID of that one and only row to 0 (instead of 1) and this error went away.</span></span>
 Unchanged: </p>
 Unchanged: <p style="margin: 0px 0px 1em; padding: 0px; border: 0px; font-size: 15px; clear: both; color: rgb(34, 34, 34); font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; line-height: 13px;">
 Unchanged:  &nbsp;
 Unchanged: </p>

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