我在Laravel 5.5中构建了一个GraphQL API,我从User::create()
中得到一个错误,它说我没有为“password”列提供值,尽管我确实提供了值。这是User::create()
的完整消息:
SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column \"password\" violates not-null constraint
DETAIL: Failing row contains (507, null, null, 2017-09-23 14:12:11, 2017-09-23 14:12:11, 658495, 56854685, Joe, Appleseed, royal, 1970-01-01, +31684736248, null, Poplar St, 14a, 1012AB, London, null, joe.appleseed@overwatch.com, joe.appleseed@mindef.nl, null). (SQL: insert into \"users\" (\"wid\", \"unumber\", \"first_name\", \"last_name\", \"civil_status\", \"birthdate\", \"phone_number\", \"street\", \"street_number\", \"postal_code\", \"city\", \"email_address_overwatch\", \"email_address_mindef\", \"updated_at\", \"created_at\") values (658495, 56854685, Joe, Appleseed, royal, 1970-01-01, +31684736248, Poplar St, 14a, 1012AB, London, joe.appleseed@overwatch.com, joe.appleseed@mindef.nl, 2017-09-23 14:12:11, 2017-09-23 14:12:11) returning \"id\")
下面是生成它的代码,在我的
UserRepository
中:/**
* Creates a new User with $data
*
* @param array $data
* @return User
*/
public function create(array $data): User
{
$data['password'] = bcrypt($data['password']);
$user = User::create($data);
$this->log(Auth::user(), $user, 'created');
return $user;
}
我觉得这非常奇怪,因为我确实提供了一个密码值。我可以使用
dd($data)
:(就在$data['password'] = bcrypt($data'password');
下面)array:15 [
\"wid\" => \"658495\"
\"unumber\" => \"56854685\"
\"first_name\" => \"Joe\"
\"last_name\" => \"Appleseed\"
\"civil_status\" => \"royal\"
\"birthdate\" => \"1970-01-01\"
\"phone_number\" => \"+31684736248\"
\"street\" => \"Poplar St\"
\"street_number\" => \"14a\"
\"postal_code\" => \"1012AB\"
\"city\" => \"London\"
\"email\" => \"joe@appleseed.com\"
\"email_address_overwatch\" => \"joe.appleseed@overwatch.com\"
\"email_address_mindef\" => \"joe.appleseed@mindef.nl\"
\"password\" => \"$2y$10$FdLbx/dYkdrjhGNcuCWKkO.bg013Gn0mhs7nKN.nyNztlykWx4jDC\"
]
如您所见,这个数组中肯定有一个
password
字段。我怎么可能会犯这个错误?一些环境信息:
PHP 7.1.9-1+ubuntu16.04.1+deb.sury.org+1 (cli) (built: Sep 2 2017 05:56:43) ( NTS )
psql (PostgreSQL) 9.5.8
Laravel Framework 5.5.2
最佳答案
我猜密码不是mass assignable。在您的用户模型中:
protected $fillable = [.... other fields ..., 'password'];