Installation and deployment
Version 7.x > Installation and deployment > Upgrade Errors V6-->V7 View modes: 
User avatar
Member
Member
jwilson-bostwicklaboratories - 12/21/2012 11:27:53 AM
   
Upgrade Errors V6-->V7
When we try using the Kentico Upgrade tool to upgrade our sites to V7, we are receiving this error:

-- Update table [COM_Order]
UPDATE [COM_Order] SET
[OrderCreatedByUserID] = NULL
WHERE [OrderCreatedByUserID] = 0;

ALTER TABLE [COM_Order]
ADD
CONSTRAINT [FK_COM_Order_OrderCreatedByUserID_CMS_User]
FOREIGN KEY ([OrderCreatedByUserID]) REFERENCES [CMS_User] ([UserID]);

Failed to run SQLscript: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_COM_Order_OrderCreatedByUserID_CMS_User". The conflict occurred in database "BostwickCMS_V7", table "dbo.CMS_User", column 'UserID'.
Running SQL script (upgrade_6_0.sql)

Any help would be much appreciated.

Thanks,
Jon Wilson

User avatar
Kentico Consulting
Kentico Consulting
kentico_borisp - 12/21/2012 8:57:10 PM
   
RE:Upgrade Errors V6-->V7
Hello,

You need to delete all the orders from the COM_Order table, where the OrderCreatedByUserID is pointing to a UserID in the CMS_User table which does not exist. Or you can update these orders in the COM_Order to point to a User which does exist.

Best regards,
Boris Pocatko