The site i am working on was on 7.2.8 umbraco and was running 1.9.0 of merchello, and i am trying to upgrading to 7.3.8 of umbraco and 1.14.1 of merchello.
When i run the upgrade installation it completes the umbraco upgrade, however the merchello upgrade fails:
from \TargetVersionOneTenZero\AddTaxMethodColumn.cs
The only thing i thought it may be was all the default values on the uniqueidentifier fields have a default value of ('newid()') and if i was to modify the table using the designer view it would error however if i update the default value to (newid()) my change works.
Upgrading merchello
Hi,
The site i am working on was on 7.2.8 umbraco and was running 1.9.0 of merchello, and i am trying to upgrading to 7.3.8 of umbraco and 1.14.1 of merchello.
When i run the upgrade installation it completes the umbraco upgrade, however the merchello upgrade fails:
It is erroring on the line
this.Alter.Table("merchTaxMethod").AddColumn("productTaxMethod").AsBoolean().NotNullable().WithDefaultValue('0');
from \TargetVersionOneTenZero\AddTaxMethodColumn.cs
The only thing i thought it may be was all the default values on the uniqueidentifier fields have a default value of ('newid()') and if i was to modify the table using the designer view it would error however if i update the default value to (newid()) my change works.
Hey Paul,
The default value should have been set to the bit 0 (false). This designates that the method is used for product based taxation.
After you've updated the the field (to 0) go back and set the merchelloConfigurationStatus to 1.10.0 in the web.config and try to upgrade from there.
Hi Rusty,
I couldn't get the first script to run and update the table i had to add that column by hand.
I then had to set the web config to 1.x and it would run the next script and repeat the process to get to 1.14.1
Is this normal expected behaviour or should of going though all the scripts in one hit?
Paul
is working on a reply...