Frost Gear Posts - Answer Overflow

Frost Gear

•Created by Frost Gear on 7/10/2024 in #help

Push error: This statement does not return data. Use run() instead

I just updated drizzle-kit to versions 0.23.0 and when I try to execute drizzle-kit push I get the following error:

TypeError: This statement does not return data. Use run() instead
    at Object.query (.../node_modules/drizzle-kit/bin.cjs:121780:54)
    at sqlitePush (.../node_modules/drizzle-kit/bin.cjs:124445:23)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async _Command.<anonymous> (.../node_modules/drizzle-kit/bin.cjs:131629:7)

TypeError: This statement does not return data. Use run() instead
    at Object.query (.../node_modules/drizzle-kit/bin.cjs:121780:54)
    at sqlitePush (.../node_modules/drizzle-kit/bin.cjs:124445:23)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async _Command.<anonymous> (.../node_modules/drizzle-kit/bin.cjs:131629:7)

When using 0.22.0 it works without errors. Am I doing something wrong? For the db I use sqlite with better-sqlite-3. Here's the config:

import { env } from "@/env";
import { type Config } from "drizzle-kit";

export default {
  schema: "./src/db/schema.ts",
  dialect: "sqlite",
  dbCredentials: {
    url: env.server.SQLITE_FILE,
  },
  verbose: true,
  strict: true,
} satisfies Config;

import { env } from "@/env";
import { type Config } from "drizzle-kit";

export default {
  schema: "./src/db/schema.ts",
  dialect: "sqlite",
  dbCredentials: {
    url: env.server.SQLITE_FILE,
  },
  verbose: true,
  strict: true,
} satisfies Config;

8 replies

DTDrizzle Team

•Created by Frost Gear on 6/4/2024 in #help

Drizzle-kit studio won't open

1 replies

Gaming

Programming