hello,
I am trying to upgrade nop to the latest version.
1. I downloaded the latest version and filled in the install fields.
2. I got the sequence contains more then 1 element error.
3. looked it up, saw a solution here https://www.nopcommerce.com/en/boards/topic/40009/setup-failed-sequence-contains-more-than-one-element/page/2
4. OK, np. i went to look at copying the old datasettings file but i noticed there was now an appSettings.json file in the app_data directory
5. i opened that up and pasted in my connection string
6. i restarted nop and everything seemed ok until the migrations started to run
i get the following error:
Cannot define foreign key constraint 'FK_SpecificationAttribute_SpecificationAttributeGroupId_SpecificationAttributeGroup_Id' with cascaded DELETE or UPDATE on table 'SpecificationAttribute' because the table has an INSTEAD OF DELETE or UPDATE TRIGGER defined on it.
Any suggestions?