|
By simonrl - Fri 13 Feb 2015
|
I've just set up a brand new install of v2.8001.
Server 2012 + SQL Server 2012
I set up a new database, without test data. I then added a bunch of categories (successfully) and tried adding a single product. Which failed with:
"Database Error: reference-key violation."
I tried simplifying my product data and linking to just a single category in case that was the cause - but it did not fix it.
So I deleted the site in IIS and deleted the database, rebooted and tried over from scratch.
This time I created a single category (successfully again) and then went straight to adding a single product with an absolute minimum of information.
Again it the "Database Error: reference-key violation." error.
Is anybody else getting this with v2.8001?
I can't progress the project because I can't get past adding a first product.
|
|
By Paul - Fri 13 Feb 2015
|
Can you try running this SQL on the db -
ALTER TABLE [dbo].[tblKartrisProducts] DROP CONSTRAINT [CK_Products_VersionsSortDirection]
GO
|
|
By simonrl - Fri 13 Feb 2015
|
|
Yes, that worked. Many thanks Paul.
|