🚀 Stuck Campaign Detector - Automated detection and recovery system for stuck campaigns with webhook notifications
🔒 Security Enhancements - Password change validation and XSS prevention measures
✉️ Journey Email Reliability - Fixed critical Reply-To validation issues preventing email delivery
📊 Campaign Monitoring - Enhanced admin reporting with improved UI and stuck campaign management
🛠️ Developer Tools - MySQL slow query analysis and comprehensive log management
⚡ Performance Optimization - Database indexing for link click deduplication

🚀 Major Features

A comprehensive automated system for detecting and managing campaigns that stop progressing due to worker failures.

Key Capabilities:

Automated Detection: Cron job running every 5 minutes detects campaigns in 'Sending' status that have stopped progressing
Detection Criteria:
- No workers processing pending batches
- All workers silent (LastPingedAt > 60 seconds)
- Worker assignment lost (Working batches with no ProcessID)
Webhook Notifications: Real-time alerts with 30-minute cooldown to prevent spam
- HMAC-SHA256 signature support for security
- Comprehensive payload with campaign details and stuck reason
Admin UI Management:
- "Stuck Campaigns" filter to view all stuck campaigns (always visible, no date filtering)
- "Unstuck" action to reset stuck batches to Pending status
- "Mark as Failed" action to cancel stuck campaigns
Audit Trail: Complete logging in oempro_stuck_campaigns_log table with resolution tracking

Configuration:

STUCK_CAMPAIGN_DETECTOR_ENABLED=true
STUCK_CAMPAIGN_WEBHOOK_URL=
STUCK_CAMPAIGN_WEBHOOK_HMAC_SECRET=
STUCK_CAMPAIGN_NOTIFICATION_COOLDOWN_MINUTES=30

Database Migration Required:

docker exec oempro_app bash -c "cd /var/www/html/cli/ && php5.6 dbmigrator.php migrate"

Improved email sending reliability with strict validation and error handling for journey emails.