FAIL Tests\Feature\AuthTest ⨯ user can register 0.22s ✓ user cannot register with invalid email 0.01s ⨯ user cannot register with duplicate email 0.02s ⨯ user can login 0.01s ⨯ user cannot login with wrong credentials 0.01s ⨯ user can logout 0.01s ⨯ user can get profile 0.01s ✓ unauthenticated user cannot access protected routes 0.02s FAIL Tests\Feature\CategoryTest ⨯ can get all categories ⨯ can create category ⨯ can create category with image ⨯ cannot create category without name ⨯ can get single category ⨯ can update category ⨯ can update category image ⨯ can delete category ⨯ returns 404 for non existent category ⨯ unauthenticated user cannot access categories PASS Tests\Feature\ExampleTest ✓ the application returns a successful response 0.03s FAIL Tests\Feature\ProductTest ⨯ can get all products ⨯ can create single product ⨯ can create multiple products ⨯ can create product with images ⨯ first image is marked as primary ⨯ cannot create product without required fields ⨯ can get single product ⨯ can update product ⨯ can add images to existing product ⨯ can remove product images ⨯ can delete product ⨯ returns 404 for non existent product ⨯ unauthenticated user cannot access products ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\AuthTest > user can register Expected response status code [201] but received 500. Failed asserting that 500 is identical to 201. at tests/Feature/AuthTest.php:22 18▕ 'email' => 'test@example.com', 19▕ 'password' => 'password123', 20▕ ]); 21▕ ➜ 22▕ $response->assertStatus(201) 23▕ ->assertJsonStructure([ 24▕ 'status', 25▕ 'message', 26▕ 'data' => [ ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\AuthTest > user cannot register wit… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Meaghan Brakus, existing@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, tJn9Hw2CCj, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +18 vendor frames  19 tests/Feature/AuthTest.php:57 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\AuthTest > user can login QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Emory Towne, test@example.com, 2025-10-10 12:27:46, $2y$04$BojYRaAMUYVuZ1aoCOs2zOWPpiFXmM5fKi/HaovC64NJ1EZuG1DSK, RT5O4KyDkI, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +18 vendor frames  19 tests/Feature/AuthTest.php:72 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\AuthTest > user cannot login with w… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Mose Auer, test@example.com, 2025-10-10 12:27:46, $2y$04$q5kYpuH8b3PM3xB0Q4MeFO2RBGlDOpTzqJ9RiD.96IAHiI.Gkg.ie, uLKct5pOTP, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +18 vendor frames  19 tests/Feature/AuthTest.php:92 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\AuthTest > user can logout QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Rey Block III, ryan.keven@example.net, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, oOqwC8Xty7, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/AuthTest.php:107 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\AuthTest > user can get profile QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Test User, test@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, x7p82WMuxF, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +18 vendor frames  19 tests/Feature/AuthTest.php:122 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > can get all categori… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Dr. Bridie Feest, kyla.lubowitz@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, ajXgIB2ZSh, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > can create category QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Silas Stamm, delbert21@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, g28upkA6I7, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > can create category… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Vesta Padberg, rhartmann@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, p1U0EmESUM, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > cannot create catego… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Demond Williamson, lora.bode@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, vq5ALtsKs2, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > can get single categ… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Amari Prosacco, pearline28@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, ab5ocOXGOP, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > can update category QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Holly King PhD, moore.carli@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, Dw5PT6hTDl, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > can update category… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Kamron Boehm DVM, delilah.mcdermott@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, PHU1doyCpy, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > can delete category QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Jordane Mitchell, okon.thora@example.net, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, xbeTyyvDB7, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > returns 404 for non… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Miss Joy Deckow Sr., braeden.tillman@example.net, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, 6GQl7oKC1O, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\CategoryTest > unauthenticated user… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Dr. Adalberto Brekke, sylvia.harvey@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, njr95E9Qmv, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/CategoryTest.php:23 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can get all products QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Kaley Nienow, ciara17@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, 4HysBPYjvq, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can create single pro… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Joannie Rolfson, wuckert.celestino@example.net, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, kra0CIl52M, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can create multiple p… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Franz Will, micheal71@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, 53RFdUxEfz, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can create product wi… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Ignatius Klocko V, isabelle.fritsch@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, PfmFzZ1z07, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > first image is marked… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Jarrell Goyette, pacocha.mittie@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, LF4DGTMbbH, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > cannot create product… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Rolando Anderson, zbuckridge@example.net, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, Y5TmmWc96U, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can get single produc… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Dante Cummerata, moses05@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, CKY8lxL59y, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can update product QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Krista Streich I, carmen.ruecker@example.com, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, nIhds2hvII, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can add images to exi… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Ms. Neha Beatty, jasmin.treutel@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, HbTyfHWctW, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can remove product im… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Prof. Gunnar Cummerata IV, hauck.iliana@example.net, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, dcJFx77w7W, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > can delete product QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Miss Susan Baumbach, ggraham@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, j1iYJKZk3p, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > returns 404 for non e… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Mable Cruickshank, jacobi.eliseo@example.net, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, wwpGONUC5V, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 ──────────────────────────────────────────────────────────────────────────── FAILED Tests\Feature\ProductTest > unauthenticated user… QueryException SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: users.id_role (Connection: sqlite, SQL: insert into "users" ("fullname", "email", "email_verified_at", "password", "remember_token", "updated_at", "created_at") values (Gilbert Koelpin, ckuvalis@example.org, 2025-10-10 12:27:46, $2y$04$tCEbZpy9cmXX/Ejw24inkuGejCLebtnPyY6G3stnwdPJiS0HaDtb2, mMTtXqft6k, 2025-10-10 12:27:46, 2025-10-10 12:27:46)) 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▕ } +17 vendor frames  18 tests/Feature/ProductTest.php:26 Tests: 29 failed, 3 passed (5 assertions) Duration: 0.65s