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

Question

I am trying to assign the user_id with the current user but it give me this error

SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a 
default value (SQL: insert into `posts` (`updated_at`, `created_at`) 
values (2017-04-27 10:29:59, 2017-04-27 10:29:59))

here is my method

//PostController
Post::create(request([
        'body' => request('body'),
        'title' => request('title'),
        'user_id' => auth()->id()
    ]));

with these fillables

//Post Model
protected $fillable = ['title', 'body', 'user_id']

However this method do the job

//PostController
auth()->user()->publish(new Post(request(['title' ,'body']))); 

//Post Model
public function publish(Post $post)
{
    $this->posts()->save($post);
}

any idea why this fail?

It's clear enough: Field 'user_id' doesn't have a default value. In your post table set nullable for user_id. Or in migration $table->int('user_id')->nullable(); or as Saman says dump the value of auth()->id. And by the way i think it's auth()->id without brackets — Calin Blaga, Apr 27 '17 at 07:44
it seems `user_id` can not retrieval . add some number instead `auth()->id()` and try — Saman, Apr 27 '17 at 07:44
Are you getting some value of user_id, have you dd/echo user_id? — Muhammad Rizwan, Apr 27 '17 at 07:55
@MuhammadRizwan no still the same error `SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value (SQL: insert into `posts` (`updated_at`, `created_at`) values (2017-04-27 10:29:59, 2017-04-27 10:29:59))` — Mohammed Sabbah, Apr 27 '17 at 07:58
on your database table 'user_id' column is of which type? I t must be integer. — Muhammad Rizwan, Apr 27 '17 at 08:01
@Muhammed Sabbah: ok , check this column default value? Insert some row into this table and see what's value is going to this column by default. — Muhammad Rizwan, Apr 27 '17 at 08:10
@MuhammadRizwan it did not have default value. Do it need to have default value? — Mohammed Sabbah, Apr 27 '17 at 08:15
@Muhammed Sabbah: ok.put 0 as a default value into this column and run your code and see what happens. — Muhammad Rizwan, Apr 27 '17 at 08:18
@MuhammadRizwan it now give me this `SQLSTATE[HY000]: General error: 1364 Field 'body' doesn't have a default value (SQL: insert into `posts` (`updated_at`, `created_at`) values (2017-04-27 11:22:48, 2017-04-27 11:22:48))` why? also it give the same for title, why?! — Mohammed Sabbah, Apr 27 '17 at 08:24
Take screenshot of your table structure and show it along with your question — Muhammad Rizwan, Apr 27 '17 at 08:25
@Mohammed Sabbah:Have you check Comrade answer below..and try it — Muhammad Rizwan, Apr 27 '17 at 08:35

Shailesh Ladumor · Answer 1 · 2019-11-19T04:50:07.373

49

you need to change database strict mode. for disable follow below step

Open config/database.php
find 'strict' change the value true to false and try again

edited Nov 19 '19 at 04:50

answered Apr 27 '17 at 07:55

Shailesh Ladumor

7,052
5
42
55

I tried it, it did not give me the error, but it store an empty column on the database! – Mohammed Sabbah Apr 27 '17 at 08:07
sorry I ment row. – Mohammed Sabbah Apr 27 '17 at 08:13

score 33 · Accepted Answer · edited Jul 26 '19 at 12:24

33

So, after After reviewing the code again, I found the error. I am wondering how no one notice that! In the above code I wrote

Post::create(request([  // <= the error is Here!!!
    'body' => request('body'),
    'title' => request('title'),
    'user_id' => auth()->id()
]));

actually, there is no need for the request function warping the body of the create function.

// this is right
Post::create([
    'body' => request('body'),
    'title' => request('title'),
    'user_id' => auth()->id()
]);

edited Jul 26 '19 at 12:24

Martijn

15,791
4
36
68

answered Apr 30 '17 at 11:53

Mohammed Sabbah

873
1
8
14

1

auth()->id() or auth()->id? – Calin Blaga Jul 09 '18 at 06:40
3

Also ensure that you have the fields as mass assignable – James Ikubi Jul 23 '20 at 11:29

Lamin Barrow · Answer 3 · 2020-10-06T08:42:28.193

32

I've had a similar issue with User registration today and I was getting a

SQLSTATE[HY000]: General error: 1364 Field 'password' doesn't have a default value (SQL: insert into users

I fixed it by adding password to my protected $fillable array and it worked

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

I hope this helps.

edited Oct 06 '20 at 08:42

answered Mar 18 '18 at 12:34

Lamin Barrow

839
10
16

Even if it seems to be present in the fillable array, recheck it as there might be a typo lurking there :( learnt the hard way. – burf Jun 11 '22 at 14:39
I always forget to add to fillable, easy step to miss. Thanks for the reminder – justdoingmyjob Apr 13 '23 at 17:55

score 14 · Answer 4 · edited Feb 16 '18 at 03:25

14

Here's how I did it:

This is my PostsController

Post::create([

    'title' => request('title'),
    'body' => request('body'),
    'user_id' => auth()->id() 
]);

And this is my Post Model.

protected $fillable = ['title', 'body','user_id'];

And try refreshing the migration if its just on test instance

$ php artisan migrate:refresh

Note: migrate: refresh will delete all the previous posts, users

edited Feb 16 '18 at 03:25

Stephen Rauch

47,830
31
106
135

answered Feb 16 '18 at 03:00

Mayur Budukale

239
3
5

2

Adding the `user_id` to fillable will solve the problem if you don't have a syntax error in the controller, but why are you refreshing the migration? – Salam Jul 07 '18 at 10:46

score 3 · Answer 5 · edited Jun 20 '20 at 09:12

3

Try using `Auth::id()`, like

Post::create([ 'body' => request('body'), 'title' => request('title'), 'user_id' => Auth::id()]);

also remember to include Auth facade at top of your controller which is App\Http\Controllers\Auth

edited Jun 20 '20 at 09:12

Community

1
1

answered Apr 27 '17 at 07:46

Sapnesh Naik

11,011
7
63
98

I do not use Auth facade, however when I `dd(auth()->id())` it works! – Mohammed Sabbah Apr 27 '17 at 07:54

score 3 · Answer 6 · answered Apr 27 '17 at 07:48

3

Try

'user_id' => auth()->id
or

'user_id' => Auth::user()->id

instead of

'user_id' => auth()->id()

answered Apr 27 '17 at 07:48

Calin Blaga

1,375
12
19

it fail `Undefined property: Illuminate\Auth\AuthManager::$id` – Mohammed Sabbah Apr 27 '17 at 07:52
what is the value of Auth::user()->id ? – Calin Blaga Apr 27 '17 at 08:01
the value is the login user id – Mohammed Sabbah Apr 27 '17 at 08:04

score 3 · Answer 7 · answered Jan 10 '18 at 09:26

There are two solutions for this issue.

First, is to create fields with default values set in datatable. It could be empty string, which is fine for MySQL server running in strict mode.

Second, if you started to get this error just recently, after MySQL/MariaDB upgrade, like I did, and in case you already have large project with a lot to fix, all you need to do is to edit MySQL/MariaDB configuration file (for example /etc/my.cnf) and disable strict mode for tables:

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION

This error started to happen quite recently, due to new strict mode enabled by default. Removing STRICT_TRANS_TABLES from sql_mode configuration key, makes it work as before.

score 2 · Answer 8 · answered Apr 27 '17 at 08:20

2

User Auth::user()->id instead.

Here is the correct way :

//PostController
Post::create(request([
    'body' => request('body'),
    'title' => request('title'),
    'user_id' => Auth::user()->id
]));

If your user is authenticated, Then Auth::user()->id will do the trick.

answered Apr 27 '17 at 08:20

Gammer

5,453
20
78
121

And use Auth in controller – Muhammad Rizwan Apr 27 '17 at 08:29
You can use `Auth::user()->id` in views too. – Gammer Apr 27 '17 at 08:32
@MuhammadRizwan I do not use Auth facade from the begining. I am following the [laracast](https://laracasts.com/series/laravel-from-scratch-2017/episodes/19) tutorial, and the instructor also did not use it. – Mohammed Sabbah Apr 27 '17 at 08:33
The instructor is jeffery way, He is great. – Gammer Apr 27 '17 at 08:36
Sure, he is one of the best. I do what he did, but I do not know why this fail! I am wondering why the second method did the job well? – Mohammed Sabbah Apr 27 '17 at 08:39
@MohammedSabbah Please accept one of the answer, If that solves the problem, Good day. – Gammer Apr 27 '17 at 08:41

score 1 · Answer 9 · answered Jan 20 '18 at 00:13

1

In my case, the error was because I had not declared the field in my $fillable array in the model. Well, it seems to be something basic, but for us who started with laravel it could work.

answered Jan 20 '18 at 00:13

Alejandro Díaz

430
4
10

score 0 · Answer 10 · edited Apr 22 '18 at 03:04

0

use print_r(Auth);

then see in which format you have user_id / id variable and use it

edited Apr 22 '18 at 03:04

Muhammad Hassaan

7,296
6
30
50

answered Apr 27 '17 at 07:54

Shawinder Jit Singh

135
1
9

Dumping the whole auth will consume all the memory, if you want to dump the `user_id` do `print_r(auth()->id())` – Salam Jul 07 '18 at 10:42

Muhammad Rizwan · Answer 11 · 2017-04-27T09:00:03.173

0

It's seems flaw's in your database structure. Keep default value None to your title and body column.

Try this:

$user_login_id = auth()->id();
Post::create(request([
        'body' => request('body'),
        'title' => request('title'),
        'user_id' => $user_login_id
    ]));

edited Apr 27 '17 at 09:00

answered Apr 27 '17 at 08:38

Muhammad Rizwan

488
1
7
23

I tried it, it give me this error `SQLSTATE[HY000]: General error: 1364 Field 'body' doesn't have a default value`. This is why I tried to put a default value for it. – Mohammed Sabbah Apr 27 '17 at 08:41
Have you manually create this table ? or run migration files? – Muhammad Rizwan Apr 27 '17 at 08:44
I ran migration files. – Mohammed Sabbah Apr 27 '17 at 08:45
it is utf8mb4_unicode_ci, when I change to your suggestion it give me syntax error `SQLSTATE[42000]: Syntax error or access violation: 1253 COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'utf8mb4'` – Mohammed Sabbah Apr 27 '17 at 08:50
You also need to change it into your config/database.php file – Muhammad Rizwan Apr 27 '17 at 08:53
it did not work. sorry but I think the problem is not in my database since the second choice work `auth()->user()->publish(new Post(request(['title' ,'body'])));` – Mohammed Sabbah Apr 27 '17 at 09:03

score 0 · Answer 12 · edited Jan 10 '20 at 06:31

0

 Post::create([
      'title' => request('title'),
      'body' => request('body'),
      'user_id' => auth()->id()
    ]);

you dont need the request() as you doing that already pulling the value of body and title

edited Jan 10 '20 at 06:31

Abhishek Pakhare

476
1
4
15

answered Aug 02 '18 at 13:37

Ogunyomi Femi Joseph

1

score 0 · Answer 13 · answered Aug 12 '19 at 08:47

0

The above error can be as a result of wrongly named input variables from the view form, which resorts to seeking a default value since no variable is supplied hence-- SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value (SQL: insert into posts (updated_at, created_at) values (2017-04-27 10:29:59, 2017-04-27 10:29:59))

answered Aug 12 '19 at 08:47

Udechukwu

1

This makes sense and is worth checking. – burf Jun 11 '22 at 11:07

score 0 · Answer 14 · edited Oct 08 '19 at 18:23

0

$table->date('user_id')->nullable();

In your file create_file, the null option must be enabled.

edited Oct 08 '19 at 18:23

Das_Geek

2,775
7
20
26

answered Oct 08 '19 at 15:27

Victor Manuel Hernandez

1
1

updating my column to nullable was the only thing that worked in my case. You can do this by creating a new migration and updating the problematic column using a code very similar to the one above. Just add ->change() to the end. E.g `$table->date('user_id')->nullable()->change();` – Eaweb Jul 10 '21 at 01:51

score -1 · Answer 15 · edited Apr 27 '19 at 14:31

-1

Use database column nullble() in Laravel. You can choose the default value or nullable value in database.

edited Apr 27 '19 at 14:31

JJJ

32,902
20
89
102

answered Apr 27 '19 at 14:02

Dilshan Dilip

707
6
9

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

15 Answers15

Try using `Auth::id()`, like

Linked

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

15 Answers15

Try using Auth::id(), like

Linked

Try using `Auth::id()`, like