Drizzle Team•11mo ago

SQL string does not contain any statement

I currently have 1 sqliteTable on my schema and 1 migration, so I wan't to create a new table and migration. When I run the drizzle-kit generate:sqlite command, all works well, but when I run the migrate... one error heppens: LibsqlError: SQL_NO_STATEMENT: SQL string does not contain any statement this is my migrate.ts file

import { migrate } from "drizzle-orm/libsql/migrator";
import { db } from "../lib/db";

async function main() {
  try {
    await migrate(db, { migrationsFolder: "src/drizzle/migrations" });
    console.log("Tables migrated!");
    process.exit(0);
  } catch (error) {
    console.error("Error performing migration: ", error);
    process.exit(1);
  }
}

main();

import { migrate } from "drizzle-orm/libsql/migrator";
import { db } from "../lib/db";

async function main() {
  try {
    await migrate(db, { migrationsFolder: "src/drizzle/migrations" });
    console.log("Tables migrated!");
    process.exit(0);
  } catch (error) {
    console.error("Error performing migration: ", error);
    process.exit(1);
  }
}

main();

2 Replies

Angelelz•11mo ago

Please take a look at this thread. You might be suffering from the same issue https://discord.com/channels/1043890932593987624/1171662325456060466

Emerson•11mo ago

Yes, i'm looking now, thanks!

Gaming

Programming

SQL string does not contain any statement