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    gt  request  body             title    gt  request  title             user id    gt  auth  - gt id              with these fillables    Post Model protected  fillable     title    body    user id     However this method do the job    PostController auth  - gt user  - gt publish new Post request   title    body           Post Model public function publish Post  post         this- gt posts  - gt save  post       any idea why this fail

User · Answer

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  - gt id    Post  create request            body    gt  request  body             title    gt  request  title             user id    gt   user login id

User · Answer

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

User · Answer

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

User · Answer

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

User · Answer

table- gt date  user id  - gt nullable      In your file create file  the null option must be enabled

User · Answer

Try    user id    gt  auth  - gt id or   user id    gt  Auth  user  - gt id  instead of    user id    gt  auth  - gt id

User · Answer

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

User · Answer

User Auth  user  - gt id instead   Here is the correct way      PostController Post  create request        body    gt  request  body         title    gt  request  title         user id    gt  Auth  user  - gt id        If your user is authenticated  Then Auth  user  - gt id will do the trick

User · Answer

use print r Auth    then see in which format you have user id   id variable and use it

User · Answer

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

User · Answer

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

User · Answer

Try using Auth  id    like Post  create    body    gt  request  body     title    gt  request  title     user id    gt  Auth  id       also remember to include Auth facade at top of your controller which is App Http Controllers Auth

User · Answer

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        lt   the error is Here         body    gt  request  body         title    gt  request  title         user id    gt  auth  - gt id          actually  there is no need for the request function warping the body of the create function      this is right Post  create        body    gt  request  body         title    gt  request  title         user id    gt  auth  - gt id

User · Answer

Here s how I did it   This is my PostsController  Post  create         title    gt  request  title         body    gt  request  body         user id    gt  auth  - gt 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

User · Answer

Post  create          title    gt  request  title           body    gt  request  body           user id    gt  auth  - gt id             you dont need the request   as you doing that already pulling the value of body and title

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

Examples related to php

Examples related to laravel