General error: 1364 Field 'department_id' doesn't have a default value

Question

here's the error

SQLSTATE[HY000]: General error: 1364 Field 'department_id' doesn't have a default value (SQL: insert into ms_user (name, username, role, email, password, updated_at, created_at)

ms_user model

protected $fillable = [
        'department_id','name', 'email', 'password','username','role',
    ];

create function :

    {
        return ms_user::create([
            'name' => $data['name'],
            'username' => $data['username'],
            'role' => $data['role'],
            'email' => $data['email'],
            'department_id' => $data['department_id'],
            'password' => bcrypt($data['password'])
        ]);
    }

validator function :

 protected function validator(array $data)
    {
        return Validator::make($data, [
            'name' => 'required|string|max:255',
            'username' => 'required|string|max:255',
            'role' => 'required|in:user,admin',
            'department_id' => 'required|string',
            'email' => 'required|string|email|max:255|unique:ms_user',
            'password' => 'required|string|min:6|confirmed',
        ]);
    }

department_id is a dropdown menu that contains data from the ms_department table, department_id becomes the foreign key in the ms_user table and as the primary key in the ms_department

Answer 1

It seam that your are trying to create a user with the filed department_id set to null. In your controller it seams your are passing $data['department_id'] I presume that value comme from the Request Object. But as that field doesn't have any value, when you the code to create user is execute, It send and empty value to that database. The table which contain users data doesn't allow that field to be empty.

You solve that by updating you migration to allow null on the departement_field like this

$table->integer('department_id')->nullable();

Or you can check if $data['department_id'] isn't null but using debug($data) in your controller.

Answer 2

it seems you are trying to make a bulk upload if not the name attribute of the input referring to department_id is empty or not correctly spelled

I had the same issue but the error in my case originated from my controller where I interchanged the names of my field living out exp_date

Answer 3

I had the same problem. I checked the stream on which data is passed in.

1. Check if everything on view is ok.
2. Check if everything on controller is fine.
3. Check if field exists in model .
4. Check if field exists in migration.

For me, I had put a . dot on my model. Like

protected $fillable = [
   'department_id'.'name', 'email', 'password','username','role',
];

between department_id and name.

The spellings are also important. Since there is no data from the view, I can't say for sure - but check if everything is correct.