cli
cli copied to clipboard
Subsequent migrations fail after running db:migrate:schema:timestamps:add command
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.