I've still not sussed this, but I have made some progress. I realised then when I get the error, it doesn't ask me to log in to Umbraco (even with cookies cleared, private window), which is strange. The install always asks for a login in my experience, and did when completing the successful local upgrade.

I found that if I connect to the remote database from my local code, I get the same error.

If I dump the remote database and restore it locally, I'm not even able to log in. But some of the table schemas are not dbo. The following tables have a schema matching the database user: cmsMedia, umbracoAudit, umbracoConsent, umbracoUser2UserGroup, umbracoUserGroup, umbracoUserGroup2App, umbracoUserGroup2Node, umbracoUserLogin, umbracoUserStartNode.

If I alter these tables to have the dbo schema, suddenly the upgrade works! So I have a potential path for getting an upgraded site working remotely now, but I'm still baffled at why this is happening, and how I can stop it from happening in future, so if anyone has any ideas I'd love to hear them :)

Just in case anyone else has this issue, my solution was to switch the site into maintenance mode, bring the live database down to dev, alter the offending tables to use dbo schema, run the upgrade, and then replace the live database with my upgraded one. Quite a faff, but it's done the job. Now to see if it keeps happening that way...

We ran into the same issue in a shared hosting environment. We were able to resolve this by downloading the db, upgrading Umbraco locally, then uploading the db and files.

It's not just the tables that have to be in the dbo schema.

You also need access to some of the other admin features of the SQL Server. Possibly the some sys. views in the master DB?

I'm not sure what exactly, but I know I couldn't upgrade on a hosted SQL server where I do not have admin access, even though all the tables were in the accessible dbo schema. I would get the "Invalid column name 'controlid'" error, even on a clean, empty umbraco install upgrade from 12.4 to 13.0.

Copying the DB down to a SQL server where I had admin access to the master db, changing the umbraco connection string in web.config, upgrading, and then copying the upgraded DB back up to the hosted server worked for me.

I've just hit this same issue but your solution is not an option for me as the site is load balanced and I can't afford the downtime to upgrade the database offline.

What's odd is that the upgrade worked elsewhere.

This is a pretty nasty issue which I need to investigate as something must have changed that I missed. In the past I used to sometimes have the opposite problem whereby new tables would be created with the database user schema as the owner and upgrades would fail but this is the other way around. The upgrade fails because the tables are owned by the dbo schema and not the database user.

In case it helps anyone else here is a script to allow you to iterate over all of your tables to change the owner:

DECLARE @old sysname, @new sysname, @sql varchar(1000)

SELECT
  @old = 'dbo'
  , @new = 'XXXX_DBUSR2'
  , @sql = '
  IF EXISTS (SELECT NULL FROM INFORMATION_SCHEMA.TABLES
  WHERE
      QUOTENAME(TABLE_SCHEMA)+''.''+QUOTENAME(TABLE_NAME) = ''?''
      AND TABLE_SCHEMA = ''' + @old + '''
  )
  EXECUTE sp_changeobjectowner ''?'', ''' + @new + ''''

EXECUTE sp_MSforeachtable @sql

I just had this issue and found it was due to having put the wrong version number in web.config. I was doing a set of rapid DB updates in a sequence to the live version of the site database having done the main file work on an old version.

The error was "Invalid column name 'controlId'"

Easy done!

is working on a reply...