Calling Developers!
We are reenergizing our code contribution process! Learn More

What are the Slack Archives?

It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.

Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..

Hi team if i need to change the foreign key action of `spy_product_category_filter` file from `RESTR

Options
U03TXRYL7U7
U03TXRYL7U7 Posts: 64 🧑🏻‍🚀 - Cadet

Hi team
if i need to change the foreign key action of spy_product_category_filter file from RESTRICT to CASCADE. Please let me know which steps I should follow.
When I am trying by putting following code:

<foreign-key foreignTable="spy_category" onDelete="CASCADE">
            <reference foreign="id_category" local="fk_category" />
        </foreign-key>

I am getting this error:

Comments

  • sebastian.larisch
    sebastian.larisch Spryker Customer Posts: 143 🧑🏻‍🚀 - Cadet
    Options

    what’s the name of the schema file where you have made that change? has to be the same as in vendor

  • U03TXRYL7U7
    U03TXRYL7U7 Posts: 64 🧑🏻‍🚀 - Cadet
    Options

    its same
    spy_product_category_filter.schema.xml