php artisan db:seed

[sxdubin]

vagrant@homestead:~/work/admin$ php artisan db:seed
Seeded: UserTableSeeder
Seeded: PermissionTableSeeder

[Illuminate\Database\QueryException]
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (homestead.role_admin, CONSTRAINT role_admin_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert into role_admin (role_id, user_id) values (2, 2))

[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (homestead.role_admin, CONSTRAINT role_admin_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ON UPDATE CASCADE)

[jwwb681232]

Please delete all data tables before running

composer dump-autoload
php artisan migrate --seed

[sxdubin]

vagrant@homestead:~/work/admin$ php artisan db:seed
Seeded: UserTableSeeder
Seeded: PermissionTableSeeder

[Illuminate\Database\QueryException]
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (homestead.role_admin, CONSTRAINT role_admin_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ON UPDATE CASCADE) (SQL: insert into role_admin (role_id, user_id) values (2, 2))

[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (homestead.role_admin, CONSTRAINT role_admin_user_id_foreign FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE ON UPDATE CASCADE)

---

Error:

 (SQL: insert into role_admin (role_id, user_id) values (2, 2))

Solution:

Add into /yourproject/database/seeds/UserTableSeeder.php

        User::create([
            'name' => 'UserName2',
            'email' => '[email protected]',
            'password' => 'username2',
        ]);