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..

can anyone tell what's wrong with this table? ```

UK5DS29L2
UK5DS29L2 Posts: 546 πŸ§‘πŸ»β€πŸš€ - Cadet
edited October 2019 in Help

can anyone tell what's wrong with this table?


Asking because I get


and I cannot figure out why

Comments

  • UK7KBE2JW
    UK7KBE2JW Posts: 463 πŸ§‘πŸ»β€πŸš€ - Cadet

    Your Problem is ("id_cms_block","id_cms_block")

  • UK7KBE2JW
    UK7KBE2JW Posts: 463 πŸ§‘πŸ»β€πŸš€ - Cadet

    Maybe you have saved the schema.xml under a wrong name. This problem happens at the merge of the schemas

  • FOREIGN KEY (β€œfk_cms_block”,β€œfk_cms_block”) is also doubled πŸ€”

  • whats the relative path of the file?

  • UK5DS29L2
    UK5DS29L2 Posts: 546 πŸ§‘πŸ»β€πŸš€ - Cadet

    it's vendor module

  • UK5DS29L2
    UK5DS29L2 Posts: 546 πŸ§‘πŸ»β€πŸš€ - Cadet

    pretty much copy paste from product-category but means to join cms page and blocks

  • UK5DS29L2
    UK5DS29L2 Posts: 546 πŸ§‘πŸ»β€πŸš€ - Cadet

    relative path:
    vendor/spryker/cms-page-block/src/Spryker/Zed/CmsPageBlock/Persistence/Propel/Schema/spy_cms_page_block.schema.xml

  • no project level extension?

  • UK5DS29L2
    UK5DS29L2 Posts: 546 πŸ§‘πŸ»β€πŸš€ - Cadet

    not for this extension, no

  • UK5DS29L2
    UK5DS29L2 Posts: 546 πŸ§‘πŸ»β€πŸš€ - Cadet
    edited October 2019

    NO! Actually, there is

  • UK5DS29L2
    UK5DS29L2 Posts: 546 πŸ§‘πŸ»β€πŸš€ - Cadet

    must have been merged from another branch, my bad

  • UK5DS29L2
    UK5DS29L2 Posts: 546 πŸ§‘πŸ»β€πŸš€ - Cadet

    thank you @UJN2JRU4F for asking the question πŸ™‚

  • questioning things is my expertise 😊 πŸ‘