Skip to content

Migration 220 fails against MSSQL 2008R2 SP3 database #20615

Closed
@snoopydo

Description

@snoopydo

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions