laravel需要名稱在可填充陣列中，而它在其中

我的問題是當我注冊一個新用戶時，在我提交發布請求后它會拋出一個例外，Add [name] to fillable property to allow mass assignment on [Illuminate\Foundation\Auth\User]并且它已經存在于可填充中。

namespace App\Http\Controllers\Auth;

/*imports here*/

class SignupController extends Controller
{
    public function store(Request $request)
    {
        $this->validate($request, [
            'name' => 'required',
            'surname' => 'required',
            'username' => 'required|min:3|max:20',
            'phone' => 'required',
            'email' => 'required',
            'password' => 'required|confirmed',
        ]);

        User::create([
            'name'=> $request->name,
            'surname'=> $request->surname,
            'username'=> $request->username,
            'phone'=> $request->phone,
            'email'=> $request->email,
            'password'=> Hash::make($request->password),
        ]);
    }
}

當我執行時php artisan migrate，它會拋出

Migrating: 2022_01_14_124437_add_username_to_users_table

   Error

  Call to undefined method Illuminate\Database\Schema\MySqlBuilder::dropColumnIfExists()

  at C:\Users\xxgam\OneDrive\Desktop\projects\deneme\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php:261
    257▕         if (! $instance) {
    258▕             throw new RuntimeException('A facade root has not been set.');
    259▕         }
    260▕
  ? 261▕         return $instance->$method(...$args);
    262▕     }
    263▕ }
    264▕

  1   C:\Users\xxgam\OneDrive\Desktop\projects\deneme\database\migrations\2022_01_14_124437_add_username_to_users_table.php:16
      Illuminate\Support\Facades\Facade::__callStatic("dropColumnIfExists")

  2   C:\Users\xxgam\OneDrive\Desktop\projects\deneme\vendor\laravel\framework\src\Illuminate\Database\Migrations\Migrator.php:394
      AddUsernameToUsersTable::up()

C:\Users\xxgam\OneDrive\Desktop\projects\deneme>php artisan migrate:rollback
Rolling back: 2019_12_14_000001_create_personal_access_tokens_table
Rolled back:  2019_12_14_000001_create_personal_access_tokens_table (6.35ms)

C:\Users\xxgam\OneDrive\Desktop\projects\deneme>php artisan migrate
Migrating: 2019_12_14_000001_create_personal_access_tokens_table
Migrated:  2019_12_14_000001_create_personal_access_tokens_table (264.26ms)
Migrating: 2022_01_14_124437_add_username_to_users_table
Migrated:  2022_01_14_124437_add_username_to_users_table (115.22ms)

用戶類

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;

    protected $fillable = [
        'name',
        'surname',
        'username',
        'phone',
        'email',
        'password',
    ];

    protected $hidden = [
        'password',
        'remember_token',
    ];

    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
}

我只知道 laravel 的基礎知識，所以如果我錯過了在這里寫的東西，請告訴我，我會寫的。

uj5u.com熱心網友回復：

看來您參考了錯誤的模型。您的User模型是App\Models\User，但您正在參考Illuminate\Foundation\Auth\User. 調整別名以在控制器中使用正確的用戶模型：

use App\Models\User;

uj5u.com熱心網友回復：

我猜您不小心從遷移檔案中洗掉了一些代碼。

您可以將此代碼與您擁有的代碼進行比較。

檢查用途和

擴展遷移

<?php

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

class CreateFailedJobsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('<your_table_name>', function (Blueprint $table) {
            \\your columns
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('failed_jobs');
    }
}

標籤：

上一篇：對EloquentORMlaravel的Sql請求

下一篇：Laravel8upsert無法按預期作業