Hello
I'm getting a sql error when upgrading from 4.30 to 4.40. I started with 3.10 and ran all the sql scripts up to and including 4.30. The site starts and runs. However when upgrading to 4.40 I get:
The error was The object 'FK_dbo.RewardPointsHistory_dbo.Order_UsedWithOrder_Id' is dependent on column 'UsedWithOrder_Id'.
ALTER TABLE DROP COLUMN UsedWithOrder_Id failed because one or more objects access this column.
---> System.Data.SqlClient.SqlException (0x80131904): The object 'FK_dbo.RewardPointsHistory_dbo.Order_UsedWithOrder_Id' is dependent on column 'UsedWithOrder_Id'.
ALTER TABLE DROP COLUMN UsedWithOrder_Id failed because one or more objects access this column.
Any ideas what may be causing this how to resolve?
Thanks
Sean