Troubleshooting Guide

❌ Wrong formats:
today 3:30 PM call client
today at 15:30 call client  
today/15:30 call client

✅ Correct formats:
today-15:30 call client
today-1530 call client
today-15.30 call client

❌ Wrong formats:
Dec 25 15:30 call client
12/25/2024-15:30 call client
25-12-2024-15:30 call client

✅ Correct formats:
today-15:30 call client
tomorrow-15:30 call client  
2024-12-25-15:30 call client

❌ Rejected: "today-15:30 call"
❌ Rejected: "today-15:30 go" 

✅ Accepted: "today-15:30 call client"
✅ Accepted: "today-15:30 go to meeting"

1. Check team member exists:
   - Go to dashboard → Team
   - Verify "john" is listed as slug
   - Ensure member is active

2. Test exact match:
   - Use exact slug from dashboard
   - Check for typos or extra spaces
   - Try without @ symbol: "john today-15:30 meeting"

1. Verify tag exists:
   - Dashboard → Team → Tags
   - Check exact tag name
   - Ensure tag has team members assigned

2. Check team member assignments:
   - Each team member should have tag_ids set
   - At least one member must have this tag
   - Members with tag must be active

Tag: {"id": 1, "name": "developers"}

Team Members:
- alice: {"tag_ids": [1]} ✅
- bob: {"tag_ids": [2]}   ❌ (wrong tag)
- charlie: {"tag_ids": [1], "is_active": false} ❌ (inactive)

-- Check if reminders are being logged
SELECT * FROM notification_history 
WHERE message_type = 'reminder' 
AND user_id = 'your-user-id'
ORDER BY sent_at DESC;

-- Check task scheduling
SELECT id, task_text, target_datetime, identifier
FROM tasks
WHERE user_id = 'your-user-id'
AND target_datetime <= NOW();

-- Task should still exist and have updated target_datetime
SELECT task_text, target_datetime, identifier
FROM tasks  
WHERE identifier = 'your-task-id';

-- Should show multiple reminders
SELECT COUNT(*) as reminder_count
FROM notification_history
WHERE related_task_id IN (
  SELECT id FROM tasks WHERE identifier = 'your-task-id'
);

1. Check active tasks:
   Send: "list"
   Look for task with ID 1

2. Verify task ID format:  
   Use exact ID from confirmation message
   ❌ "done #1" or "done task 1"
   ✅ "done 1"

3. Check if already completed:
   Task might have been completed already
   Check dashboard completed tasks

-- Task should be removed from tasks table
SELECT COUNT(*) FROM tasks WHERE identifier = 1;

-- Task should appear in finished_task table  
SELECT * FROM finished_task WHERE identifier = 1;

✅ Personal: "today-15:30 call client"
✅ Team: "@john today-15:30 meeting" 
✅ Group: "#team today-15:30 standup"
✅ List: "list" or "list today"
✅ Complete: "done 1"