0

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.

Answered question