🔍 Operations Database Debug

1. Database Connection

✓ Database connected successfully!

2. Required Tables

Table NameStatusRow Count
departments✓ Exists9
staff✓ Exists8
staff_emergency_contacts✓ Exists0
staff_certifications✓ Exists0
staff_availability✓ Exists0
staff_shifts✓ Exists0
staff_documents✓ Exists1
department_staff✓ Exists0
department_resources✓ Exists0
tasks✓ Exists6
task_dependencies✓ Exists0
task_comments✓ Exists0
task_attachments✓ Exists0

3. Database Views

View NameStatus
department_summary✓ Exists
staff_summary✓ Exists
task_summary✓ Exists

4. Query Tests

QueryStatusDetails
departments✓ SuccessReturned 14 columns
staff✓ SuccessReturned 43 columns
tasks✓ SuccessReturned 20 columns

5. Sample Data

Departments:

IDNameCodeBudgetStatus
1OperationsOPS$50,000.00active
2ProductionPROD$75,000.00active
3SecuritySEC$40,000.00active
4MedicalMED$30,000.00active
5HospitalityHOSP$35,000.00active

Staff:

Total staff members: 8

Tasks:

Total tasks: 6

6. Foreign Key Constraints

TableColumnReferences
departmentsdepartment_head_idstaff.id
department_resourcesdepartment_iddepartments.id
department_staffdepartment_iddepartments.id
department_staffdepartment_iddepartments.id
department_staffstaff_idstaff.id
department_staffstaff_idstaff.id
staffdashboard_user_idadmin_users.id
staffdepartment_iddepartments.id
staff_availabilitystaff_idstaff.id
staff_certificationsstaff_idstaff.id
staff_documentsstaff_idstaff.id
staff_emergency_contactsstaff_idstaff.id
staff_shiftsdepartment_iddepartments.id
staff_shiftsstaff_idstaff.id
tasksdepartment_iddepartments.id
tasksparent_task_idtasks.id
tasksassigned_tostaff.id
task_attachmentstask_idtasks.id
task_commentstask_idtasks.id
task_dependenciesdepends_on_task_idtasks.id
task_dependenciestask_idtasks.id

7. PHP Environment

SettingValue
PHP Version8.2.30
PDO Driversmysql, sqlite
Display Errors
Error Reporting22527

8. Recent PHP Errors

Error log: /home/u420726827/.logs/error_log_soundhavenfestival_com

[14-May-2026 09:01:56 UTC] Webhook received at 2026-05-14 09:01:56
[14-May-2026 09:01:56 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
[14-May-2026 09:01:56 UTC] Webhook received at 2026-05-14 09:01:56
[14-May-2026 09:01:56 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
[14-May-2026 09:01:56 UTC] Webhook received at 2026-05-14 09:01:56
[14-May-2026 09:01:56 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
[14-May-2026 09:01:57 UTC] Webhook received at 2026-05-14 09:01:57
[14-May-2026 09:01:57 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
[14-May-2026 09:01:57 UTC] Webhook received at 2026-05-14 09:01:57
[14-May-2026 09:01:57 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
[14-May-2026 09:01:57 UTC] Webhook received at 2026-05-14 09:01:57
[14-May-2026 09:01:57 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
[14-May-2026 09:01:57 UTC] Webhook received at 2026-05-14 09:01:57
[14-May-2026 09:01:57 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
[14-May-2026 09:01:57 UTC] Webhook received at 2026-05-14 09:01:57
[14-May-2026 09:01:57 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header
[16-May-2026 08:59:01 UTC] Vendor webhook received: 2026-05-16 08:59:01
[16-May-2026 08:59:01 UTC] Webhook signature verification failed: Unable to extract timestamp and signatures from header
[22-May-2026 20:03:15 UTC] Webhook received at 2026-05-22 20:03:15
[22-May-2026 20:03:15 UTC] Webhook error: Invalid signature - Unable to extract timestamp and signatures from header

9. Recommendations

✓ Everything looks good!

Debug completed at 2026-05-22 20:59:42