🐞 Error reinstall on docker : Database initialization error: unknown database type: "file:storages/whatsapp.db?_foreign_keys=on".

[admincrew]

What happened?

What happened?
reinstall for v7 (latest) gave me Database initialization error: unknown database type: "file:storages/whatsapp.db?_foreign_keys=on".

I'm on Armbian 23.05, Docker version 28.2.2, build e6534b4

Reproduction Steps

1.git clone
2.cd go-whatsapp-web-multidevice
3.cp src/.env.example src/.env
4.docker compose up -d --build
5.Build success
6.docker ps shows the container keep restarting

Relevant log output

whatsapp_go_1 | map[]
whatsapp_go_1 | 05:54:51.897 [Main ERROR] Database initialization error: unknown database type: "file:storages/whatsapp.db?_foreign_keys=on". Currently only sqlite3(file:) and postgres are supported
whatsapp_go_1 | panic: Database initialization error: unknown database type: "file:storages/whatsapp.db?_foreign_keys=on". Currently only sqlite3(file:) and postgres are supported
whatsapp_go_1 |
whatsapp_go_1 | goroutine 1 [running]:
whatsapp_go_1 | github.com/aldinokemal/go-whatsapp-web-multidevice/infrastructure/whatsapp.InitWaDB({0x1388d60, 0x1ca7be0})
whatsapp_go_1 | /whatsapp/infrastructure/whatsapp/init.go:63 +0x214
whatsapp_go_1 | github.com/aldinokemal/go-whatsapp-web-multidevice/cmd.initApp()
whatsapp_go_1 | /whatsapp/cmd/root.go:210 +0x128
whatsapp_go_1 | github.com/spf13/cobra.(*Command).preRun(...)
whatsapp_go_1 | /go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1049
whatsapp_go_1 | github.com/spf13/cobra.(*Command).execute(0x1b41240, {0x1ca7be0, 0x0, 0x0})
whatsapp_go_1 | /go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:959 +0x434
whatsapp_go_1 | github.com/spf13/cobra.(*Command).ExecuteC(0x1b41500)
whatsapp_go_1 | /go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1148 +0x384
whatsapp_go_1 | github.com/spf13/cobra.(*Command).Execute(...)
whatsapp_go_1 | /go/pkg/mod/github.com/spf13/cobra@v1.9.1/command.go:1071
whatsapp_go_1 | github.com/aldinokemal/go-whatsapp-web-multidevice/cmd.Execute({0x1b66868?}, {0x40000021c0?})
whatsapp_go_1 | /whatsapp/cmd/root.go:226 +0x64
whatsapp_go_1 | main.main()
whatsapp_go_1 | /whatsapp/main.go:15 +0x2c

Screenshots or Additional Context

Application Version

7.0.0

Verification

• I have checked for existing closed issues and discussions.

[baharsah]

you can use sqlite3(file:storages/whatsapp.db?_foreign_keys=on) in DB_URI section instead file:storages/whatsapp.db?_foreign_keys=on in .env.example file

[admincrew]

the output is also the same, I have searched for a solution through AI but it didn't solve my problem

[admincrew]

I get from AI
DATABASE_URL=sqlite3(file:./app/storages/whatsapp.db)?_foreign_keys=on

is it not quite right?

[aldinokemal]

Hi, I just tested by cloning the repo and running docker compose up --build.

I'm using the default setup and had no issues on my end.

# Application Settings
APP_PORT=3000
APP_DEBUG=false
APP_OS=Chrome
APP_BASIC_AUTH=user1:pass1,user2:pass2
APP_CHAT_FLUSH_INTERVAL=7

# Database Settings
DB_URI="file:storages/whatsapp.db?_foreign_keys=on"

# WhatsApp Settings
WHATSAPP_AUTO_REPLY="Auto reply message"
WHATSAPP_AUTO_MARK_READ=false
WHATSAPP_WEBHOOK=https://webhook.site/07b69616-5943-4c7f-a8be-db4819df699e,https://webhook.site/09a38aff-d11a-4a38-a176-3f3efa0b5e8b
WHATSAPP_WEBHOOK_SECRET=super-secret-key
WHATSAPP_ACCOUNT_VALIDATION=true
WHATSAPP_CHAT_STORAGE=true

[admincrew]

but why am I having problems in docker, initially by default from the repo there was no problem

[admincrew]

does docker version matter?

[admincrew]

I don't know why but suddenly it can be run

[admincrew]

just before docker-compose up -d
after docker compose up -d

[admincrew]

and it worked without any problems hahaha