Sign in Register
Go to solution
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
Please Sign in or register to post replies

Write your reply to:

Draft