INFO Seeding database. Illuminate\Database\QueryException SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email_verified_at' in 'field list' (Connection: mysql, SQL: insert into users (name, email, email_verified_at, password, remember_token, updated_at, created_at) values (Test User, test@example.com, 2025-10-07 03:31:16, $2y$12$hRISOUZ.WM43pXfJKand9uln1WPLOtnVGxuRetZvfoCufZnNiplu2, Af8Unic18o, 2025-10-07 03:31:16, 2025-10-07 03:31:16)) at vendor\laravel\framework\src\Illuminate\Database\Connection.php:824 820▕ $this->getName(), $query, $this->prepareBindings($bindings), $e 821▕ ); 822▕ } 823▕ ➜ 824▕ throw new QueryException( 825▕ $this->getName(), $query, $this->prepareBindings($bindings), $e 826▕ ); 827▕ } 828▕ } 1 vendor\laravel\framework\src\Illuminate\Database\MySqlConnection.php:47 PDOException::("SQLSTATE[42S22]: Column not found: 1054 Unknown column 'email_verified_at' in 'field list'") 2 vendor\laravel\framework\src\Illuminate\Database\MySqlConnection.php:47 PDO::prepare() 怎么回事

laravel创建项目的时候自带:

1.Factories下文件需要删除

2.对Seeder进行注释

<?php

namespace Database\Seeders;

use App\Models\User;
// use Illuminate\Database\Console\Seeds\WithoutModelEvents;
use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    /**
     * Seed the application's database.
     */
    public function run(): void
    {
        // User::factory(10)->create();

        // User::factory()->create([
        //     'name' => 'Test User',
        //     'email' => 'test@example.com',
        // ]);
    }
}

之后对特定填充器进行执

php artisan db:seed --class=Modules\Auth\Seeders\PermissionSeeder -v

Logo

Agent 垂直技术社区,欢迎活跃、内容共建。

更多推荐