0

I just used the import feature to import configurable products for the first time and now I get an error on Catalog URL Rewrites.

The first time I tried importing configurable products, it failed because when it tried to verify the file it checked _super_attribute_code and the sku didn't exist yet. I solved this by importing all my configurable products, then all my simple products, then again the complete file containing the _super columns. This worked. All my simple products are correctly linked to my configurable products. But after the last step I get the following error when trying to index Catalog URL Rewrites:

Catalog URL Rewrites index process unknown error:
PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '45786800_1532798449-0-1' for key 'UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID' in D:\http\SexyDancerClothes.com\lib\Zend\Db\Statement\Pdo.php:228
Stack trace:
#0 D:\http\SexyDancerClothes.com\lib\Zend\Db\Statement\Pdo.php(228): PDOStatement->execute(Array)
#1 D:\http\SexyDancerClothes.com\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#2 D:\http\SexyDancerClothes.com\app\code\core\Zend\Db\Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#3 D:\http\SexyDancerClothes.com\lib\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array)
#4 D:\http\SexyDancerClothes.com\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `co...', Array)
#5 D:\http\SexyDancerClothes.com\lib\Varien\Db\Adapter\Pdo\Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `co...', Array)
#6 D:\http\SexyDancerClothes.com\lib\Zend\Db\Adapter\Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `co...', Array)
#7 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Resource\Url.php(359): Zend_Db_Adapter_Abstract->insert('core_url_rewrit...', Array)
#8 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(963): Mage_Catalog_Model_Resource_Url->saveRewriteHistory(Object(Varien_Object))
#9 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(369): Mage_Catalog_Model_Url->_saveRewriteHistory(Array, Object(Varien_Object))
#10 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(568): Mage_Catalog_Model_Url->_refreshProductRewrite(Object(Varien_Object), Object(Varien_Object))
#11 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(255): Mage_Catalog_Model_Url->refreshProductRewrites('1')
#12 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(248): Mage_Catalog_Model_Url->refreshRewrites('1')
#13 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Indexer\Url.php(257): Mage_Catalog_Model_Url->refreshRewrites()
#14 D:\http\SexyDancerClothes.com\app\code\core\Mage\Index\Model\Process.php(212): Mage_Catalog_Model_Indexer_Url->reindexAll()
#15 D:\http\SexyDancerClothes.com\app\code\core\Mage\Index\Model\Process.php(260): Mage_Index_Model_Process->reindexAll()
#16 D:\http\SexyDancerClothes.com\shell\indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#17 D:\http\SexyDancerClothes.com\shell\indexer.php(216): Mage_Shell_Compiler->run()
#18 {main}

Next Zend_Db_Statement_Exception: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '45786800_1532798449-0-1' for key 'UNQ_CORE_URL_REWRITE_ID_PATH_IS_SYSTEM_STORE_ID', query was: INSERT INTO `core_url_rewrite` (`store_id`, `category_id`, `product_id`, `id_path`, `request_path`, `target_path`, `is_system`, `options`) VALUES (?, ?, ?, ?, ?, ?, ?, ?) in D:\http\SexyDancerClothes.com\lib\Zend\Db\Statement\Pdo.php:235
Stack trace:
#0 D:\http\SexyDancerClothes.com\lib\Varien\Db\Statement\Pdo\Mysql.php(110): Zend_Db_Statement_Pdo->_execute(Array)
#1 D:\http\SexyDancerClothes.com\app\code\core\Zend\Db\Statement.php(291): Varien_Db_Statement_Pdo_Mysql->_execute(Array)
#2 D:\http\SexyDancerClothes.com\lib\Zend\Db\Adapter\Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 D:\http\SexyDancerClothes.com\lib\Zend\Db\Adapter\Pdo\Abstract.php(238): Zend_Db_Adapter_Abstract->query('INSERT INTO `co...', Array)
#4 D:\http\SexyDancerClothes.com\lib\Varien\Db\Adapter\Pdo\Mysql.php(504): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `co...', Array)
#5 D:\http\SexyDancerClothes.com\lib\Zend\Db\Adapter\Abstract.php(576): Varien_Db_Adapter_Pdo_Mysql->query('INSERT INTO `co...', Array)
#6 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Resource\Url.php(359): Zend_Db_Adapter_Abstract->insert('core_url_rewrit...', Array)
#7 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(963): Mage_Catalog_Model_Resource_Url->saveRewriteHistory(Object(Varien_Object))
#8 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(369): Mage_Catalog_Model_Url->_saveRewriteHistory(Array, Object(Varien_Object))
#9 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(568): Mage_Catalog_Model_Url->_refreshProductRewrite(Object(Varien_Object), Object(Varien_Object))
#10 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(255): Mage_Catalog_Model_Url->refreshProductRewrites('1')
#11 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Url.php(248): Mage_Catalog_Model_Url->refreshRewrites('1')
#12 D:\http\SexyDancerClothes.com\app\code\core\Mage\Catalog\Model\Indexer\Url.php(257): Mage_Catalog_Model_Url->refreshRewrites()
#13 D:\http\SexyDancerClothes.com\app\code\core\Mage\Index\Model\Process.php(212): Mage_Catalog_Model_Indexer_Url->reindexAll()
#14 D:\http\SexyDancerClothes.com\app\code\core\Mage\Index\Model\Process.php(260): Mage_Index_Model_Process->reindexAll()
#15 D:\http\SexyDancerClothes.com\shell\indexer.php(168): Mage_Index_Model_Process->reindexEverything()
#16 D:\http\SexyDancerClothes.com\shell\indexer.php(216): Mage_Shell_Compiler->run()
#17 {main}

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.