Members disappear from Member listing but remain in EE exp_members db table about expressionengine HOT 2 OPEN

@jcogs-design this was a scenario where the exp_members table was in good shape but this specific member did not have an entry on the exp_member_data table which should be added when the member record is created. I haven't been able to see any reason why that didn't happen in your database but a temporary solution would be adding the missing pivot on exp_member_data.

The PR I've opened changes how ExpressionEngine's model gateways work so that this missing pivot record will not cause an error when trying to retrieve the main model and would resolve your issue here as well.

from expressionengine.

Ace - thanks for the update.
I'm not sure what might have happened to cause the underlying issue - we strongly suspect the 7.4.0 to 7.4.9 update (as the user had not reported any issues prior to this happening, and nothing else much has changed).
Making the model more tolerant of errors in table setup will help for sure - is it likely that the issue would get cleaned up by EE over time (I'm not clear about what happens to add entries to exp_member_data)?

from expressionengine.