部署之后出现错误 ERROR near "DUPLICATE": syntax error

[J-Snowwite]

[root@centos7 newsnow]# docker compose up -d
[+] Running 2/2
✔ Network newsnow_default Created 0.0s
✔ Container newsnow Started 0.4s
[root@centos7 newsnow]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
a3ae74a094a3 ghcr.io/ourongxing/newsnow:latest "docker-entrypoint.s…" 5 seconds ago Up 3 seconds 0.0.0.0:4444->4444/tcp, :::4444->4444/tcp newsnow

[root@centos7 newsnow]# docker logs a3
Listening on http://0.0.0.0:4444
[root@centos7 newsnow]# docker logs a3
Listening on http://0.0.0.0:4444
🔗 Using MySQL database
✔ init cache table 1:38:50 AM
🔗 Using MySQL database
🔗 Using MySQL database
🔗 Using MySQL database
🔗 Using MySQL database
🔗 Using MySQL database
🔗 Using MySQL database
✔ init cache table 1:38:50 AM
✔ init cache table 1:38:50 AM
✔ init cache table 1:38:50 AM
✔ init cache table 1:38:50 AM
✔ init cache table 1:38:50 AM
✔ init cache table 1:38:50 AM

ERROR near "DUPLICATE": syntax error 1:38:50 AM

at Database.prepare (output/server/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
at StatementWrapper._statement (output/server/chunks/nitro/nitro.mjs:5260:58)
at StatementWrapper.run (output/server/chunks/nitro/nitro.mjs:5268:22)
at Cache.set (output/server/chunks/_/cache.mjs:52:9)
at Object.handler (output/server/chunks/routes/api/index2.mjs:3295:31)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Object.handler (output/server/chunks/nitro/nitro.mjs:1616:19)
at async Server.toNodeHandle (output/server/chunks/nitro/nitro.mjs:1887:7)

🔗 Using MySQL database
✔ init cache table 1:38:51 AM

ERROR near "DUPLICATE": syntax error 1:38:51 AM

at Database.prepare (output/server/node_modules/better-sqlite3/lib/methods/wrappers.js:5:21)
at StatementWrapper._statement (output/server/chunks/nitro/nitro.mjs:5260:58)
at StatementWrapper.run (output/server/chunks/nitro/nitro.mjs:5268:22)
at Cache.set (output/server/chunks/_/cache.mjs:52:9)
at Object.handler (output/server/chunks/routes/api/index2.mjs:3295:31)
at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
at async Object.handler (output/server/chunks/nitro/nitro.mjs:1616:19)
at async Server.toNodeHandle (output/server/chunks/nitro/nitro.mjs:1887:7)

[521141]

@J-Snowwite 在修了！等会我再测试一下。

[ourongxing]

已经移除 mysql 支持，请拉取最新 docker 镜像

[J-Snowwite]

可以了