Drizzle Team•9mo ago

Error in studio when running migrate, but no error when running push

Everytime I manually run my migrator which is: pnpm tsx migrate.ts, when I open my studio I always get an error like: SQLITE_ERROR: no such column: phone or any changes that I applied with it. However, when running push to apply the same changes, I don't get the same error on studio. Is this something we should be concerned about? or this normal? This is how my migrate.ts looks like:

import { migrate } from "drizzle-orm/libsql/migrator";
import { client, db } from "./app/db";
// This will run migrations on the database, skipping the ones already applied
await migrate(db, { migrationsFolder: "./drizzle/migrations" });
// Don't forget to close the connection, otherwise the script will hang
await client.close();

import { migrate } from "drizzle-orm/libsql/migrator";
import { client, db } from "./app/db";
// This will run migrations on the database, skipping the ones already applied
await migrate(db, { migrationsFolder: "./drizzle/migrations" });
// Don't forget to close the connection, otherwise the script will hang
await client.close();

0 Replies

No replies yetBe the first to reply to this messageJoin

Gaming

Programming

Error in studio when running migrate, but no error when running push