Notifications

Clear all

SQL Error on upgrade

JimJams · 2019-03-04T19:10:37Z

Hi, Just upgraded from 1.4.0 to 1.4.2 SQL Error in powershell and then ran upgrade SQL again manually in SSMS and same error: -- 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. -- CP seems fine and all functions appear to be working. Can see SpamExperts options, but cannot see MySQL 8 options under servers. Wandering what has been broken now. Any ideas? Thanks.

Page 3 / 3 Prev

General Questions

Last Post by Trevor Robinson 6 years ago

14 Posts

2 Users

0 Reactions

4,248 Views

RSS

Posts: 1514

Trevor Robinson

Admin

Mar 05, 2019 12:16 am

(@trobinson)

Noble Member

Joined: 9 years ago

Hello,

I have manually downloaded the files and checked and they all have update_db.sql inside setup folder updated today with the fix.

Can you make sure you remove the downloaded files first before trying again?

Thanks,

Trevor

Posts: 115

JimJams

Topic starter

Mar 05, 2019 12:15 pm

(@jimjams)

Estimable Member

Joined: 9 years ago

Thanks i got it now and it worked perfectly. Really appreciate all your help.

Posts: 115

JimJams

Topic starter

Mar 05, 2019 2:15 pm

(@jimjams)

Estimable Member

Joined: 9 years ago

New issue though, there are no options under MySQL8 in the Hosting Plan screen.
See attached screenshot.

Posts: 1514

Trevor Robinson

Admin

Mar 06, 2019 1:43 pm

(@trobinson)

Noble Member

Joined: 9 years ago

Hello,

I have just checked the code and there was some changes to fully support MySQL 8 in the next version of SolidCP. I would advise wait until 1.4.3 to be able to use this fully.

Kind Regards,

Trevor

Page 3 / 3 Prev

2 Forums
2,211 Topics
10.3 K Posts
2 Online
3,584 Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed