Jinnrry/PMail

【BUG】首次配置SQLite3时出错

Closed this issue · 5 comments

crrashh1542 commented

请说明问题 / Describe the bug

  • 出现版本：仅限v2.4.4
  • 出现平台：Windows、Linux（macOS未测试）
  • 部署方式：独立二进制&Docker

每当使用SQLite3进行首次配置时，都会报错：at /home/runner/work/PMail/PMail/server/services/setup/db.go:48 SQL logic error: no such table: user (1)

如何复现 / To Reproduce
Steps to reproduce the behavior:

  1. 启动程序
  2. 选择SQLite3
    image
  3. 报错，且无法创建用户，同时创建的db文件为空
    image
    image
    （Linux场景下问题同样如上，故不再额外演示）

你预期的行为 / Expected behavior
正常创建带有一定结构的db文件，并能够正常进入邮件系统

贴上你的配置文件 / Program configuration file contents

config.json

（以下内容已经过VSCode格式化）

{
    "logLevel": "",
    "domain": "",
    "domains": null,
    "webDomain": "",
    "dkimPrivateKeyPath": "config/dkim/dkim.priv",
    "sslType": "",
    "SSLPrivateKeyPath": "config/ssl/private.key",
    "SSLPublicKeyPath": "config/ssl/public.crt",
    "dbDSN": "./config/pmail.db",
    "dbType": "sqlite",
    "httpsEnabled": 0,
    "spamFilterLevel": 0,
    "httpPort": 0,
    "httpsPort": 0,
    "weChatPushAppId": "",
    "weChatPushSecret": "",
    "weChatPushTemplateId": "",
    "weChatPushUserId": "",
    "tgBotToken": "",
    "tgChatId": "",
    "isInit": false,
    "webPushUrl": "",
    "webPushToken": ""
}

日志信息 / Log

log

（在后续执行中没有任何SQL操作相关日志）

[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/main.go:81]*******************************************************************
[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/main.go:82]*** Server Start Success

[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/main.go:83]*** Server Version: v2.4.4

[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/main.go:84]*** Git Commit Hash: 937186437916efcef1f7dc75f253d4cb47fde52e
[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/main.go:85]*** Build Date: 2024-04-13 09:50:50
[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/main.go:86]*** Build GoLang Version: go version go1.22.2 linux/amd64
[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/main.go:87]*******************************************************************
[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/res_init/init.go:26]Please click http://127.0.0.1 to continue.

[info][2024-04-14 01:03:17][/home/runner/work/PMail/PMail/server/http_server/setup_server.go:32]HttpServer Start On Port :80

个人推测是更新依赖更炸了

haogege commented

我同样错误

crrashh1542 commented

我同样错误

退回到v2.4.2即可解决

Jinnrry commented

已经修复了，新发了一个v2.4.5版本

  • 👍1
Jinnrry commented

已经修复了，新发了一个v2.4.5版本

还是有问题，少初始化了一张表

Jinnrry commented

现在的2.4.5版本初始化问题应该都修复了

  • 👍1