When I attempt to fulfill an order in the backend I receive a generic error message with no detail and no stack trace. When I capture the request via fiddler I see it returning the following. Does this mean my database schema somehow got messed up during install/upgrade? If so, does anyone have an idea of how to fix this?
Looking at a SQL Server Profiler trace it appears it is indeed a schema issue. It is trying to insert a value into merchShipment.trackingUrl. A column that does not exist in either of the databases I have Merchello deployed to.
Error when attempting to fulfill order
When I attempt to fulfill an order in the backend I receive a generic error message with no detail and no stack trace. When I capture the request via fiddler I see it returning the following. Does this mean my database schema somehow got messed up during install/upgrade? If so, does anyone have an idea of how to fix this?
/umbraco/backoffice/Merchello/ShipmentApi/NewShipment
{"message":"Invalid column name 'trackingUrl'."}
Looking at a SQL Server Profiler trace it appears it is indeed a schema issue. It is trying to insert a value into merchShipment.trackingUrl. A column that does not exist in either of the databases I have Merchello deployed to.
I found the migration that looks like it was supposed to have created this column when upgrading to 2.4.
https://github.com/Merchello/Merchello/blob/caea5c9ee8768d559a8fd212a3da5f9e5288832a/src/Merchello.Core/Persistence/Migrations/Upgrades/TargetVersionTwoFourZero/AddShipmentTrackingUrlColumns.cs
I also found a migration for the previous version 2.3.1.
https://github.com/Merchello/Merchello/blob/caea5c9ee8768d559a8fd212a3da5f9e5288832a/src/Merchello.Core/Persistence/Migrations/Upgrades/TargetVersionTwoThreeOne/AlterProductAttributeColumnToNtext.cs
The previous change looks like it was successfully applied. So no idea why trackingUrl did not get added.
I manually added the column as nvarchar(1000) to my dev copy of the database and allowed me to fulfill an order without error.
Perhaps a bug in the upgrade script? Hoping there is nothing else that got missed.
is working on a reply...