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, [email protected], 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进行注释
1<?php 2 3namespace Database\Seeders; 4 5use App\Models\User; 6// use Illuminate\Database\Console\Seeds\WithoutModelEvents; 7use Illuminate\Database\Seeder; 8 9class DatabaseSeeder extends Seeder 10{ 11 /** 12 * Seed the application's database. 13 */ 14 public function run(): void 15 { 16 // User::factory(10)->create(); 17 18 // User::factory()->create([ 19 // 'name' => 'Test User', 20 // 'email' => '[email protected]', 21 // ]); 22 } 23} 24
之后对特定填充器进行执
php artisan db:seed --class=Modules\Auth\Seeders\PermissionSeeder -v
《php artisan db:seed执行的时候遇到报错》 是转载文章,点击查看原文。
