SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: students.email (Connection: sqlite, Database: /home/wcskizrk/attendance.swalehnswaleh.co.ke/attendance/database/database.sqlite, SQL: insert into "students" ("school_id", "name", "student_id", "email", "updated_at", "created_at") values (9, John Doe, STU001, john@example.com, 2026-02-08 19:01:43, 2026-02-08 19:01:43))
Illuminate\Database\Connection->runQueryCallback(string, array, object(Closure))Illuminate\Database\Connection->run(string, array, object(Closure))Illuminate\Database\Connection->statement(string, array)Illuminate\Database\Connection->insert(string, array)Illuminate\Database\Query\Processors\Processor->processInsertGetId(object(Illuminate\Database\Query\Builder), string, array, string)Illuminate\Database\Query\Builder->insertGetId(array, string)Illuminate\Database\Eloquent\Builder->__call(string, array)Illuminate\Database\Eloquent\Model->insertAndSetId(object(Illuminate\Database\Eloquent\Builder), array)Illuminate\Database\Eloquent\Model->performInsert(object(Illuminate\Database\Eloquent\Builder))Illuminate\Database\Eloquent\Model->save()Illuminate\Database\Eloquent\Builder->Illuminate\Database\Eloquent\{closure}(object(App\Models\Student))vendor/laravel/framework/src/Illuminate/Support/helpers.phpIlluminate\Database\Eloquent\Builder->create(array)Illuminate\Support\Traits\ForwardsCalls->forwardCallTo(object(Illuminate\Database\Eloquent\Builder), string, array)Illuminate\Database\Eloquent\Model->__call(string, array)Illuminate\Database\Eloquent\Model::__callStatic(string, array)create_test_data.php15]);
16
17echo "School created with ID: " . $school->id . "\n";
18
19// Create a test student
20$student = Student::create([
21 'school_id' => $school->id,
22 'name' => 'John Doe',
23 'student_id' => 'STU001',
24 'email' => 'john@example.com',
25]);
26
27echo "Student created with ID: " . $student->id . "\n";
28echo "JSON:\n";
29echo json_encode(['school_id' => $school->id, 'student_id' => $student->id], JSON_PRETTY_PRINT);
30insert into "schools" ("name", "contact_email", "contact_phone", "status", "updated_at", "created_at") values ('Test School', 'test@school.com', '555-1234', 'active', '2026-02-08 19:01:43', '2026-02-08 19:01:43')