[GH-ISSUE #691] 更新最新版后启动错误,无法进入UI #1694

Closed
opened 2026-02-27 12:12:39 +03:00 by kerem · 8 comments
Owner

Originally created by @chung1912 on GitHub (Nov 1, 2024).
Original GitHub issue: https://github.com/0xJacky/nginx-ui/issues/691

[GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production.

  • using env: export GIN_MODE=release

2024-11-01 13:49:42 FATAL /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.9.12/model/model.go:61 malformed database schema (idx_sites_path) - invalid rootpage

  • using code: gin.SetMode(gin.ReleaseMode)

2024/11/01 13:49:42 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.9.12/model/model.go:51

[error] failed to initialize database, got error malformed database schema (idx_sites_path) - invalid rootpage

Originally created by @chung1912 on GitHub (Nov 1, 2024). Original GitHub issue: https://github.com/0xJacky/nginx-ui/issues/691 [GIN-debug] [WARNING] Running in "debug" mode. Switch to "release" mode in production. - using env: export GIN_MODE=release 2024-11-01 13:49:42 FATAL /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.9.12/model/model.go:61 malformed database schema (idx_sites_path) - invalid rootpage - using code: gin.SetMode(gin.ReleaseMode) 2024/11/01 13:49:42 /home/runner/go/pkg/mod/github.com/uozi-tech/cosy@v1.9.12/model/model.go:51 [error] failed to initialize database, got error malformed database schema (idx_sites_path) - invalid rootpage
kerem 2026-02-27 12:12:39 +03:00
Author
Owner

@0xJacky commented on GitHub (Nov 1, 2024):

参考这个解决:https://github.com/0xJacky/nginx-ui/issues/673

<!-- gh-comment-id:2451339832 --> @0xJacky commented on GitHub (Nov 1, 2024): 参考这个解决:https://github.com/0xJacky/nginx-ui/issues/673
Author
Owner

@chung1912 commented on GitHub (Nov 1, 2024):

参考这个解决:#673

先是出现错误:UNIQUE constraint failed: sites.path
我参照这个方法https://github.com/0xJacky/nginx-ui/issues/673, 在database.db里面清空 了sites 表,结果就报我发出来的那个错误

<!-- gh-comment-id:2451344306 --> @chung1912 commented on GitHub (Nov 1, 2024): > 参考这个解决:#673 先是出现错误:UNIQUE constraint failed: sites.path 我参照这个方法https://github.com/0xJacky/nginx-ui/issues/673, 在database.db里面清空 了sites 表,结果就报我发出来的那个错误
Author
Owner

@0xJacky commented on GitHub (Nov 1, 2024):

那可能 sqlite 文件损坏了,重新安装吧

<!-- gh-comment-id:2451348594 --> @0xJacky commented on GitHub (Nov 1, 2024): 那可能 sqlite 文件损坏了,重新安装吧
Author
Owner

@chung1912 commented on GitHub (Nov 1, 2024):

那可能 sqlite 文件损坏了,重新安装吧

我里面十几个站点,会需要重新配置?

<!-- gh-comment-id:2451349638 --> @chung1912 commented on GitHub (Nov 1, 2024): > 那可能 sqlite 文件损坏了,重新安装吧 我里面十几个站点,会需要重新配置?
Author
Owner

@chung1912 commented on GitHub (Nov 1, 2024):

那可能 sqlite 文件损坏了,重新安装吧

重新安装进不去,用户名密码不正确,admin/admin进不去,原来的用户名密码也进不去

<!-- gh-comment-id:2451358602 --> @chung1912 commented on GitHub (Nov 1, 2024): > 那可能 sqlite 文件损坏了,重新安装吧 重新安装进不去,用户名密码不正确,admin/admin进不去,原来的用户名密码也进不去
Author
Owner

@0xJacky commented on GitHub (Nov 1, 2024):

删掉原来的db

<!-- gh-comment-id:2451365746 --> @0xJacky commented on GitHub (Nov 1, 2024): 删掉原来的db
Author
Owner

@chung1912 commented on GitHub (Nov 1, 2024):

删掉原来的db

我直接删除了原来的db,其他配置参数不变,然后重新部署,会创建一个新的db,但使用admin/admin登录,提示用户名密码不正确,然后错误日志2024/11/01 14:24:18 /home/runner/work/nginx-ui/nginx-ui/internal/user/login.go:38 record not found
打开数据库查看,发现auths表是空的

<!-- gh-comment-id:2451368718 --> @chung1912 commented on GitHub (Nov 1, 2024): > 删掉原来的db 我直接删除了原来的db,其他配置参数不变,然后重新部署,会创建一个新的db,但使用admin/admin登录,提示用户名密码不正确,然后错误日志2024/11/01 14:24:18 /home/runner/work/nginx-ui/nginx-ui/internal/user/login.go:38 record not found 打开数据库查看,发现auths表是空的
Author
Owner

@chung1912 commented on GitHub (Nov 1, 2024):

删掉原来的db

解决了,要把那个app.ini文件也一并删除才行

<!-- gh-comment-id:2451384537 --> @chung1912 commented on GitHub (Nov 1, 2024): > 删掉原来的db 解决了,要把那个app.ini文件也一并删除才行
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/nginx-ui#1694
No description provided.