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


  • Rune Grønkjær 1372 posts 3103 karma points
    Oct 26, 2022 @ 06:09
    Rune Grønkjær
    0

    Vendr MigrateUp throwing error

    Hi,

    Installing Vendr 3.0.3 somehow fails when trying to install all sql tables. The last successfully run migration is this: Vendr.Persistence.SqlServer.Migrations.Implement.v010100.M20200429090000_AddDiscountCodeIsUnlimitedColumn.sql

    enter image description here

    The error I get is thrown when starting the website and looks like this: enter image description here

    The log says it has something to do with this file: Vendr.Persistence.SqlServer.Migrations.Implement.v010102.M20200505090000_AddDiscountCodeDeletedTimestampColumn.sql

    EDIT: The Umbraco version is v10.3.1

    Copy Link
  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    Oct 26, 2022 @ 07:26
    Matt Brailsford
    0

    Hey Rune,

    What database are you using?

    Copy Link
  • Rune Grønkjær 1372 posts 3103 karma points
    Oct 26, 2022 @ 07:46
    Rune Grønkjær
    0

    MS SQL server 2012. So it's an old lady.

    Copy Link
  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    Oct 26, 2022 @ 07:54
    Matt Brailsford
    100

    Yea, so that's your problem. Our migrations use IF EXISTS clauses in our drop statements which are only supported by SQL Server 2016+

    Given v10 has a suggested minimum of SQL Server 2019 we though that would be a safe enough bet.

    Are you able to upgrade the DB version?

    Copy Link
  • Rune Grønkjær 1372 posts 3103 karma points
    Oct 26, 2022 @ 09:11
    Rune Grønkjær
    0

    I thought as much. We will find a way 👍

    It's about time to start a new server. 😅

    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