cli icon indicating copy to clipboard operation
cli copied to clipboard

Subsequent migrations fail after running db:migrate:schema:timestamps:add command

Open wachukxs opened this issue 1 year ago • 0 comments

Issue Creation Checklist

  • [x] I understand that my issue will be automatically closed if I don't fill in the requested information
  • [x] I have read the contribution guidelines

Bug Description

Reproducible Example

Start up a new sequelize project; Run npx sequelize-cli db:migrate:schema:timestamps:add command

Subsequent migrations will fail to run returning the following error:

ERROR: Field 'createdAt' doesn't have a default value

From my investigation, what's happening is that createdAt field in SequelizeMeta table doesn't have a default value - and that's where that error is thrown from.

What do you expect to happen?

For the migration to run successfully.

What is actually happening?

Environment

  • Sequelize version: ^6.37.0
  • Node.js version: v18.19.0
  • If TypeScript related: TypeScript version: N\A
  • Database & Version: MySQL v5.7.39
  • Connector library & Version:

Would you be willing to resolve this issue by submitting a Pull Request?

  • [ ] Yes, I have the time and I know how to start.
  • [ ] Yes, I have the time but I will need guidance.
  • [ ] No, I don't have the time, but my company or I are supporting Sequelize through donations on OpenCollective.
  • [x] No, I don't have the time, and I understand that I will need to wait until someone from the community or maintainers is interested in resolving my issue.

Indicate your interest in the resolution of this issue by adding the 👍 reaction. Comments such as "+1" will be removed.

wachukxs avatar Mar 07 '24 00:03 wachukxs