SQL Error on upgrad...
 
Notifications
Clear all

SQL Error on upgrade

Page 2 / 3

Trevor Robinson
Posts: 1444
Admin
(@trobinson)
Member
Joined: 6 years ago

Hello,

Thats correct you can download it at http://installer.solidcp.com/Files/stable/SolidCP-EnterpriseServer-Update.zip.

It is safe to run over a live DB but as always we do recommend a backup is taken.

Thanks,

Trevor Robinson

Reply
JimJams
Posts: 111
Topic starter
(@jimjams)
Estimable Member
Joined: 6 years ago

update_db.sql in the new file is dated 01/05/2019, is that correct?

Reply
JimJams
Posts: 111
Topic starter
(@jimjams)
Estimable Member
Joined: 6 years ago

Sorry 01/25/2019, but  i thought you may have just updated it so it would be todays date?

Ran it anyway and got:

Msg 547, Level 16, State 0, Line 20610
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Providers_ResourceGroups". The conflict occurred in database "mywbase", table "dbo.ResourceGroups", column 'GroupID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 20620
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "mywbase", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 20621
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "mywbase", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 20622
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "mywbase", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 20623
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "mywbase", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 20624
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "mywbase", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.
Msg 547, Level 16, State 0, Line 20625
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceDefaultProperties_Providers". The conflict occurred in database "mywbase", table "dbo.Providers", column 'ProviderID'.
The statement has been terminated.

---

Reply
Trevor Robinson
Posts: 1444
Admin
(@trobinson)
Member
Joined: 6 years ago

Hello,

It should show today's date. If you load http://installer.solidcp.com/Files/stable/ does it show modified today? Depending on your location it could still be replicating the files to the mirrors.

If that's the case please check http://nl.installer.solidcp.com/Files/stable/ and if you could provide the IP when trying to ping installer.solidcp.com that would be great.

Thanks,

Trevor

Reply
JimJams
Posts: 111
Topic starter
(@jimjams)
Estimable Member
Joined: 6 years ago

The ZIP is dated today, the update_db.sql inside it isn't.

Reply
Page 2 / 3
Share: