[RESOLVED?] Error - Disconnected: detected data mismatch

This issue deserves another thread open as it has been incorrectly marked as resolved on the RSPN Trello Board: #480439

• Platform - PC | Windows 11 | Steam 
• Origin ID - IrishNinja 
• Steam Linked Account - NearSingularity
• 100% reproducible by attempting to launch the game with any affected account that has this issue. 

I'll attempt to provide all relevant details as I have in the other unresolved threads in hopes this gets looked at again.

Season 16:
For my account, this issue began in back in season 16 - one day I'd log in and all of my legends and skins were gone but my account level and stats were the same. I'd still be able to play the game on the account, just without any content I've previously purchased. The following day I'd login and have all of them back but I would have to re-equip every single legend skin, weapon skin, badge, everything again. I want to emphasize that my account stats have never reset.

Season 17:
Beginning in season 17, this error page was introduced, which prevents anyone with this issue from actually playing the game. Just like in season 16, for what seems to be random days and intervals; my account has all of its skins back and I'm able to play. When I am able to log in; my last active legend has the default skin and banner but the badges remain and obviously, my account progress is the same. I have to re-equip heirlooms, stat trackers, and all weapon skins.

We are now in season 18 still with this blocking error page. My account with multiple heirlooms, all battle passes, frankly dollars spent; is with an issue that is being ignored. This is frustrating.

So; to not repeat the rigmarole that customer support has the customer go through to try and fix this issue. I want to be clear, this is not an issue the client can fix. This is a database issue in which an account has multiple content profiles - or whatever table RSPN has named it - associated to the account. The client can do nothing to fix this issue.

Your backend clearly knows that what is returned is not what is expected hence the error. 

So without any actual context, here's some suggestions:

Short Term Fix:
Remove the blocking error page first and foremost. If it indeed is multiple associations, take a look at your query and how you are fetching the content from the account. If you are not sorting and just returning the first returned, that is an issue. You should probably sort by skins unlocked, progression, currency spent -- it'll be a clear winner on content unlocked.

I really hope your foreign key isn't changing on the account, but if it is, oh boy. 

Long Term Fix:

Take the time to investigate why there were multiple associations created and fix the root cause; then, do a safe migration to remove the incorrectly created content profiles on these accounts