Examples of simultaneous independent breakthroughs

Japanese reading of an integer

Defining a Function programmatically

What is the most common end of life issue for a car?

To find islands of 1 and 0 in matrix

The best place for swimming in Arctic Ocean

How many oliphaunts died in all of the Lord of the Rings battles?

Unethical behavior : should I report it?

Commercial jet accompanied by small plane near Seattle

How do I stop my characters falling in love?

How to avoid theft of potentially patentable IP when trying to obtain a Ph.D?

Is there a wealth gap in Boston where the median net worth of white households is $247,500 while the median net worth for black families was $8?

How do I explain an exponentially complex intuitively?

Vertical tennis ball into fancy new enumerate

How to tar a list of directories only if they exist

When does Haskell complain about incorrect typing in functions?

What are the closest international airports in different countries?

The Sword in the Stone

Why was Sauron preparing for war instead of trying to find the ring?

Recommendations or Experiences on Archiving Mailing Data

Struggling with cyclical dependancies in unit tests

How can religions be structured in ways that allow inter-faith councils to work?

What is this spacecraft tethered to another spacecraft in LEO (vintage)

Issue with Expansions of Nested Macros

Product attributes Re-indexing not working in magento 1.9.2.2

Product Attributes could not be reindexedFix for Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry?Upgrade from 1.9.1 to 1.9.2 ErrorReindex catalog categories url issueCron jobs not being called, getting email notification errorsMagento 1.9.1.1 : Create Store View : Cardinality violation: 1241 Operand should contain 1 column(s)Error in admin panel: MySQL server has gone awayThere has been an error processing your request magento 1.9.0.1SQLSTATE[HY000] : General error: 2013 Lost connection to MySQL server during query in MagentoCan't run CRON PDOException Magento 1.9.3.8

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I use magento 1.9.2.2 in that when i try to re-indexing data than "Product attributes" re-indexing not working it's display "There was a problem with re-indexing process" error.

I check solution from http://newsinfo-blog.blogspot.com/2015/11/solve-re-indexing-error-cannot.html and try all steps but not found any solution.
I create new reindex.php file as below

<?php
require_once 'app/Mage.php';
$app = Mage::app('admin');
umask(0);
for ($index = 1; $index load($index); 
 $process->reindexAll(); 
}
?>

I found below error when i run that file on browser.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]:
Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails
(`catalog_product_index_eav`, CONSTRAINT `FK_OMNI_CAT_PRD_IDX_EAV_ENTT_ID_OMNI_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` )'
in /home/public_html/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0
/home/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1
/home/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2
/home/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3
/home/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #4
/home/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(' in /home/public_html/lib/Zend/Db/Statement/Pdo.php on line 235

magento-1.9

share|improve this question

asked Dec 17 '15 at 12:05

ClickInfo 365ClickInfo 365

622 bronze badges

add a comment | 

1

I use magento 1.9.2.2 in that when i try to re-indexing data than "Product attributes" re-indexing not working it's display "There was a problem with re-indexing process" error.

I check solution from http://newsinfo-blog.blogspot.com/2015/11/solve-re-indexing-error-cannot.html and try all steps but not found any solution.
I create new reindex.php file as below

<?php
require_once 'app/Mage.php';
$app = Mage::app('admin');
umask(0);
for ($index = 1; $index load($index); 
 $process->reindexAll(); 
}
?>

I found below error when i run that file on browser.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]:
Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails
(`catalog_product_index_eav`, CONSTRAINT `FK_OMNI_CAT_PRD_IDX_EAV_ENTT_ID_OMNI_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` )'
in /home/public_html/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0
/home/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1
/home/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2
/home/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3
/home/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #4
/home/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(' in /home/public_html/lib/Zend/Db/Statement/Pdo.php on line 235

magento-1.9

share|improve this question

asked Dec 17 '15 at 12:05

ClickInfo 365ClickInfo 365

622 bronze badges

add a comment | 

I use magento 1.9.2.2 in that when i try to re-indexing data than "Product attributes" re-indexing not working it's display "There was a problem with re-indexing process" error.

I check solution from http://newsinfo-blog.blogspot.com/2015/11/solve-re-indexing-error-cannot.html and try all steps but not found any solution.
I create new reindex.php file as below

<?php
require_once 'app/Mage.php';
$app = Mage::app('admin');
umask(0);
for ($index = 1; $index load($index); 
 $process->reindexAll(); 
}
?>

I found below error when i run that file on browser.

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]:
Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails
(`catalog_product_index_eav`, CONSTRAINT `FK_OMNI_CAT_PRD_IDX_EAV_ENTT_ID_OMNI_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` )'
in /home/public_html/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0
/home/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1
/home/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2
/home/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3
/home/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #4
/home/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(' in /home/public_html/lib/Zend/Db/Statement/Pdo.php on line 235

magento-1.9

share|improve this question

asked Dec 17 '15 at 12:05

ClickInfo 365ClickInfo 365

622 bronze badges

<?php
require_once 'app/Mage.php';
$app = Mage::app('admin');
umask(0);
for ($index = 1; $index load($index); 
 $process->reindexAll(); 
}
?>

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[23000]:
Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails
(`catalog_product_index_eav`, CONSTRAINT `FK_OMNI_CAT_PRD_IDX_EAV_ENTT_ID_OMNI_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` )'
in /home/public_html/lib/Zend/Db/Statement/Pdo.php:228 Stack trace: #0
/home/public_html/lib/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array) #1
/home/public_html/lib/Varien/Db/Statement/Pdo/Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array) #2
/home/public_html/app/code/core/Zend/Db/Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array) #3
/home/public_html/lib/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array) #4
/home/public_html/lib/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(' in /home/public_html/lib/Zend/Db/Statement/Pdo.php on line 235

share|improve this question

asked Dec 17 '15 at 12:05

ClickInfo 365ClickInfo 365

622 bronze badges

share|improve this question

asked Dec 17 '15 at 12:05

ClickInfo 365ClickInfo 365

622 bronze badges

asked Dec 17 '15 at 12:05

ClickInfo 365ClickInfo 365

622 bronze badges

asked Dec 17 '15 at 12:05

ClickInfo 365ClickInfo 365

622 bronze badges

1 Answer
1

active

oldest

votes

0

I ran into this problem myself recently. As it turns out, the previous developer of the site had created all of the database tables as MyISAM instead of InnoDB. When I upgraded from 1.8.1.0 to 1.9.2.2, I encountered this error because Magento failed to create the indices that it needed to function correctly. The only way to solve this issue was to run the Magento Database Repair Tool, which can be downloaded from the Magento Download Page. Perhaps it will help you as well.

TLDR:

Your database is likely corrupt. Use the Magento Database Repair Tool to fix it.

share|improve this answer

answered Dec 17 '15 at 13:04

Joseph LeedyJoseph Leedy

73255 silver badges1616 bronze badges

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "479"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f94148%2fproduct-attributes-re-indexing-not-working-in-magento-1-9-2-2%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

I ran into this problem myself recently. As it turns out, the previous developer of the site had created all of the database tables as MyISAM instead of InnoDB. When I upgraded from 1.8.1.0 to 1.9.2.2, I encountered this error because Magento failed to create the indices that it needed to function correctly. The only way to solve this issue was to run the Magento Database Repair Tool, which can be downloaded from the Magento Download Page. Perhaps it will help you as well.

TLDR:

Your database is likely corrupt. Use the Magento Database Repair Tool to fix it.

share|improve this answer

answered Dec 17 '15 at 13:04

Joseph LeedyJoseph Leedy

73255 silver badges1616 bronze badges

add a comment | 

0

I ran into this problem myself recently. As it turns out, the previous developer of the site had created all of the database tables as MyISAM instead of InnoDB. When I upgraded from 1.8.1.0 to 1.9.2.2, I encountered this error because Magento failed to create the indices that it needed to function correctly. The only way to solve this issue was to run the Magento Database Repair Tool, which can be downloaded from the Magento Download Page. Perhaps it will help you as well.

TLDR:

Your database is likely corrupt. Use the Magento Database Repair Tool to fix it.

share|improve this answer

answered Dec 17 '15 at 13:04

Joseph LeedyJoseph Leedy

73255 silver badges1616 bronze badges

add a comment | 

I ran into this problem myself recently. As it turns out, the previous developer of the site had created all of the database tables as MyISAM instead of InnoDB. When I upgraded from 1.8.1.0 to 1.9.2.2, I encountered this error because Magento failed to create the indices that it needed to function correctly. The only way to solve this issue was to run the Magento Database Repair Tool, which can be downloaded from the Magento Download Page. Perhaps it will help you as well.

TLDR:

Your database is likely corrupt. Use the Magento Database Repair Tool to fix it.

share|improve this answer

answered Dec 17 '15 at 13:04

Joseph LeedyJoseph Leedy

73255 silver badges1616 bronze badges

share|improve this answer

answered Dec 17 '15 at 13:04

Joseph LeedyJoseph Leedy

73255 silver badges1616 bronze badges

answered Dec 17 '15 at 13:04

Joseph LeedyJoseph Leedy

73255 silver badges1616 bronze badges

answered Dec 17 '15 at 13:04

Joseph LeedyJoseph Leedy

73255 silver badges1616 bronze badges