Cannot push to PlanetScale develop branch

[EddyVinck]

I'm using Drizzle ORM and I was able to push my initial schema, but after trying to push a new version I am getting this error and I haven't been able to figure it out.

Should I not be able to just push a new schema to a develop branch? I suppose I don't need a "deploy request" for updating my develop branch schema, right?

Here are my db:push logs

@acme/db:db:push: > @acme/[email protected] db:push /Users/eddy/dev/blog-recorder/blog-recorder-monorepo/packages/db
@acme/db:db:push: > pnpm with-env drizzle-kit push:mysql --config ./drizzle.config.ts
@acme/db:db:push:
@acme/db:db:push:
@acme/db:db:push: > @acme/[email protected] with-env /Users/eddy/dev/blog-recorder/blog-recorder-monorepo/packages/db
@acme/db:db:push: > dotenv -e ../../.env -- "drizzle-kit" "push:mysql" "--config" "./drizzle.config.ts"
@acme/db:db:push:
@acme/db:db:push: drizzle-kit: v0.19.3
@acme/db:db:push: drizzle-orm: v0.27.0
@acme/db:db:push:
@acme/db:db:push: Reading config file '/Users/eddy/dev/blog-recorder/blog-recorder-monorepo/packages/db/drizzle.config.ts'
@acme/db:db:push: Reading schema files:
@acme/db:db:push: /Users/eddy/dev/blog-recorder/blog-recorder-monorepo/packages/db/drizzle/schema.ts
@acme/db:db:push:
@acme/db:db:push: Error: target: blogrecorder.-.primary: vttablet: rpc error: code = InvalidArgument desc = Invalid default value for 'created_at' (errno 1067) (sqlstate 42000) (CallerID: rs48s9c5u37ve750bs20): Sql: "alter table transcriptions add column file_url varchar(256) not null", BindVars: {REDACTED}
@acme/db:db:push:     at PromiseConnection.query (/Users/eddy/dev/blog-recorder/blog-recorder-monorepo/node_modules/drizzle-kit/index.cjs:34740:26)
@acme/db:db:push:     at Command.<anonymous> (/Users/eddy/dev/blog-recorder/blog-recorder-monorepo/node_modules/drizzle-kit/index.cjs:52122:33)
@acme/db:db:push:     at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
@acme/db:db:push:   code: 'ER_INVALID_DEFAULT',
@acme/db:db:push:   errno: 1067,
@acme/db:db:push:   sql: 'ALTER TABLE `transcriptions` ADD `file_url` varchar(256) NOT NULL;',
@acme/db:db:push:   sqlState: '42000',
@acme/db:db:push:   sqlMessage: `target: blogrecorder.-.primary: vttablet: rpc error: code = InvalidArgument desc = Invalid default value for 'created_at' (errno 1067) (sqlstate 42000) (CallerID: rs48s9c5u37ve750bs20): Sql: "alter table transcriptions add column file_url varchar(256) not null", BindVars: {REDACTED}`
@acme/db:db:push: }

[nerdylive123]

Invalid default value for 'created_at' (errno 1067) (sqlstate 42000)
the error is definitely there, try to read through your logs next time

[nerdylive123]

Maybe check if you did fill that column?
or if the value is really valid for that column..