Hi,
First of all I want do thanks to everyone who is involved in the creation of SolidCP.
We are old users since the time of Dot Net Panel and its was very sad see what Virtuworks did with an open source project.
Fortunately part of the community stand to keep the project open source and we are very thankfull for that.
The upgrade was smooth, we didn't get the upgrade using the powershell but we did it manually and everything its working well.
Anyway, I would like to ask if the database upgrade errors we receive is something that will hit us in the future:
Msg 547, Level 16, State 0, Line 3544
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Providers_ResourceGroups". The conflict occurred in database "DNP", table "dbo.ResourceGroups", column 'GroupID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 5353
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "DNP", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 5354
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "DNP", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 5355
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "DNP", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 5356
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "DNP", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 5357
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "DNP", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
(1 row(s) affected)
Msg 2627, Level 14, State 1, Line 5364
Violation of PRIMARY KEY constraint 'PK_ServiceItemTypes'. Cannot insert duplicate key in object 'dbo.ServiceItemTypes'. The duplicate key value is (202).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 5365
Violation of PRIMARY KEY constraint 'PK_ServiceItemTypes'. Cannot insert duplicate key in object 'dbo.ServiceItemTypes'. The duplicate key value is (203).
The statement has been terminated.
In the near future we will contribute with some work hour. I will try to contact some of you to see how can we contribute with some code.
Thanks,
Sérgio Rocha
Hello,
Can you sign our contributors agreement found here: https://solidcp.com/contributors/become-a-contributor/
Then you will have access to our contributors chat and we can look at your error more quickly and discuss how/if you want to contribute code.
Kind Regards,
Trevor Robinson