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: 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 126.96.36.199 installation.
Any help would be greatly appreciated.