Can't run drizzle db:push due to error yet the code hasn't changed

So i am trying to push my new schema to planetScale however i run into this error:

Error: target: meally.-.primary: vttablet: rpc error: code = InvalidArgument desc = Invalid default value for 'createdAt' (errno 1067) (sqlstate 42000) (CallerID: 9d6l772g9pp919ug46mn): Sql: "alter table recipes modify column isPublic boolean not null", BindVars: {REDACTED}
    at PromiseConnection.query (G:\GitHub\Meally\node_modules\.pnpm\drizzle-kit@0.19.8\node_modules\drizzle-kit\index.cjs:35317:26)
    at Command.<anonymous> (G:\GitHub\Meally\node_modules\.pnpm\drizzle-kit@0.19.8\node_modules\drizzle-kit\index.cjs:52802:33)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
  code: 'ER_INVALID_DEFAULT',
  errno: 1067,
  sql: 'ALTER TABLE `recipes` MODIFY COLUMN `isPublic` boolean NOT NULL;',
  sqlState: '42000',
  sqlMessage: `target: meally.-.primary: vttablet: rpc error: code = InvalidArgument desc = Invalid default value for 'createdAt' (errno 1067) (sqlstate 42000) (CallerID: 9d6l772g9pp919ug46mn): Sql: "alter table recipes modify column isPublic boolean not null", BindVars: {REDACTED}`
}

Error: target: meally.-.primary: vttablet: rpc error: code = InvalidArgument desc = Invalid default value for 'createdAt' (errno 1067) (sqlstate 42000) (CallerID: 9d6l772g9pp919ug46mn): Sql: "alter table recipes modify column isPublic boolean not null", BindVars: {REDACTED}
    at PromiseConnection.query (G:\GitHub\Meally\node_modules\.pnpm\drizzle-kit@0.19.8\node_modules\drizzle-kit\index.cjs:35317:26)
    at Command.<anonymous> (G:\GitHub\Meally\node_modules\.pnpm\drizzle-kit@0.19.8\node_modules\drizzle-kit\index.cjs:52802:33)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
  code: 'ER_INVALID_DEFAULT',
  errno: 1067,
  sql: 'ALTER TABLE `recipes` MODIFY COLUMN `isPublic` boolean NOT NULL;',
  sqlState: '42000',
  sqlMessage: `target: meally.-.primary: vttablet: rpc error: code = InvalidArgument desc = Invalid default value for 'createdAt' (errno 1067) (sqlstate 42000) (CallerID: 9d6l772g9pp919ug46mn): Sql: "alter table recipes modify column isPublic boolean not null", BindVars: {REDACTED}`
}

When i ran this db:push earlier this week i didn't have any issues and i din't change anything so i don't know whats up there find my schema attached

Recipe_schecma.ts

12 Replies

barry•14mo ago

why the notnull if there is default

Jacob•14mo ago

that's a great question i don't really know why i did that, even once removing that is still won't work so that's not really my issue. but thank you for picking that up

barry•14mo ago

what if you do default(0)

Jacob•14mo ago

Nah that doesn't work

barry•14mo ago

Also, now is not a date I think? so doing mode date But defaultNow get rid of mode date maybe

Jacob•14mo ago

if you have a look at ths schmea attached you can see my date fields

  createByName: varchar('lastUpdatedBy', { length: 191 }).notNull(),
  createdAt: timestamp('createdAt', { mode: 'date' }).defaultNow(),
  lastUpdated: timestamp('lastUpdated', { mode: 'date' })
    .defaultNow()
    .onUpdateNow(),
  lastUpdatedBy: varchar('lastUpdatedBy', { length: 191 }).notNull(),
  lastUpdatedByName: varchar('lastUpdatedBy', { length: 191 }).notNull(),
  createdBy: varchar('createdBy', { length: 191 }).notNull(),

  createByName: varchar('lastUpdatedBy', { length: 191 }).notNull(),
  createdAt: timestamp('createdAt', { mode: 'date' }).defaultNow(),
  lastUpdated: timestamp('lastUpdated', { mode: 'date' })
    .defaultNow()
    .onUpdateNow(),
  lastUpdatedBy: varchar('lastUpdatedBy', { length: 191 }).notNull(),
  lastUpdatedByName: varchar('lastUpdatedBy', { length: 191 }).notNull(),
  createdBy: varchar('createdBy', { length: 191 }).notNull(),

Jacob•14mo ago

Recipe_schecma.ts

barry•14mo ago

get rid of date

Jacob•14mo ago

yeh that still doesn't work

barry•14mo ago

timestamp("").defaultNow() doesnt work?

Jacob•14mo ago

Correct, ussaly it does but for some reason it still error with all of that, it's weird becuase all this code was working no that long ago beacuse i only reason for the changes is for my users schema and stuff but that isn't whjere the issue lyes which is weird

barry•14mo ago

take it to drizzles discord then, seems like a weird bug, and if they do help please say more than "doesnt work" https://discord.gg/gDVHNhbN

.default(sql`(CURRENT_TIMESTAMP(3))`)

.default(sql`(CURRENT_TIMESTAMP(3))`)

Gaming

Programming

Can't run drizzle db:push due to error yet the code hasn't changed