✓ Database connected
=== Checking Required Tables ===
✓ departments exists
✓ staff exists
✓ tasks exists
=== Testing Main Query (with full_name) ===
✓ Main query works!
✓ Returned data:
Array
(
[id] => 10
[task_number] => TSK-2026-7885
[title] => Promo Team Start Date
[description] =>
[department_id] => 7
[assigned_to] => 2
[priority] => low
[status] => pending
[progress_percentage] => 0
[start_date] =>
[due_date] => 2026-04-15
[completed_date] =>
[estimated_hours] =>
[actual_hours] =>
[parent_task_id] =>
[created_by] => 1
[created_at] => 2026-03-24 13:14:48
[updated_at] => 2026-03-25 22:18:46
[department_name] => Marketing
[dept_color] => #ff69b4
[assigned_to_name] => Kindra Lawlor
[created_by_name] => Dylan Ball
[comment_count] => 0
[days_until_due] => 8
)
=== Testing Stats Query (EXACT from tasks.php) ===
✓ Stats query works!
Array
(
[total_tasks] => 6
[pending] => 6
[in_progress] => 0
[completed] => 0
[overdue] => 0
[high_priority] => 0
)
=== 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.