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'.
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:
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?
In the web.config file, you can set the "merchelloConfigurationStatus" to 1.14.1 save and refresh. That should run the migration again.
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
is working on a reply...