Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • john blair 48 posts 219 karma points
    Jan 19, 2020 @ 18:58
    john blair
    0

    How to add a migration that adds a boolean column to an existing table, is not null and has a default value of false?

    I tried this 

     public override void Migrate()
    {
        Alter.Table(DatabaseConstants.QuestionTable).AddColumn(DatabaseConstants.UnpublishedColumn).AsBoolean().NotNullable().WithDefaultValue(false);

    }

    but I get the obscure error The migration has run, but leaves an expression that has not run.

    Umbraco fails to boot - i have tried replacing the value with 0 instead of false - same error.

    What is the correct way of doing this in Umbraco 8?

    Copy Link
  • Abilash Ashok 63 posts 418 karma points
    Feb 12, 2020 @ 11:07
    Abilash Ashok
    0

    Hello, were you able to solve this problem? I am also facing this issue. Thanks.

    Copy Link
  • Abilash Ashok 63 posts 418 karma points
    Feb 12, 2020 @ 11:15
    Abilash Ashok
    0

    Hey, I fixed it. We need to add Do() at the end of the statement as below:

    Alter.Table(DatabaseConstants.QuestionTable).AddColumn(DatabaseConstants.UnpublishedColumn).AsBoolean().NotNullable().WithDefaultValue(false).Do();

    Thanks.

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies