Laravel can't update data when using SQL Server database on Ubuntu

Try to use Carbon.

or update the column structure to to accept date time

I've used Carbon. The problem just when update, on insert everything goes well. And the column on SQL Server using datetime type.

Are you using carbon's createFromFormat ?

the error point that function at Illuminate/Database/Eloquent/Concerns/HasAttributes.php

It's look like carbon createFromFormat error, If your date string is "shorter" than the format that time this kind of error arise. Not related to DB

yeah, but the strangest things that it errors just for update feature, when insert everything goes well. (on Ubuntu)

When i use Mac OS or Windows, everything works fine..

@sonicitiskg

Can you write and run a copy of the update query manually on your Ubuntu and see what you get? That should give you some answers.

Can you paste your query here?

@mdeecooman : I have run my update query using sqlcmd command on my ubuntu, everything worked fine.

@jestins : I update data using Eloquent. $user = User::find(1); $user->user_firstname = 'Sitty'; $user->save();

that's my code.

Hi guys, it solved.

I just add one line at all my models.

protected $dateFormat = 'Y-m-d H:i:s';

Before I add that code, I write protected $dateFormat = 'Y-m-d H:i:s.v' on my models.

Thanks for sharing everyone..