配置为sqlite后启动服务器失败

[eureka176]

在app/server/.env里面配置

DATABASE_URL="file:../data/wewe-rss.db" DATABASE_TYPE="sqlite"

启动后报错：

PrismaClientInitializationError: error: Error validating datasource db: the URL must start with the protocol mysql://. --> schema.prisma:3 | 2 | provider = "mysql" 3 | url = env("DATABASE_URL") |

Validation Error Count: 1 at r (/home/kali/Downloads/wewe-rss-20240303043604/node_modules/.pnpm/@[email protected][email protected]/node_modules/@prisma/client/runtime/library.js:113:2493) at async Proxy.onModuleInit (/home/kali/Downloads/wewe-rss-20240303043604/apps/server/dist/prisma/prisma.service.js:14:9) at async Promise.all (index 0) at async callModuleInitHook (/home/kali/Downloads/wewe-rss-20240303043604/node_modules/.pnpm/@[email protected]_@[email protected]_@[email protected][email protected][email protected]/node_modules/@nestjs/core/hooks/on-module-init.hook.js:43:5) at async NestApplication.callInitHook (/home/kali/Downloads/wewe-rss-20240303043604/node_modules/.pnpm/@[email protected]_@[email protected]_@[email protected][email protected][email protected]/node_modules/@nestjs/core/nest-application-context.js:223:13) at async NestApplication.init (/home/kali/Downloads/wewe-rss-20240303043604/node_modules/.pnpm/@[email protected]_@[email protected]_@[email protected][email protected][email protected]/node_modules/@nestjs/core/nest-application.js:100:9) at async NestApplication.listen (/home/kali/Downloads/wewe-rss-20240303043604/node_modules/.pnpm/@[email protected]_@[email protected]_@[email protected][email protected][email protected]/node_modules/@nestjs/core/nest-application.js:169:33) at async bootstrap (/home/kali/Downloads/wewe-rss-20240303043604/apps/server/dist/main.js:32:5) { clientVersion: '5.10.1', errorCode: 'P1012' }

[anuxs]

估计没改对或者没改全，还是走的mysql

[gtfvool]

我也遇到过，看了下Dockerfile发现其中有这么一步 cd /app-sqlite &&
rm -rf ./prisma &&
mv prisma-sqlite prisma &&
pnpm exec prisma generate 我执行了上述命令后就没问题了

[howie-chen]

用 Zeabur + sqlite 方案部署，我是 fork 之后用 apps/server/prisma-sqlite 替换 prisma 目录，然后再 deploy。