#Laravel Breeze. Error after adding first name, last name and username (already in code) to user regi

7 messages · Page 1 of 1 (latest)

tidal geyser
#

Illuminate \ Database \ QueryException
SQLSTATE[HY000]: General error: 1364 Field 'hide_name' doesn't have a default value

RegisteredUserController.php

    public function store(Request $request): RedirectResponse
    {
        $request->validate([
            'name' => ['required', 'string', 'max:255'],
            'hide_name' => ['required', 'string', 'max:255'],
            'hide_lastname' => ['required', 'string', 'max:255'],
            'email' => ['required', 'string', 'email', 'max:255', 'unique:'.User::class],
            'password' => ['required', 'confirmed', Rules\Password::defaults()],
        ]);

        $user = User::create([
            'name' => $request->name,
            'hide_name' => $request->hide_name,
            'hide_lastname' => $request->hide_lastname,
            'email' => $request->email,
            'password' => Hash::make($request->password),
        ]);

        event(new Registered($user));

        Auth::login($user);

        return redirect(RouteServiceProvider::HOME);
    }
#

register.blade.php

        <!-- Hide Name -->
        <div class="mt-4">
            <x-input-label for="hide_name" :value="__('Imię')" />
            <x-text-input id="hide_name" class="block mt-1 w-full" type="text" name="hide_name" :value="old('hide_name')" required autofocus autocomplete="hide_name" />
        </div>
        
        <!-- Hide Last Name -->
        <div class="mt-4">
            <x-input-label for="hide_lastname" :value="__('Nazwisko')" />
            <x-text-input id="hide_lastname" class="block mt-1 w-full" type="text" name="hide_lastname" :value="old('hide_lastname')" required autofocus autocomplete="hide_lastname" />
        </div>
tidal geyser
#

2014_10_12_000000_create_users_table.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('users', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('hide_name');
            $table->string('hide_lastname');
            $table->string('email')->unique();
            $table->timestamp('email_verified_at')->nullable();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('users');
    }
};
peak trail
#

Is hide_name in $fillable in your User model?

tidal geyser
# peak trail Is `hide_name` in `$fillable` in your User model?
<?php

namespace App\Models;

// use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Sanctum\HasApiTokens;

class User extends Authenticatable
{
    use HasApiTokens, HasFactory, Notifiable;

    /**
     * The attributes that are mass assignable.
     *
     * @var array<int, string>
     */
    protected $fillable = [
        'name',
        'hide_name',
        'hide_lastname',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for serialization.
     *
     * @var array<int, string>
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast.
     *
     * @var array<string, string>
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
        'password' => 'hashed',
    ];
}
tidal geyser
#
tidal geyser
#

I fixed not saved the file here. I saved the file on my computer and not on the server