# 6th November 2025 — MongoDB Index Fix and Backup UX Improvements [#76](https://github.com/nbarrett/ngx-ramblers/issues/76)
## [build 351](https://github.com/nbarrett/ngx-ramblers/actions/runs/19137184184) — [Refs: #76](https://github.com/nbarrett/ngx-ramblers/issues/76) — [commit 2f78318](https://github.com/nbarrett/ngx-ramblers/commit/2f78318)

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