Error when date value is empty

You could make the column nullable.

Laravel Migration Example.

$table->datetime('date')->nullable()->default(null);

Hi @craigpaul my collumn date is already nullable and default null :/

any other suggestion ?

thanks

Are you on OSX?

SET SESSION sql_mode='ALLOW_INVALID_DATES'

Try running this query.

What version of MySQL / Maria are you using? Also, are you inserting the date as '' or null?

When inserting as '' it will attempt to put 0000-00-00 00:00:00 and if you are on a newer version of the MySQL you might be running into strict mode errors. You could trying explicitly setting null or flipping the config in database.php

'connections' => [
    'mysql' => [
        ...
        'strict' => false, // default: true
    ],
]

Beyond that, without more information about the database version, operating system, and laravel version, I'm not exactly sure at the moment.

@craigpaul

Operating system: Windows 10 Software Version: 10.1.16-MariaDB - mariadb.org binary distribution

I'm insert the date as '' so maybe the problem is here. But when I try to force as Null I get the same error.

I changed the strict to false and it works, but the problem is that is inserting '0000-00-00' and I want to be empty or null, also changing to false it's ok ? or I would have troubles in the future ?

Thanks again ;)

Hmmm....definitely sounds like a Windows 10 thing to me. You will end up having troubles with this down the road IMO if you're coding your app to expect null instead of 0000-00-00. You might wanna try using a VM like Homestead if your machine can handle it. That way you won't run into those "it works on my machine" errors since you will essentially have a great production matched setup as your dev environment.

As for whether there is an actual fix for that, I'm not sure since I don't use Windows 10. Perhaps someone else does, but I would recommend going down the Homestead (or other VM) path.

Laravel on Windows

How to Install Homestead and Laravel on Windows 10

Both of those articles aren't super new, but should be new enough if you want to look into it.

Yup probably is something with Windows 10. I only notice now the eror is in the file Connection.php

Some of the answers here truly amaze and entertain me just make the field a null allowed and store a null.

@jlrdw I tryed that alredy but it always stores 0000-00-00

Even if I do something like this

if($input['date'] == '')
{
    $input['date'] = 'NULL';
}

You have to allow null for that field in your mySQL database, I do that all the time because I don't like all the zeros.

On tablet, later will post my code.

@jlrdw I don't like as weel

and I do have in my mysql database the field to allow Null

@kaaps I pass a date to this:

public static function fixValue($rvalue)
    {
        $rvalue = empty($rvalue) && !is_numeric($rvalue) ? NULL : trim(strip_tags($rvalue));
        return $rvalue;
    }

Works perfect I don't think date can be checked with ''

I don't know why code wrapped? Modify as needed

@jlrdw so how can I verify if it is empty instead using '' ?

I just showed you

I would highly suggest taking some of the beginner php lessons from Jeffrey, as this is just a basic sending a value to a function or could be a getter / setter, and returning a null to be stored if empty.

@jlrdw yup it works your code. but it only works if I have in mysql

'strict' => false,

Thanks ;)

Funny, 'strict' => false, shouldn't have anything to do with it, I will research it. As a date field can be null.