1.4.9 SQL update er...
 
Notifications
Clear all

1.4.9 SQL update error

4 Posts
4 Users
0 Likes
877 Views
Posts: 22
Topic starter
(@itobin)
Eminent Member
Joined: 6 years ago

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

 

 

3 Replies
Posts: 109
(@berkut)
Estimable Member
Joined: 6 years ago

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/

Reply
Posts: 66
(@dolphyn5)
Trusted Member
Joined: 7 years ago

That page is missing an important first step for v1.4.9 update: Make sure .NET Framework 4.8 is installed on all servers.

Reply
Posts: 3
Customer
(@croverwn-o-rene8)
New Member
Joined: 10 months ago

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.

Reply
Share: