Same Taxonomies in different stores about spree HOT 10 CLOSED

It's awesome! Has been successfully updated to the latest version.

from spree.

Thanks for reporting, I see this DB migration is to blame:

this should be a combined index onpermalink, locale, parent_idandtaxonomy_id`

from spree.

We are creating a shop for a client and there is a big problem with taxonomies.
We have a product store and there are products intended for the Slovak market, others for the Czech market and still others for the German market, and there are common products. Now, if we want to separate products using stores, we must have separate taxa, although they are already assigned and I do not see the need to separate them, and if I change/add new ones or items only for the German language, the names of the taxa are not visible in the rest of the products and this can be standardized. Is it possible to quickly fix this error? I wouldn't want the client to change the platform or wonder why there is a loophole in this topic.

Do you have another idea to solve the problem mentioned in this thread?

from spree.

@damianlegawiec I am definitely in favor of taxonomies being applied to all stores. Then the products will not show errors or holes in their names after changing the store.

from spree.

Thanks for reporting, I see this DB migration is to blame:

spree/core/db/migrate/20230514162157_add_index_on_locale_and_permalink_to_spree_taxons.rb

Line 3 in d3927a3

add_index :spree_taxon_translations, [:locale, :permalink], unique: true, name: 'unique_permalink_per_locale', if_not_exists: true

this should be a combined index onpermalink, locale, parent_idandtaxonomy_id`

@damianlegawiec and @rafalcymerys parent_id and taxonomy_id not in table spree_taxon_translations. This table only store for mobility's translate column content. Can I remove these unique constraint?

table: spree_product_translations

• REMOVE unique_slug_per_locale

table: spree_taxon_translations

• REMOVE unique_permalink_per_locale

table: spree_taxons

• REMOVE index_spree_taxons_on_name_and_parent_id_and_taxonomy_id
• REMOVE index_spree_taxons_on_permalink_and_parent_id_and_taxonomy_id

table: spree_products

• REMOVE index_spree_products_on_slug

from spree.

Please, do it xD i need this for my Client.

from spree.

@damianlegawiec What are the possibilities for a fix to be released soon?

from spree.

@pkatek

@damianlegawiec What are the possibilities for a fix to be released soon?

we're planning to fix this with v4.8 releasing this week/early next week, we're also reviewing other translation migrations

from spree.

@damianlegawiec Thanks

from spree.

Hello!

What are our chances of completing this task?

from spree.