1.4.9 SQL update error - General Questions https://solidcp.com/forum/question/1-4-9-sql-update-error/ SolidCP Discussion Board en-US Mon, 14 Sep 2026 09:04:02 +0000 wpForo 60 RE: 1.4.9 SQL update error https://solidcp.com/forum/question/1-4-9-sql-update-error/#post-10141 Fri, 19 May 2023 09:16:18 +0000 Hello,

  1. Verify that the SQL script file 'update_db.sql' exists in the specified location: 'C:\Program Files (x86)\SolidCP Installer\Tmp\setup'.

  2. Check the contents of the SQL script for any errors or missing commands. Ensure that the script is properly formatted and valid.

  3. Ensure that the installer has the necessary permissions to access and execute the SQL script file.

  4. Try running the upgrade process again after resolving any potential issues with the script or the installer.

If the issue persists, you may need to seek further assistance from the SolidCP support team or consult the documentation provided by the software vendor for troubleshooting specific upgrade errors.

]]> General Questions croverwn.o.rene8 https://solidcp.com/forum/question/1-4-9-sql-update-error/#post-10141 RE: 1.4.9 SQL update error https://solidcp.com/forum/question/1-4-9-sql-update-error/#post-10131 Tue, 02 May 2023 18:45:14 +0000 That page is missing an important first step for v1.4.9 update: Make sure .NET Framework 4.8 is installed on all servers.

]]> General Questions Dolphyn5 https://solidcp.com/forum/question/1-4-9-sql-update-error/#post-10131 RE: 1.4.9 SQL update error https://solidcp.com/forum/question/1-4-9-sql-update-error/#post-10115 Mon, 06 Mar 2023 20:58:54 +0000 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/

]]> General Questions Genadij https://solidcp.com/forum/question/1-4-9-sql-update-error/#post-10115 1.4.9 SQL update error https://solidcp.com/forum/question/1-4-9-sql-update-error/#post-10111 Thu, 02 Mar 2023 20:49:55 +0000 Hi guys,

 

im getting this when running the Enterprise server upgrade via the installer

 

END: Copied files
START: Installing database objects
INFO: Executing 1623 database commands
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

 

 

]]> General Questions Ian Tobin https://solidcp.com/forum/question/1-4-9-sql-update-error/#post-10111