I Think i have run all the necessary SQL but i still get the same error. Do you have a clue from the error where i should be looking?

Hello,

When you run the latest update_db.sql did it error at all?

Thanks,

Trevor Robinson

Yes:

Msg 515, Level 16, State 2, Line 9658

Cannot insert the value NULL into column 'GroupOrder', table 'Websitepanel.dbo.ResourceGroups'; column does not allow nulls. INSERT fails.

The statement has been terminated.

Msg 547, Level 16, State 0, Line 9659

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_Providers_ResourceGroups". The conflict occurred in database "Websitepanel", table "dbo.ResourceGroups", column 'GroupID'.

The statement has been terminated.

Msg 2627, Level 14, State 1, Line 9662

Violation of PRIMARY KEY constraint 'PK_Quotas'. Cannot insert duplicate key in object 'dbo.Quotas'. The duplicate key value is (550).

The statement has been terminated.

Msg 2627, Level 14, State 1, Line 9664

Violation of PRIMARY KEY constraint 'PK_Quotas'. Cannot insert duplicate key in object 'dbo.Quotas'. The duplicate key value is (551).

The statement has been terminated.

Msg 2627, Level 14, State 1, Line 9666

Violation of PRIMARY KEY constraint 'PK_Quotas'. Cannot insert duplicate key in object 'dbo.Quotas'. The duplicate key value is (552).

The statement has been terminated.

Hello,

Can you run this in SQL Management Studio new query and let me know if it returns anything:

SELECT * FROM [dbo].[ResourceGroups] WHERE [GroupID] = '33'

Thanks,

Trevor Robinson

Hi Trevor.

Yes:

GroupID GroupName GroupOrder GroupController ShowGroup
33 VPS2012 20 NULL 1