✓ Database connected
=== Checking Required Tables ===
✓ departments exists
✓ staff exists
✓ tasks exists
=== Testing Main Query (with full_name) ===
✓ Main query works!
✓ Returned data:
Array
(
[id] => 1
[task_number] => TSK-2025-0001
[title] => Set up main stage sound system
[description] => Install and test all audio equipment for the main stage
[department_id] => 2
[assigned_to] =>
[priority] => high
[status] => in_progress
[progress_percentage] => 50
[start_date] =>
[due_date] => 2025-06-01
[completed_date] =>
[estimated_hours] =>
[actual_hours] =>
[parent_task_id] =>
[created_by] => 1
[created_at] => 2025-12-21 20:10:47
[updated_at] => 2025-12-21 20:10:47
[department_name] => Production
[dept_color] => #ff10f0
[assigned_to_name] =>
[created_by_name] => Dylan Ball
[comment_count] => 0
[days_until_due] => -207
)
=== Testing Stats Query (EXACT from tasks.php) ===
✓ Stats query works!
Array
(
[total_tasks] => 8
[pending] => 2
[in_progress] => 2
[completed] => 2
[overdue] => 6
[high_priority] => 5
)
=== Checking task_comments table ===
✓ task_comments exists
Row count: 0
If admin_users table is missing, tasks.php needs to be updated to remove that join.