|
Group: Forum Members
Last Active: Tue 23 Feb 2021
Posts: 18,
Visits: 88
|
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.
Fri 13 Feb 2015 by
simonrl
|
|
Group: Administrators
Last Active: Fri 15 Sep 2023
Posts: 806,
Visits: 2,737
|
Can you try running this SQL on the db -
ALTER TABLE [dbo].[tblKartrisProducts] DROP CONSTRAINT [CK_Products_VersionsSortDirection]
GO
--
If my post solves your issue, can you 'Mark as Answer' so it's easier for other users to find in future.
If you would like to be informed of new features, new releases, developments and occasional special bonuses, please sign up to our mailing list: http://bit.ly/19sKMZb
|
|
Group: Forum Members
Last Active: Tue 23 Feb 2021
Posts: 18,
Visits: 88
|
Yes, that worked. Many thanks Paul.
|