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
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).
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
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)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(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)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(1 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 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)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(0 Zeile(n) betroffen)
(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'.
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
