I manually restored everything back to 1.4.9 and this is the conclusion:
- Error in "Edit Domain" is gone, so it definitely has something to do with upgrade to 1.5.0
- Errors in "Mail Aliases" and "Groups" (for certain accounts) are there, so it must be an issue not related to 1.5.0. I did a server migration and imported resources in 1.4.9 so the issue is probably there. Doesn't matter as I can recreate aliases and groups.
A side note: I have initially upgraded from 1.4.9 to 1.5.0 via PowerShell script. When I checked for updates via SolidCP Installer 1.4.9, it saw my installation as 1.4.9 and offered an upgrade again. When I let it upgrade, it did successfully Portal and Server, but threw error on Enterprise Server:
[8.12.2024. 12:46:02] START: Copying files [8.12.2024. 12:46:02] INFO: Copying files from "C:\Program Files (x86)\SolidCP Installer\Tmp" to "C:\SolidCP\Enterprise Server" [8.12.2024. 12:46:02] END: Copied files [8.12.2024. 12:46:02] START: Installing database objects [8.12.2024. 12:46:02] INFO: Executing 1624 database commands [8.12.2024. 12:46:04] ERROR: Run sql error System.Exception: Can't run SQL script C:\Program Files (x86)\SolidCP Installer\Tmp\setup\update_db.sql ---> System.Exception: Error executing SQL command: ---> System.InvalidOperationException: ExecuteNonQuery: CommandText property has not been initialized at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at SolidCP.Setup.SqlProcess.Run() --- End of inner exception stack trace --- at SolidCP.Setup.SqlProcess.Run() --- End of inner exception stack trace --- at SolidCP.Setup.SqlProcess.Run() at SolidCP.Setup.ExpressInstallPage.RunSqlScript(String connectionString, String database, String fileName) at SolidCP.Setup.ExpressInstallPage.ExecuteSqlScript(String file) [8.12.2024. 12:46:08] INFO: RollBackPage loaded. [8.12.2024. 12:46:08] START: Rolling back [8.12.2024. 12:46:09] INFO: Setup wizard was canceled by user [8.12.2024. 12:46:09] INFO: Setup wizard was canceled by user [8.12.2024. 12:46:09] INFO: Setup wizard closed. [8.12.2024. 12:46:09] INFO: Setup wizard was canceled by user
I know you are overwhelmed by everything else going on, so I don't expect you to deal with this any longer.
I'm also getting an edit domain error after updating to 1.50, but mine is a little different. Occurs same time though, opening any domain.
(Checked all updates are 1.5.0 - running DNS 2019)
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.NullReferenceException: Object reference not set to an instance of an object. at SolidCP.EnterpriseServer.ServerController.GetDomain(Int32 domainId, Boolean withLog) at SolidCP.EnterpriseServer.esServers.GetDomain(Int32 domainId) --- End of inner exception stack trace --- at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at SolidCP.EnterpriseServer.esServers.GetDomain(Int32 domainId) at SolidCP.Portal.DomainsEditDomain.BindDomain()
The only errors I got from SolidCP in Event Viewer are these, but these are happening since always and have thousands of them:
ERROR: Could not retrieve Web Deploy key from the registry System.NullReferenceException: Object reference not set to an instance of an object. at SolidCP.Providers.Web.IIs70.IsWebDeployInstalled()
If you are still running 1.5.0 could you try run the following on your SolidCP database for me to see if it helps fix the issue?
IF NOT EXISTS (Select * from [ServiceProperties] INNER JOIN Services ON ServiceProperties.ServiceID=Services.ServiceID Where Services.ProviderID IN (7, 9, 24, 28, 55, 56, 410, 1703, 1901, 1902, 1903) AND ServiceProperties.PropertyName = N'RecordMinimumTTL') BEGIN DECLARE service_cursor CURSOR FOR SELECT ServiceId FROM Services WHERE ProviderID IN (7, 9, 24, 28, 55, 56, 410, 1703, 1901, 1902, 1903) DECLARE @ServiceID INT OPEN service_cursor FETCH NEXT FROM service_cursor INTO @ServiceID WHILE @@FETCH_STATUS = 0 BEGIN BEGIN INSERT [dbo].[ServiceProperties] ([ServiceID], [PropertyName], [PropertyValue]) VALUES (@ServiceID, N'RecordMinimumTTL', N'3600') INSERT [dbo].[ServiceProperties] ([ServiceID], [PropertyName], [PropertyValue]) VALUES (@ServiceID, N'RecordDefaultTTL', N'86400') END FETCH NEXT FROM service_cursor INTO @ServiceID END CLOSE service_cursor DEALLOCATE service_cursor END GO
Today we released v1.5.1 which includes a fix for the issue with preview domains.