Closed nicolaspfernandes closed 5 years ago
:tada: This issue has been resolved in version 5.2.4 :tada:
The release is available on:
Your semantic-release bot :package::rocket:
Note if this helps anyone. I was still getting that error after upgrading from from 4.42.0
to 5.6.0
. It resolved itself after also upgrading mysql2
from 1.4.2
to 1.6.5
and a fresh node modules nuke+install.
Note if this helps anyone. I was still getting that error after upgrading from from
4.42.0
to5.6.0
. It resolved itself after also upgradingmysql2
from1.4.2
to1.6.5
and a fresh node modules nuke+install.
I'm still getting:
SequelizeDatabaseError: Incorrect integer value: 'false' for column
vocascan.
roles.
adminRightsat row 1
(trying to get vocascan running as a server) despite having done:
$ npm install sequelize@v6.6.5
$ npm install mysql2@v2.3.0
Perhaps that's because I don't have a clue as to what you meant by "fresh node modules nuke+install".
This issue still persists
This issue still persists
What is the ~Sequelize version~ Sequelize and mysql2 version you are using? can you give a reproducible example with Sequelize SSCCE?
This should be resolved in v7 with #14505
What are you doing?
What do you expect to happen?
Record being created into the database with a proper converted default value to 0 or 1, since MySQL uses
TINYINT(1)
as the column type for boolean fields.What is actually happening?
SequelizeDatabaseError: Incorrect integer value: 'false' for column 'isPublic' at row 1
SequelizeDatabaseError: Incorrect integer value: 'true' for column 'isPublic' at row 1
Dialect: mysql Dialect version: 2.6.0 Database version: 8.0.15 Sequelize version: 5.2.1 Tested with latest release: Yes