v0.23.1 =>> v0.25.0 can't startup with ERROR failed to migrate error="SQL logic error: no such column: \"tags\"

[wangningyu]

Pre-submission Checklist

• I have searched the existing issues and this bug has not been reported yet
• I have tested this issue on the demo site or the latest version

Where did you encounter this bug?

Older version (please specify below)

Memos Version

v0.25.0

Bug Description

old version: v0.23.1
new version: v0.25.0

I want to upgrade from the old version (V0.23.1) to (V0.25.0) in the DOCKER environment, but none of them can start. I have also tried many versions but still failed.

The following is the error log displayed in DOCKER:

`neosmemo-0.25.0
date,stream,content
2025-12-02 08:25:03,stdout,2025/12/02 16:25:03 ERROR failed to migrate error="SQL logic error: no such column: "tags" (1)\nfailed to execute statement\ngithub.com/usememos/memos/store.(*Store).execute\n\t/backend-build/store/migrator.go:242\ngithub.com/usememos/memos/store.(*Store).Migrate\n\t/backend-build/store/migrator.go:87\nmain.init.func1\n\t/backend-build/bin/memos/main.go:62\ngithub.com/spf13/cobra.(*Command).execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1019\ngithub.com/spf13/cobra.(*Command).ExecuteC\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1148\ngithub.com/spf13/cobra.(*Command).Execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1071\nmain.main\n\t/backend-build/bin/memos/main.go:184\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:283\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700\nmigrate error: -- Remove deprecated indexes.\nDROP INDEX IF EXISTS idx_memo_tags;\nDROP INDEX IF EXISTS idx_memo_content;\nDROP INDEX IF EXISTS idx_memo_visibility;\n\n-- Drop deprecated tags column.\nALTER TABLE memo DROP COLUMN tags;\ngithub.com/usememos/memos/store.(*Store).Migrate\n\t/backend-build/store/migrator.go:88\nmain.init.func1\n\t/backend-build/bin/memos/main.go:62\ngithub.com/spf13/cobra.(*Command).execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1019\ngithub.com/spf13/cobra.(*Command).ExecuteC\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1148\ngithub.com/spf13/cobra.(*Command).Execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1071\nmain.main\n\t/backend-build/bin/memos/main.go:184\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:283\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"

2025-12-02 08:25:03,stdout,2025/12/02 16:25:03 INFO start migration currentSchemaVersion=0.23.1 targetSchemaVersion=0.25.1

2025-12-02 08:24:53,stdout,2025/12/02 16:24:53 ERROR failed to migrate error="SQL logic error: no such column: "tags" (1)\nfailed to execute statement\ngithub.com/usememos/memos/store.(*Store).execute\n\t/backend-build/store/migrator.go:242\ngithub.com/usememos/memos/store.(*Store).Migrate\n\t/backend-build/store/migrator.go:87\nmain.init.func1\n\t/backend-build/bin/memos/main.go:62\ngithub.com/spf13/cobra.(*Command).execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1019\ngithub.com/spf13/cobra.(*Command).ExecuteC\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1148\ngithub.com/spf13/cobra.(*Command).Execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1071\nmain.main\n\t/backend-build/bin/memos/main.go:184\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:283\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700\nmigrate error: -- Remove deprecated indexes.\nDROP INDEX IF EXISTS idx_memo_tags;\nDROP INDEX IF EXISTS idx_memo_content;\nDROP INDEX IF EXISTS idx_memo_visibility;\n\n-- Drop deprecated tags column.\nALTER TABLE memo DROP COLUMN tags;\ngithub.com/usememos/memos/store.(*Store).Migrate\n\t/backend-build/store/migrator.go:88\nmain.init.func1\n\t/backend-build/bin/memos/main.go:62\ngithub.com/spf13/cobra.(*Command).execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1019\ngithub.com/spf13/cobra.(*Command).ExecuteC\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1148\ngithub.com/spf13/cobra.(*Command).Execute\n\t/go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1071\nmain.main\n\t/backend-build/bin/memos/main.go:184\nruntime.main\n\t/usr/local/go/src/runtime/proc.go:283\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1700"

2025-12-02 08:24:53,stdout,2025/12/02 16:24:53 INFO start migration currentSchemaVersion=0.23.1 targetSchemaVersion=0.25.1

`

I hope this issue can be fixed, thank you very much!

Steps to Reproduce

neosmemo-0.25.0.csv

Expected Behavior

No response

Screenshots & Additional Context

No response