Problem in migration MySQL

[ahmed2104]

https://cdn.discordapp.com/attachments/709554391807557876/735984569311952946/unknown.png
this is my problem's link , i get error in migration

[ammezie]

Post the error here!

[ahmed2104]

Post the error here!

i sent link of image , which error is there

[ahmed2104]

D:\Projects\Adonis V5 Projects Training\new_company>node ace migration:run

Migrations source base dir: build
Last compiled at: Jul 24, 2020, 12:10 AM

❯ migrating database\migrations\1587988332388_users
❯ error database\migrations\1587988332388_users
❯ migrating database\migrations\1592489784670_api_tokens
× fatal Error: ER_INVALID_DEFAULT: Invalid default value for 'updated_at'
at Query.Sequence._packetToError (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\protocol\sequences\Sequence.js:47:14)
at Query.ErrorPacket (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\protocol\sequences\Query.js:79:18)
at Protocol._parsePacket (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\protocol\Protocol.js:291:23)
at Parser._parsePacket (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\protocol\Parser.js:433:10)
at Parser.write (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\protocol\Parser.js:43:10)
at Protocol.write (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\protocol\Protocol.js:38:16)
at Socket. (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\Connection.js:88:28)
at Socket. (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\Connection.js:526:10)
at Socket.emit (events.js:315:20)
at addChunk (_stream_readable.js:295:12)
at readableAddChunk (_stream_readable.js:271:9)
at Socket.Readable.push (_stream_readable.js:212:10)
at TCP.onStreamRead (internal/stream_base_commons.js:186:23)
--------------------
at Protocol._enqueue (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\protocol\Protocol.js:144:48)
at Connection.query (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\mysql\lib\Connection.js:198:25)
at D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\dialects\mysql\index.js:135:18
at new Promise ()
at Client_MySQL._query (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\dialects\mysql\index.js:129:12)
at Client_MySQL.query (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\client.js:169:17)
at D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\transaction.js:321:24
at new Promise ()
at Client_MySQL.trxClient.query (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\transaction.js:316:12)
at Runner.query (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\runner.js:134:36)
at Runner.queryArray (D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\runner.js:226:19)
at D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\runner.js:38:25
at D:\Projects\Adonis V5 Projects Training\new_company\node_modules\knex\lib\runner.js:260:24
at processTicksAndRejections (internal/process/task_queues.js:97:5)
at UsersSchema.executeQueries (D:\Projects\Adonis V5 Projects Training\new_company\node_modules@adonisjs\lucid\build\src\Schema\index.js:85:21)
at UsersSchema.execUp (D:\Projects\Adonis V5 Projects Training\new_company\node_modules@adonisjs\lucid\build\src\Schema\index.js:130:9)

[ammezie]

Let's see the content of the migration file as well

[thetutlage]

@ahmed2104 I am not sure how can you expect others to help you, when you are damn lazy in getting help

• Sharing screenshots is not the right way
• Make sure to format your code dumps. So that it doesn't give headache to others

The better you describe your issues (with complete info), more are the chances of getting help

[Obapelumi]

I ran into a similar issue. Mine happened when trying to run migrations against a MySQL 5.7 database in production. Not sure why this is happening but changing:

table.timestamps(true);

to

table.timestamps();

seemed to fix it for me. The error also came up for the auto-generated api_tokens migration as well. Changing:

      /**
       * "useTz: true" utilizes timezone option in PostgreSQL and MSSQL
       */
      table.timestamp("expires_at", { useTz: true }).nullable();
      table.timestamp("created_at", { useTz: true }).notNullable();

to:

      /**
       * "useTz: true" utilizes timezone option in PostgreSQL and MSSQL
       */
      table.timestamp("expires_at").nullable();
      table.timestamp("created_at").notNullable();

fixed the issue. Again this only happened in a MySQL 5.7 production environment. I think the issue has to do with time zone support on the MySQL version running. Hope this helps.

[diogon01]

In Mysql: Ver 14.14 Distrib 5.7.31, for Linux (x86_64) using EditLine wrapper
This modification not working:

      table.timestamp("expires_at").nullable();
      table.timestamp("created_at").notNullable();

[crbast]

@diogon01 did you try :

table.timestamp('expires_at', { useTz: true }).nullable()
table
   .timestamp('created_at', { useTz: true }).notNullable().defaultTo(this.now())

timestamp documentation : https://knexjs.org/#Schema-timestamp

[RomainLanz]

Use table.timestamps(true, true) instead of table.timestamps(true) in your migration.