asp.net error after upgrading errors from MSPControl

Posts: 16

funsurfer

Topic starter

Oct 09, 2016 6:22 pm

(@funsurfer)

Active Member

Joined: 8 years ago

After the bugfixes last time (thanks@ Marco) i have an other error.

If i go to user i becoem an error. it seems that SolidCP lookt for a collum "TwoFactorToken" in dbo.users. But this colum we have drop in last bugfix. I have instelld teh portal again, but no change. i ended up in recreate the collum nvarchar(255).

Since then it worked. i looked in th original database, there is no such colum.

Can you please provide me a fix for that bug?

Have send yn E-Mail to Marco twice, no answer since then.

brgds

12 Replies

Posts: 1995

Marco Tiggelaar

Admin

Oct 09, 2016 6:26 pm

(@m-tiggelaar)

Noble Member

Joined: 9 years ago

Hello,

sounds like an odd bug we will check it out.

PS: I haven't received any email, did you send it directly to me or to a ticket email address? (our osticket system is having some issues since last upgrade which should be resolved shortly).

Reply

1 Reply

Posts: 1509

Trevor Robinson

Admin

Oct 09, 2016 7:05 pm

(@trobinson)

Noble Member

Joined: 9 years ago

Hi,

Sounds like you will need to run the MSControl upgrade script.

If you can download http://installer.solidcp.com/Files/stable/Tools/MSPtoSCP.zip and then run the .sql file in SQL Studio before running the update_db.sql it should fix the issues.

Any problems let me know. As far as I am aware it works with the recent versions of MSPControl.

Kind Regards,

Trevor Robinson

Reply

Posts: 16

funsurfer

Topic starter

Oct 12, 2016 8:51 pm

(@funsurfer)

Active Member

Joined: 8 years ago

now i have the same error again.

Process information:
Process ID: 4732
Process name: w3wp.exe
Account name: HOSTEDSCPPortal

Exception information:
Exception type: SoapException
Exception message: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Error executing 'GET_EXCHANGE_MAILBOXPLANS' task on '' EXCHANGE ---> System.Data.SqlClient.SqlException: Ungültiger Spaltenname 'TwoFactorToken'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

result from script:
(0 Zeile(n) betroffen)

(0 Zeile(n) betroffen)

(5 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)

(1 Zeile(n) betroffen)

(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 '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: 1509

Trevor Robinson

Admin

Oct 12, 2016 11:42 pm

(@trobinson)

Noble Member

Joined: 9 years ago

Hello,

We need to do some work on the MSPtoSCP.sql script. I will update you once this has been completed.

Kind Regards,

Trevor Robinson

Reply

Forum

asp.net error after upgrading errors from MSPControl