✓ Database connected successfully!
| Table Name | Status | Row Count |
|---|---|---|
| departments | ✓ Exists | 9 |
| staff | ✓ Exists | 1 |
| staff_emergency_contacts | ✓ Exists | 0 |
| staff_certifications | ✓ Exists | 0 |
| staff_availability | ✓ Exists | 0 |
| staff_shifts | ✓ Exists | 0 |
| staff_documents | ✓ Exists | 1 |
| department_staff | ✓ Exists | 0 |
| department_resources | ✓ Exists | 0 |
| tasks | ✓ Exists | 8 |
| task_dependencies | ✓ Exists | 0 |
| task_comments | ✓ Exists | 0 |
| task_attachments | ✓ Exists | 0 |
| View Name | Status |
|---|---|
| department_summary | ✓ Exists |
| staff_summary | ✓ Exists |
| task_summary | ✓ Exists |
| Query | Status | Details |
|---|---|---|
| departments | ✓ Success | Returned 14 columns |
| staff | ✓ Success | Returned 29 columns |
| tasks | ✓ Success | Returned 20 columns |
| ID | Name | Code | Budget | Status |
|---|---|---|---|---|
| 1 | Operations | OPS | $50,000.00 | active |
| 2 | Production | PROD | $75,000.00 | active |
| 3 | Security | SEC | $40,000.00 | active |
| 4 | Medical | MED | $30,000.00 | active |
| 5 | Hospitality | HOSP | $35,000.00 | active |
Total staff members: 1
Total tasks: 8
| Table | Column | References |
|---|---|---|
| departments | department_head_id | staff.id |
| department_resources | department_id | departments.id |
| department_staff | staff_id | staff.id |
| department_staff | staff_id | staff.id |
| department_staff | department_id | departments.id |
| department_staff | department_id | departments.id |
| staff | department_id | departments.id |
| staff_availability | staff_id | staff.id |
| staff_certifications | staff_id | staff.id |
| staff_documents | staff_id | staff.id |
| staff_emergency_contacts | staff_id | staff.id |
| staff_shifts | department_id | departments.id |
| staff_shifts | staff_id | staff.id |
| tasks | department_id | departments.id |
| tasks | parent_task_id | tasks.id |
| tasks | assigned_to | staff.id |
| task_attachments | task_id | tasks.id |
| task_comments | task_id | tasks.id |
| task_dependencies | depends_on_task_id | tasks.id |
| task_dependencies | task_id | tasks.id |
| Setting | Value |
|---|---|
| PHP Version | 8.2.28 |
| PDO Drivers | mysql, sqlite |
| Display Errors | |
| Error Reporting | 22527 |
Error log: /home/u420726827/.logs/error_log_soundhavenfestival_com
[23-Dec-2025 19:10:35 UTC] W9 Upload DB Error: Database operation failed. Please try again later. [23-Dec-2025 19:10:35 UTC] W9 Upload Error: Database insert failed: Database operation failed. Please try again later. [23-Dec-2025 19:10:55 UTC] Database Query Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contract_id' in 'INSERT INTO' [23-Dec-2025 19:10:55 UTC] W9 Upload DB Error: Database operation failed. Please try again later. [23-Dec-2025 19:10:55 UTC] W9 Upload Error: Database insert failed: Database operation failed. Please try again later. [23-Dec-2025 19:11:08 UTC] Database Query Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contract_id' in 'INSERT INTO' [23-Dec-2025 19:11:08 UTC] W9 Upload DB Error: Database operation failed. Please try again later. [23-Dec-2025 19:11:08 UTC] W9 Upload Error: Database insert failed: Database operation failed. Please try again later. [23-Dec-2025 19:12:00 UTC] W9 Upload DB Error (PDO): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contract_id' in 'INSERT INTO' [23-Dec-2025 19:12:00 UTC] W9 Upload Error: Database error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contract_id' in 'INSERT INTO' [23-Dec-2025 19:12:52 UTC] W9 Upload Error: Upload failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'INSERT INTO' [23-Dec-2025 19:13:02 UTC] W9 Upload Error: Upload failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'status' in 'INSERT INTO' [24-Dec-2025 07:36:33 UTC] Vendor webhook received: 2025-12-24 07:36:33 [24-Dec-2025 07:36:33 UTC] Webhook signature verification failed: Unable to extract timestamp and signatures from header [24-Dec-2025 20:35:06 UTC] Webhook received at 2025-12-24 20:35:06 [24-Dec-2025 20:35:06 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header [25-Dec-2025 17:16:14 UTC] Vendor webhook received: 2025-12-25 17:16:14 [25-Dec-2025 17:16:14 UTC] Webhook signature verification failed: Unable to extract timestamp and signatures from header [25-Dec-2025 17:16:14 UTC] Webhook received at 2025-12-25 17:16:14 [25-Dec-2025 17:16:14 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
✓ Everything looks good!
Debug completed at 2025-12-25 17:16:29