I installed a jeroennoten/Laravel-AdminLTE which is, Package version 2.x (Laravel 6).After installing i modify my user table, register.blade.php and registercontroller for username and role. But when i submitting the form it always give me a error default value is not set for username. Here is my view
<div class="form-group has-feedback {{ $errors->has('role') ? 'has-error' : '' }}">
<select name="role" class="form-control">
<option>Register As</option>
<option value="candidate">Candidate</option>
<option value="voter">Voter</option>
</select>
<span class="glyphicon glyphicon-role form-control-feedback"></span>
@if ($errors->has('role'))
<span class="help-block">
<strong>{{ $errors->first('role') }}</strong>
</span>
@endif
</div>
<div class="form-group has-feedback {{ $errors->has('username') ? 'has-error' : '' }}">
<input type="text" name="username" class="form-control" value="{{ old('username') }}"
>
<span class="glyphicon glyphicon-user form-control-feedback"></span>
@if ($errors->has('username'))
<span class="help-block">
<strong>{{ $errors->first('username') }}</strong>
</span>
@endif
</div>
And my registercontroller
protected function validator(array $data)
{
return Validator::make($data, [
'name' => ['required', 'string', 'max:255'],
'username' => ['required', 'string'],
'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
'password' => ['required', 'string', 'min:6', 'confirmed'],
'role' => ['required'],
]);
}
protected function create(array $data)
{
return User::create([
'name' => $data['name'],
'username' => $data['username'],
'email' => $data['email'],
'password' => Hash::make($data['password']),
'role' => $data['role'],
]);
}
After modify when i submit i always get this error
SQLSTATE[HY000]: General error: 1364 Field 'username' doesn't have a default value (SQL: insert into
users
(name
,password
,updated_at
,created_at
) values (Tanvir, tahmedhera@gmail.com, $2y$10$5XxgDoe272G0wkrcpQYmLepTCGPTPzASBkzXxJ84EhZqOEBvy4zFS, 2019-10-25 10:54:25, 2019-10-25 10:54:25)) Please can somebody help me why i getting this error
Check your model, i think username parameter is missing.
protected $fillable = [
'name', 'email', 'password', 'username', 'role'
];