upgrade from 2.80 to last changes

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
11 years ago
when run upgrade script for sql database get this error message :
Msg 1785, Level 16, State 0, Line 8
Introducing FOREIGN KEY constraint 'Forums_PrivateMessage_Store' on table 'Forums_PrivateMessage' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Msg 1750, Level 16, State 0, Line 8
Could not create constraint. See previous errors.
I mention that i wish update from nopcommerce_0e364e409b7f to nopcommerce-1945ccd4cf69
11 years ago
What is your SQL Server version?
11 years ago
SQL SRVER 2008
11 years ago
Does anybody else experience this issue?
11 years ago
if replace DELETE ON CAsCADE with DELETE NO ACTION work fine
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.