SQL Error on upgrad...
 
Notifications
Clear all

SQL Error on upgrade

14 Posts
2 Users
0 Reactions
3,882 Views
Posts: 1457
Admin
(@trobinson)
Noble Member
Joined: 9 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
Posts: 115
Topic starter
(@jimjams)
Estimable Member
Joined: 8 years ago

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

Reply
Posts: 115
Topic starter
(@jimjams)
Estimable Member
Joined: 8 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
Posts: 1457
Admin
(@trobinson)
Noble Member
Joined: 9 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
Posts: 115
Topic starter
(@jimjams)
Estimable Member
Joined: 8 years ago

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

Reply
Page 2 / 3
Share: