Copied to clipboard

Flag this post as spam?

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

  • Jason 115 posts 630 karma points
    May 23, 2016 @ 22:38

    Unable to upgrade to 2.0.0/2.0.1

    Trying to upgrade from Merchello 1.14.3 to 2.0.1 but keep getting a SQL error that columns are invalid. I added the missing columns manually to the merchNote table and the error went away. So, I guess the question is why did the db upgrades not work? I am still checking but I think that none of the 2.0.0 upgrade class that handle this stuff fired. Did I miss an upgrade step. Is there a way to force the upgrades to run? Idea?

    Invalid column name 'author'. 
    Invalid column name 'internalOnly'.

    enter image description here

  • Rusty Swayne 1655 posts 4993 karma points c-trib
    May 23, 2016 @ 22:43
    Rusty Swayne

    In the web.config file, you can set the "merchelloConfigurationStatus" to 1.14.1 save and refresh. That should run the migration again.

  • Jason 115 posts 630 karma points
    May 24, 2016 @ 16:22

    Well, that did re-run the migrations. I removed the columns I added manually and re-ran the migrations and it still fails to add the new columns to the merchNote table. So I manually added the columns again and ran the migrations. Looks like the other migrations did run. Not sure why this was an issue but it seems to be working now, so I am just going to say it was something special with my install. Thanks for the help Rusty.

    For the record and if anyone else has this happen, here are the columns I added to the merchNote table:

    author - nvarchar(255) - null

    internalOnly - bit - not null

Please Sign in or register to post replies

Write your reply to: