Laravelでcreateを実行した際、SQLSTATE[HY000]: General error: 1364 Field (カラム名) doesn't have a default valueが発生した。
解決策
モデルを見直す
自分の場合、モデルで該当のカラムを$fillableの対象に記入していなかった。
app\Model.php
classModelextendsAuthenticatable{useNotifiable;/**
* The attributes that are mass assignable.
*
* @var array
*/protected$fillable=['name','email','password',//(ここにcreateを実行してもNULLになってしまっていたカラムを指定する)];
{"version":"0.2.0","configurations":[{"name":"Listen for XDebug","type":"php","request":"launch","port":9000},{"name":"Launch currently open script","type":"php","request":"launch","cwd":"${fileDirname}","runtimeExecutable":"/usr/local/bin/php","runtimeArgs":["-d","zend_extension=xdebug.so","-d","xdebug.remote_enable=1","-d","xdebug.remote_autostart=1","-d","xdebug.remote_host=localhost","-d","xdebug.remote_port=9001"],"program":"${workspaceRoot}/vendor/bin/phpunit","args":["${file}"],"port":9001,"log":false}]}
{"version":"0.2.0","configurations":[{"name":"Listen for XDebug","type":"php","request":"launch","port":9000},{"name":"Launch currently open script","type":"php","request":"launch","cwd":"${fileDirname}","runtimeExecutable":"/usr/local/bin/php","runtimeArgs":["-d","zend_extension=xdebug.so","-d","xdebug.remote_enable=1","-d","xdebug.remote_autostart=1","-d","xdebug.remote_host=localhost","-d","xdebug.remote_port=9001"],"program":"${workspaceRoot}/vendor/bin/phpunit","args":["${file}"],"port":9001,"log":false}]}
publicfunctionaction_register(){if($authentication=Session::get('auth-strategy.authentication',array())){try{$user=Session::get('auth-strategy.user');$user_id=Auth::create_user($user['email'],'dummy',$user['email'],Config::get('application.user.default_group',1),array('fullname'=>$user['name'],));if($user_id){$opauth=Auth_Opauth::forge(false);// call Opauth to link the provider login with the local user$insert_id=$opauth->link_provider(array('parent_id'=>$user_id,'provider'=>$authentication['provider'],'uid'=>$authentication['uid'],'access_token'=>$authentication['access_token'],'secret'=>$authentication['secret'],'refresh_token'=>$authentication['refresh_token'],'expires'=>$authentication['expires'],'created_at'=>time(),));Auth::instance()->force_login((int)$user_id);Session::set_flash('success',__('login.new-account-created'));Response::redirect_back('calendar');}else{\Session::set_flash('error',__('login.account-creation-failed'));}}// catch exceptions from the create_user() callcatch(SimpleUserUpdateException$e){// メールアドレスが重複if($e->getCode()==2){Session::set_flash('error',__('login.email-already-exists'));}// ユーザー名が重複elseif($e->getCode()==3){Session::set_flash('error',__('login.username-already-exists'));}// これは起こり得ないが、ずっとそうとは限らない...else{Session::set_flash('error',$e->getMessage());}}}else{Session::set_flash('error','Failed to retrieve a user information from the provider.');}Response::redirect_back('user/login');}
<?phpnamespaceApp\Models;useIlluminate\Notifications\Notifiable;//use Illuminate\Foundation\Auth\User as Authenticatable;useIlluminate\Auth\Authenticatable;useIlluminate\Auth\Passwords\CanResetPassword;useIlluminate\Foundation\Auth\Access\Authorizable;useIlluminate\Contracts\Auth\AuthenticatableasAuthenticatableContract;useIlluminate\Contracts\Auth\Access\AuthorizableasAuthorizableContract;useIlluminate\Contracts\Auth\CanResetPasswordasCanResetPasswordContract;useVinelab\NeoEloquent\Eloquent\ModelasNeoEloquent;classUserextendsNeoEloquentimplementsAuthenticatableContract,AuthorizableContract,CanResetPasswordContract{useNotifiable,Authenticatable, Authorizable, CanResetPassword;protected$label='User';/**
* The attributes that are mass assignable.
*
* @var array
*/protected$fillable=['name','email','password',];/**
* The attributes that should be hidden for arrays.
*
* @var array
*/protected$hidden=['password','remember_token',];}
use Illuminate\Auth\Authenticatable;
use Illuminate\Auth\Passwords\CanResetPassword;
use Illuminate\Foundation\Auth\Access\Authorizable;
use Illuminate\Contracts\Auth\Authenticatable as AuthenticatableContract;
use Illuminate\Contracts\Auth\Access\Authorizable as AuthorizableContract;
use Illuminate\Contracts\Auth\CanResetPassword as CanResetPasswordContract;
use Vinelab\NeoEloquent\Eloquent\Model as NeoEloquent;
class User extends NeoEloquent implements
AuthenticatableContract,
AuthorizableContract,
CanResetPasswordContract
