Hi guys,
im getting this when running the Enterprise server upgrade via the installer
[02/03/2023 20:39:50] END: Copied files
[02/03/2023 20:39:50] START: Installing database objects
[02/03/2023 20:39:50] INFO: Executing 1623 database commands
[02/03/2023 20:40:02] 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)
any ideas on the issue?
thanks
Ian
The update installer is broken since 1.4.9, you should use a manual update or a special script. https://solidcp.com/kb/update/howto-update-solidcp-1-4-8-to-1-4-9/