Upgrade from 4.50.4 to 4.60

9 months ago
Hi,
I ran the  customer_data_migrate.sql script against the database but now web app is throwing an error. Events logs show the following;

The UPDATE statement conflicted with the FOREIGN KEY constraint "Customer_Country". The conflict occurred in database "<database_name>", table "dbo.Country", column 'Id'.

Any help is appreciated.

Thanks.
0
9 months ago
RE: "FOREIGN KEY constraint "Customer_Country"

I'm not aware of such a FOREIGN KEY named "Customer_Country".  Did you create that custom?
(By convention, FK's in nopCommerce are named with prefix FK_ )
www.noptools.com
0
8 months ago
New York wrote:
RE: "FOREIGN KEY constraint "Customer_Country"

I'm not aware of such a FOREIGN KEY named "Customer_Country".  Did you create that custom?
(By convention, FK's in nopCommerce are named with prefix FK_ )


Hi,
I may have find out why, some custom code was written for the application some while ago, I don't think it's required any longer.  Thank you for you help.

David
0