gitea
gitea copied to clipboard
Migration 220 fails against MSSQL 2008R2 SP3 database
Description
When upgrading to 1.17, the process failed.
Gitea Version
1.17
Can you reproduce the bug on the Gitea demo site?
No
Operating System
Windows 10
How are you running Gitea?
On windows 10 as a service. Using MSSQL 2008R2 SP3 for the database. this is the minimum supported version according to the configuration | databases section of https://docs.gitea.io/en-us/ however CONCAT isn't supported by MSSQL till version 2016 I think.
2022/08/02 14:30:05 cmd/web.go:160:runWeb() [I] PING DATABASE mssql
2022/08/02 14:30:05 ...ations/migrations.go:501:Migrate() [I] Migration[220]: Add container repository property
2022/08/02 14:30:05 routers/common/db.go:33:InitDBEngine() [E] ORM engine initialization attempt #7/10 failed. Error: migrate: migration[220]: Add container repository property failed: mssql: 'CONCAT' is not a recognized built-in function name.
2022/08/02 14:30:05 routers/common/db.go:34:InitDBEngine() [I] Backing off for 3 seconds
2022/08/02 14:30:08 routers/common/db.go:27:InitDBEngine() [I] ORM engine initialization attempt #8/10...
Database
MSSQL