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.
[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.
Issue Creation Checklist
Bug Description
Reproducible Example
Start up a new sequelize project; Run
npx sequelize-cli db:migrate:schema:timestamps:addcommandSubsequent migrations will fail to run returning the following error:
From my investigation, what's happening is that
createdAtfield inSequelizeMetatable 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
Would you be willing to resolve this issue by submitting a Pull Request?
Indicate your interest in the resolution of this issue by adding the 👍 reaction. Comments such as "+1" will be removed.