Intermittent Search for email returning 0 Issue

[aarons]

Hi Bubble Community,

I’m facing an intermittent login issue where some users see an “couldn’t find an account with that email” error, despite their email being correctly stored in the database. This is affecting a small but growing percentage of users, including some long-time customers, leading to frustration and cancellations.

Login

Workflow:

Email address exactly matches the entered version:

Troubleshooting Done:

1. Verified the workflow logic and email matching constraint.

2. Privacy rules are correctly set up.

3. Manual database updates temporarily resolve the issue.

What’s very strange, I have found a way to allow the user to login but only after I manually update their email address: I locate the user in the user data type and update their email field while keeping the email address exactly as it is so not changing it(e.g., adding/removing a space) then retry login and works **

Impact:

This issue has been ongoing for months and is causing increased cancellations.

Any insights or similar experiences? I appreciate any guidance to resolve this!

Thanks!

[WADSpot]

Hi,
Maybe you can try checking if there is an extra space(s) after the email’s value?

Also check the workflow steps where user email is updated. I tried something similar from my end, first name field, and I was able to replicate the issue by adding extra space after the value (see the highlighted characters in blue)

[GH5T]

You do not want to search for users email this way.

Create a back-end workflow that takes the email’s input TO LOWERCASE, then search for users email in the back-end workflow, and return “valid = yes/no” based on your conditions.

Should be good to go.

DO NOT ALLOW YOUR USERS TO SEARCH FOR USERS.

[aarons]

Appreciate that , I had already confirmed there is zero spaces surrounding value

[georgecollier]

Debugger will give you the answer, but if anyone can see anyone’s email then your privacy rules are not correctly set up.

[aarons]

Thanks GH5T the screenshot above is taken of a temporarily front end workflow i created only for trying resolving this issue. Backend workflows are already in place, cheers

[aarons]

This issue was escalated to the bubble engineering team, after further investigation we identified the issue.

Google Oauth was used for a period to allow new users to signup and create an account, after sometime a descision was made to remove the google signup/login button option and also the plugin.

The effected users had originally used this option to sign up. Reactivation the Google Oauth 2.0 plugin has resolved the issue for these users. Since the plugin is no longer installed, it is making the ‘email’ field unavailable as a constraint of a search. Re-installing the plugin should allow you to search on the ‘email’ field as expected.

Careful not to remove any Oauth related plugins that were used by users to signup.