SQLSTATE [22007]：无效的日期时间格式：laravel中的1366

Question

I am new to laravel i am trying to insert data to database and i am getting this error

this is my table its have no date fields

controller and insert code

public function save_data(Request $request){

$data= $request->all();
$name=$data['name'];
$insert=array('name'=>$name);
DB::table('data')->insert($insert);
}

Answer 1

Your name column is of type int(11). It expects an integer, not a string (VARCHAR). Change your column type (preferably with a migration) from int(11) to a VARCHAR.