Magento Forum

   
1.8 Alpha | SQL Error ‘UNQ_CATALOG_CATEGORY_ENTITY_URL_KEY_STORE_ID_VALUE”
 
srmobile
Sr. Member
 
Total Posts:  276
Joined:  2011-10-25
 

I’ve decided to plow through and test my store in 1.8 alpha since there doesn’t seem to be any definitive release date and the fact that I am aiming to launch my store towards the end of September. Since I am in Canada I require to show 2 taxes and all the core code hacks I’ve tried only work to a certain degree but not a complete solution.

I upgraded my installation per the Magento 1.8 upgrade path instructions and cannot index the catalog url rewrites.

When I run the indexer.php I get:

Catalog URL Rewrites index process unknown error:
exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0-core-i3' for key 'UNQ_CATALOG_CATEGORY_ENTITY_URL_KEY_STORE_ID_VALUE''

I checked for any duplicate entries in my database and there were a few that shared sku’s so I deleted those but I get the exact same error.

I did a search in phpmyadmin for any keys matching ‘0-core-i3’ and nothing shows up.

There were no issues with my 1.7.0.2 installation.

Any help would be greatly appreciated.

Thanks,

SR

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
    Back to top