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 Spryker Guys While executing Propel:migrate command, it shows the exception error to execute Alte

Options
U03CDV6GDSP
U03CDV6GDSP Posts: 38 🧑🏻‍🚀 - Cadet

Hi Spryker Guys
While executing Propel:migrate command, it shows the exception error to execute Alter statement, could somebody share the right approach to resolve such error,
Thank you

Propel\Runtime\Exception\RuntimeException - Exception: Failed to execute SQL "ALTER TABLE spy_category
CHANGE fk_category_template fk_category_template INTEGER NOT NULL". Aborting migration.
in /data/vendor/propel/propel/src/Propel/Generator/Command/MigrationMigrateCommand.php (149)

Comments

  • fsmeier
    fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,005 ⚖️ - Guardians (admin)
    Options

    likely you have already content in that table. By adding that column which is not allowed to be null it creates a conflict for the existing entries

  • U03CDV6GDSP
    U03CDV6GDSP Posts: 38 🧑🏻‍🚀 - Cadet
    Options

    yes exactly, it looks like creating conflict, could you please share right approach to resolve such error?
    Actually, after executing docker clean data, and and then migrate is giving such error, however data:import is giving like
    Propel\Runtime\ActiveQuery\QueryExecutor\QueryExecutionException - Exception: Unable to execute statement [SELECT COUNT(*) FROM spy_customer WHERE spy_customer.anonymized_at IS NULL ]
    in /data/vendor/propel/propel/src/Propel/Runtime/ActiveQuery/QueryExecutor/AbstractQueryExecutor.php

  • fsmeier
    fsmeier Senior Software Engineer & Developer Enablement Advocate Sprykee Posts: 1,005 ⚖️ - Guardians (admin)
    Options

    Hey, sry, seems to be more than one problem.

    the one i mentioned is not Spryker specific but for every ORM you would use. Either you define a default value or you have to make a two step migration (manual migration file creation) by adding the column and allow NULL, set the values for the existing rows; set it to NOT NULL)

  • U03CDV6GDSP
    U03CDV6GDSP Posts: 38 🧑🏻‍🚀 - Cadet
    Options

    before clean-data, there wasn't any error with migrate and import