6th November 2025 — MongoDB Index Fix and Backup UX Improvements #76
Remove incorrect unique index on memberAudit to prevent E11000 errors during login auditing, plus comprehensive backup/restore UX improvements.
Where to Find It
- Member Login: Backend audit logging no longer fails on duplicate entries
- Admin → Backup/Restore: Enhanced filtering, inline logs, improved backup selector
Benefits
- Reliable Login Auditing: Drops unique index member.userName_1 if present, creates non-unique index
- No Duplicate Key Errors: Prevents E11000 errors during member login auditing
- Better Backup Management: Source environment filter for S3 and local backups
- Improved Restore: Uses --dir and --nsInclude (deprecation fixes), auto-drills into DB subfolder
- Enhanced Security: Browser password prompts disabled on backup page (autocomplete off)
- Better Readability: Environment + long date badges, full path display, improved search
- Inline Logs: Session logs appear directly under each History row
Technical Details
Database Migration:
- Drop unique index on member.userName field if exists
- Create non-unique index on userName for query performance
- Prevents duplicate key errors when same user logs in multiple times
Backup/Restore Improvements:
- Add Source Environment filter dropdown
- Move Bulk Backup Management to dedicated Backups tab
- Fix mongorestore deprecation warnings with --dir and --nsInclude
- Robust S3 restore: verify downloads, fallback to bucket from path
- Log executed commands with redacted MongoDB URI
- Enrich local backups with environment/database metadata
- Lazy Settings render to prevent autocomplete issues