asp.net error after upgrading errors from MSPControl

Posts: 1509

Trevor Robinson

Admin

Oct 14, 2016 7:13 pm

(@trobinson)

Noble Member

Joined: 9 years ago

Hello,

I have published a update to the SQL script. If you have ran it there will be errors as some of the changes have been made to your database.

Kind Regards,

Trevor Robinson

Reply

Posts: 16

funsurfer

Topic starter

Oct 14, 2016 9:15 pm

(@funsurfer)

Active Member

Joined: 8 years ago

hy, ran it again, but no change. The error continue..

Script errors:

(0 Zeile(n) betroffen)

(0 Zeile(n) betroffen)
Meldung 547, Ebene 16, Status 0, Zeile 1
The DELETE statement conflicted with the REFERENCE constraint "FK_Quotas_ServiceItemTypes". The conflict occurred in database "WebsitePanel", table "dbo.Quotas", column 'ItemTypeID'.
The statement has been terminated.

(0 Zeile(n) betroffen)

(0 Zeile(n) betroffen)
Meldung 102, Ebene 15, Status 1, Zeile 2
Incorrect syntax near 'GP'.

(0 Zeile(n) betroffen)

(0 Zeile(n) betroffen)
Meldung 2705, Ebene 16, Status 4, Zeile 3
Column names in each table must be unique. Column name 'InstantMessenger' in table 'dbo.Users' is specified more than once.
Meldung 2705, Ebene 16, Status 4, Zeile 1
Column names in each table must be unique. Column name 'IsDemo' in table 'dbo.Users' is specified more than once.
Meldung 4924, Ebene 16, Status 1, Zeile 3
ALTER TABLE DROP COLUMN failed because column 'PeerAllLocations' does not exist in table 'Users'.
Meldung 4924, Ebene 16, Status 1, Zeile 1
ALTER TABLE DROP COLUMN failed because column 'PeerRoleId' does not exist in table 'Users'.
Meldung 4924, Ebene 16, Status 1, Zeile 1
ALTER TABLE DROP COLUMN failed because column 'TwoFactorToken' does not exist in table 'Users'.
Meldung 4924, Ebene 16, Status 1, Zeile 1
ALTER TABLE DROP COLUMN failed because column 'TwoFactorProvider' does not exist in table 'Users'.
Meldung 4924, Ebene 16, Status 1, Zeile 1
ALTER TABLE DROP COLUMN failed because column 'FailedLoginUtc' does not exist in table 'Users'.
Meldung 4924, Ebene 16, Status 1, Zeile 1
ALTER TABLE DROP COLUMN failed because column 'LoginLockedUtc' does not exist in table 'Users'.
Meldung 4924, Ebene 16, Status 1, Zeile 1
ALTER TABLE DROP COLUMN failed because column 'PasswordChanged' does not exist in table 'Users'.
Meldung 4924, Ebene 16, Status 1, Zeile 1
ALTER TABLE DROP COLUMN failed because column 'LastLoginDate' does not exist in table 'Users'.

Reply

Posts: 16

funsurfer

Topic starter

Oct 16, 2016 10:55 am

(@funsurfer)

Active Member

Joined: 8 years ago

it seems, that a routine want the two factor collum? if i create a collum it works. but this cant be the right way or?

Reply

Posts: 1509

Trevor Robinson

Admin

Oct 16, 2016 11:38 am

(@trobinson)

Noble Member

Joined: 9 years ago

Hello,

It appears i missed a stored procedure. I have just updated the script. If you can rerun it (Ignore the errors) and see if it fixes the errors?

Thanks,

Trevor Robinson

Reply

Posts: 16

funsurfer

Topic starter

Oct 17, 2016 8:48 pm

(@funsurfer)

Active Member

Joined: 8 years ago

Hi!

Perfect. Now it works.

brgds

Reply

Forum