knex migration - 'ER_INVALID_DEFAULT: Invalid default value for 'timestamp'

Question

I have a knex chema migration to create a table where one of the rows is -

exports.up = async function(knex) {
return knex.schema.createTable("newTable", table => {
table.timestamp("timestamp").notNullable();
})
}

I encountered an errorER_INVALID_DEFAULT: Invalid default value for 'timestamp'

I've tried giving a default value of null and removing notNullable(), or giving a default value of CURRENT_TIMESTAMP, but neither seems to work (maybe there's something wrong with my syntax?)

I would appreciate any help!

Answer 1

If you can access my.ini (mysql configuration file), please remove NO_ZERO_DATE from sql-mode and restart the server.

You can use SHOW VARIABLES LIKE 'sql_mode' command to check.

For the complete answer, please click on the link