npx sv create SvelteKit demo fail Failed to detect DB dialect in your `drizzle.config.[js|ts]` file

[good-dev-student]

npx sv create test-svelte-5
┌ Welcome to the Svelte CLI! (v0.6.10)
│
◇ Which template would you like?
│ SvelteKit demo
│
◇ Add type checking with Typescript?
│ Yes, using Typescript syntax
│
◆ Project created
│
◇ What would you like to add to your project? (use arrow keys / space bar)
│ prettier, eslint, vitest, playwright, tailwindcss, sveltekit-adapter, drizzle, lucia, mdsvex, paraglide, storybook
│
◇ tailwindcss: Which plugins would you like to add?
│ typography, forms, container-queries
│
◇ sveltekit-adapter: Which SvelteKit adapter would you like to use?
│ node
│
◇ lucia: Do you want to include a demo? (includes a login/register page)
│ Yes
│
◇ drizzle: Which database would you like to use?
│ PostgreSQL
│
◇ drizzle: Which PostgreSQL client would you like to use?
│ Postgres.JS
│
◇ drizzle: Do you want to run the database locally with docker-compose?
│ Yes
│
◇ paraglide: Which languages would you like to support? (e.g. en,de-ch)
│ en,fr
│
◇ paraglide: Do you want to include a demo?
│ Yes
│
◇ Which package manager do you want to install dependencies with?
│ pnpm
│
■ Error: Unable to process 'drizzle.config.ts'. Reason: Failed to detect DB dialect in your drizzle.config.[js|ts] file
│ at Object.file (file:///C:/Users/sysadm/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-Bj_yXcZX.js:43711:17)
│ at Object.run (file:///C:/Users/sysadm/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:6824:8)
│ at runAddon (file:///C:/Users/sysadm/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-Bj_yXcZX.js:43743:15)
│ at applyAddons (file:///C:/Users/sysadm/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-Bj_yXcZX.js:43673:25)
│ at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
│ at async runAddCommand (file:///C:/Users/sysadm/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:12071:25)
│ at async createProject (file:///C:/Users/sysadm/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:12305:47)
│ at async file:///C:/Users/sysadm/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:12206:59
│ at async runCommand (file:///C:/Users/sysadm/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:8131:5)
│
└ Operation failed.

[manuel3108]

I have seen this errors arise in one of my recent PR's (log link), but I'm unable to reproduce this locally.

Would you mind sharing your OS and node version?

---

I think the error here might be that the lucia adder is being executed before the drizzle adder. At least locally the questions for drizzle and lucia are in the inverse order, which makes more sense, as lucia depends on the setup of the drizzle adder.

[Conduitry]

After a few worthless issues/PRs opened by this user yesterday, I blocked them from the org, so I'm afraid you're not going to get an answer. You can keep this issue open if you think this is something that you want to track, or you can go ahead and close it.

[manuel3108]

I think the error here might be that the lucia adder is being executed before the drizzle adder. At least locally the questions for drizzle and lucia are in the inverse order, which makes more sense, as lucia depends on the setup of the drizzle adder.

The questions for the specifc add-ons are actually asked on based on the selection order in the prompt. If you select (SPACE) lucia first and then drizzle, it's possible to get the questions in the same order as in the question.

But even with that out of the way, I'm unable to reproduce the error. If anybody else want's to give this a try or happens to be able to reproduce the issue, please feel free to reopen again.

[PSYCHEER]

Hey there!
I see it's not planned but I've firstly choosed lucia and I didn't know it needz drizzle so I've clicked to install it

Windows 11
NodeJS 22.13.0

Error: Unable to process 'drizzle.config.ts'. Reason: Failed to detect DB dialect in your `drizzle.config.[js|ts]` file
│      at Object.file (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-PTlNv0EA.js:1070:35)
│      at Object.run (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:5631:6)
│      at runAddon (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-PTlNv0EA.js:1111:14)
│      at applyAddons (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-PTlNv0EA.js:1026:50)
│      at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
│      at async runAddCommand (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:9980:79)
│      at async createProject (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:10226:45)
│      at async file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:10122:57
│      at async runCommand (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:6880:3)

After choosing drizzle first, it works.

[manuel3108]

@PSYCHEER Could you please provide the full console output (including the cli version)?

Only selecting lucia should not be a problem at all, as the cli is supposed to ask the following question:

Is it not asking the question for you?

[PSYCHEER]

@manuel3108
Sorry to say that but svelte appeared a bit overwhelming to me with a lot of files so I've switched to PREACT as I'm working on Discord bot dashboard running localy on the same Discord bot.

After I selected yes in lucia context menu for drizzle, it started to install but failed as I've said previously

I've installed yesterday a fresh trough npx sv create .

When I've started, I'll try to replicate...

PS E:\BBB\DiscordBot\.svelte> npx sv create .
┌  Welcome to the Svelte CLI! (v0.6.23)
│
◇  Which template would you like?
│  SvelteKit minimal
│
◇  Add type checking with Typescript?
│  Yes, using Typescript syntax
│
◆  Project created
│
◇  What would you like to add to your project? (use arrow keys / space bar)
│  prettier, eslint, vitest, playwright, tailwindcss, sveltekit-adapter, lucia, mdsvex, paraglide
│
◇  The lucia add-on requires drizzle to also be setup. Include it?
│  Yes
│
◇  tailwindcss: Which plugins would you like to add?
│  typography, forms
│
◇  sveltekit-adapter: Which SvelteKit adapter would you like to use?
│  node
│
◇  lucia: Do you want to include a demo? (includes a login/register page)
│  No
│
◇  paraglide: Which languages would you like to support? (e.g. en,de-ch)
│  en
│
◇  paraglide: Do you want to include a demo?
│  No
│
◇  drizzle: Which database would you like to use?
│  MySQL
│
◇  drizzle: Which MySQL client would you like to use?
│  mysql2
│
◇  drizzle: Do you want to run the database locally with docker-compose?
│  Yes
│
■  Error: Unable to process 'drizzle.config.ts'. Reason: Failed to detect DB dialect in your `drizzle.config.[js|ts]` file
│      at Object.file (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-PTlNv0EA.js:1070:35)
│      at Object.run (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:5631:6)
│      at runAddon (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-PTlNv0EA.js:1111:14)
│      at applyAddons (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/install-PTlNv0EA.js:1026:50)
│      at process.processTicksAndRejections (node:internal/process/task_queues:105:5)
│      at async runAddCommand (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:9980:79)
│      at async createProject (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:10226:45)
│      at async file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:10122:57
│      at async runCommand (file:///C:/Users/psych/AppData/Local/npm-cache/_npx/6ef4a8874203b3d8/node_modules/sv/dist/bin.js:6880:3)
│
└  Operation failed.

I'm using VSCode terminal, how can I get CLI version? :D

PS E:\BBB\DiscordBot.svelte> npm -v
11.0.0
PS E:\BBB\DiscordBot.svelte> node -v
v22.13.0
PS E:\BBB\DiscordBot.svelte> npx -v
11.0.0

Selecting drizzle firstly, it works.

[manuel3108]

@PSYCHEER This is perfect, thanks. I finally managed to reproduce this!

CLI version is displayed in the first output from the cli

Welcome to the Svelte CLI! (v0.6.23)

or by runnning

npx sv --version

[PSYCHEER]

Oh😄 I'm beginner in this world😄