We're on a heavily modified EE 1.13.0.2 with some 20 store views - some of them sharing the same language - facing a problem with url keys.
These are generated and differ per language BUT this doesn't work reliably because of the unique index on the value
column in catalog_product_entity_url_key
. The unique constraint prevents duplicated url keys even if they belong to different store views.
As a result it seems impossible to have both of these links in the same magento installation:
http://store1.example.com/product.html
http://store2.example.com/product.html
Seems like in previous versions the index spanned (store_id, value)
but was changed to value
only. Can anyone explain why this has changed? Btw: catalog_category_entity_url_key
doesn't have any index on its value
column.
Is it safe to change the index back to (store_id, value)
? Would I have to change other tables as well (e.g. tmp or index ones)?
Any other suggestion on how to work around this?
UPDATE
Other URL-related tables (*_url_rewrite_*) all seem to include the store_id in their unique indices so this observed abnormality is getting even weirder.