Updating Gitea from 1.22.6 to 1.23.7 fails for MSSQL (SQL Server) on Windows

[caerbannogwhite]

Description

No response

Gitea Version

1.22.6

Can you reproduce the bug on the Gitea demo site?

No

Log Gist

2025/04/23 22:00:10 routers/common/db.go:36:InitDBEngine() [E] ORM engine initialization attempt #6/10 failed. Error: migrate: migration[299]: Add content version to issue and comment table failed: mssql: An explicit DROP INDEX is not allowed on index 'issue.issue$UQE_issue_repo_index'. It is being used for UNIQUE KEY constraint enforcement.

Screenshots

No response

Git Version

No response

Operating System

Windows x64

How are you running Gitea?

Self host

Database

MSSQL

[techknowlogick]

Which version of mssql are you using?

[techknowlogick]

Also, did you mean 1.23.7? As updating minor versions don't usually have migrations

[caerbannogwhite]

The database is currently stored with SQL Server 2019 (version 15.0.2130.3).
I already tried two or three times to upgrade from 1.22.6 to both 1.23.6 and 1.23.7, but the service doesn't start because of that error.

[caerbannogwhite]

Also, did you mean 1.23.7? As updating minor versions don't usually have migrations

Yes, apologies! I fixed the title.