Squad Creation Debug Test
1. Checking squads table...
✅ Squads table exists
2. Checking table structure...
Columns:
- squad_id: int(11)
- squad_name: varchar(100)
- exam_date: date
- session: enum('FN','AN')
- staff_id: int(11)
- status: enum('Active','Inactive')
- created_at: timestamp
- updated_at: timestamp
3. Checking staff with Squad role...
✅ Found 4 staff with Squad role:
- Prof. Sunita Patel (STF004)
- Dr. Vikram Gupta (STF005)
- test test (test)
- Ms. Anjali Mehta (STF006)
4. Checking existing squads...
Existing squads: 0
5. Testing squad creation...
✅ Test squad created successfully! Squad ID: 10
✅ Test squad cleaned up
6. Checking hall allocations...
Total hall allocations: 25
Recent allocations:
Warning: Undefined array key "exam_date" in /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/debug_squad_creation.php on line 112
Warning: Undefined array key "session" in /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/debug_squad_creation.php on line 112
- Small Hall C ( ) - 25 students
Warning: Undefined array key "exam_date" in /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/debug_squad_creation.php on line 112
Warning: Undefined array key "session" in /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/debug_squad_creation.php on line 112
- Library Hall ( ) - 10 students
Warning: Undefined array key "exam_date" in /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/debug_squad_creation.php on line 112
Warning: Undefined array key "session" in /home2/santhos2/public_html/bharath-coe.firstmatrix.in.net/debug_squad_creation.php on line 112
- Computer Lab Hall ( ) - 25 students
Summary:
- Squads table: ❌
- Squad staff: 4
- Existing squads: 0
- Hall allocations: 25