ATProto Moods Migration - Final Status#

Date: October 15, 2025

✅ Summary#

• Total users with moods: 984
• Users with MongoDB records: 984 (100%)
• Users with ATProto accounts: 978 (99.4%)
• Users blocked from ATProto: 6 (0.6%)

🚫 Blocked Users (Cannot Get ATProto Accounts)#

These 6 users have MongoDB records and moods but cannot get ATProto accounts:

1. ac23menap (auth0|65226a325d31d4975863ce35)#

• Issue: Unsupported email domain
• Email: peterpansen@existiert.net
• Moods: 1
• Resolution: User could update to a supported email domain (Gmail, Outlook, etc.)

2. ac23juhud (auth0|6525178bd1e32567a940d062)#

• Issue: Handle already taken
• Email: mikahsamporna6@gmail.com
• Moods: 1
• Resolution: Investigate duplicate/orphaned ATProto account at ac23juhud.at.aesthetic.computer

3. ac23sezew (auth0|657cbe4f9a0fa387ad485d7e)#

• Issue: Auth0 account deleted (404)
• Moods: 1
• Resolution: None - user deleted their account

4. ac23ruhup (auth0|657ceffcece6959078d9a990)#

• Issue: Auth0 account deleted (404)
• Moods: 1
• Resolution: None - user deleted their account

5. ac24zekas (auth0|660ebd4851aa90d60be5c714)#

• Issue: Auth0 account deleted (404)
• Moods: 1
• Resolution: None - user deleted their account

6. ac24gahoc (auth0|66464b19829d72375c7c5f54)#

• Issue: Auth0 account deleted (404)
• Moods: 1
• Resolution: None - user deleted their account

📊 Total Moods#

• Moods ready to migrate: ~2,730 (from 978 users with ATProto)
• Moods blocked: 6 (from 6 users without ATProto)

✅ Actions Taken#

1. ✅ Fixed backfill script to use real Auth0 emails (not fake @aesthetic.computer emails)
2. ✅ Backfilled all 138+ missing legacy users from 2023
3. ✅ Created ATProto accounts for 978 users
4. ✅ Documented 6 edge cases that cannot be resolved automatically
5. ✅ Updated migration script with documentation of blocked users

🚀 Next Steps#

Run the final migration to sync all moods from MongoDB to ATProto:

cd /workspaces/aesthetic-computer/system/backend
PDS_URL=https://at.aesthetic.computer node migrate-all-users-moods.mjs --migrate

The migration script will automatically:

• Skip users without ATProto accounts (the 6 blocked users)
• Migrate ~2,730 moods for 978 users
• Show progress with mood text previews
• Generate a final report

📝 Notes#

• The 6 blocked users' MongoDB records are preserved
• Their moods remain in MongoDB only
• If issues are resolved in the future (email changes, Auth0 restored), they can be manually migrated
• Migration completion: 99.4% (6 users out of 984 cannot be automatically migrated)