1.4.9 SQL update er...
 
Notifications
Clear all

1.4.9 SQL update error

2 Posts
2 Users
0 Likes
157 Views
Posts: 18
Topic starter
(@itobin)
Eminent Member
Joined: 5 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

 

 

1 Reply
Posts: 108
(@berkut)
Estimable Member
Joined: 5 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
Share: