[Migrations] Schema builder exception, syntax error, invalid default value for created_at field

[Mounika-Akula]

Exception throws for created_at "DATETIME" field when I try to execute Migration for for category table schema.

Configuration: PHP 7 & MYSQL 5.7.9.

Reference screenshot attached

[sanjoydesk]

It is known issue on higher version of MYSQL (5.7.*). You can pass the default value for the DATETIME field "created_at" or "updated_at" to your schema while executing migration as below.

Schema::make('category', function ($table)
{
        $table->create([
               ['column'=> 'created_at', 
                'type' => 'datetime', 'length' => 'NOT NULL DEFAULT NOW()'],
                ['column'=> 'updated_at', 'type' => 'datetime', 
                 'length' => 'DEFAULT NOW()'],
                ['column'=> 'time_logged', 'type' => 'datetime', 'length' => 'null'],
         ], 'InnoDB', 'latin1');
});

We will work on it, we will add a default value as null for DATETIME field. Thanks!

[Mounika-Akula]

Thank you Sanjoy :P

On Sun, Aug 28, 2016 at 10:33 PM, Sanjoy Dey [email protected]
wrote:

It is known issue on higher version of MYSQL (5.7.*). You can pass the
default value for DATETIME field "created_at" or "updated_at" to your
schema while executing migration as below.

Schema::make('category', function ($table)
{
$table->create([
['column'=> 'created_at',
'type' => 'datetime', 'length' => 'NOT NULL DEFAULT NOW()'],
['column'=> 'updated_at', 'type' => 'datetime',
'length' => 'DEFAULT NOW()'],
['column'=> 'time_logged', 'type' => 'datetime', 'length' => 'null'],
], 'InnoDB', 'latin1');
});

However we will work on this issue asap.

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#94 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/ALgtv_M41sg-ufF-FhVGWXTz-lIhKi4_ks5qkb9kgaJpZM4Ju9b2
.