Unable to delete a contact method including capital letters

[trjExpensify]

If you haven’t already, check out our contributing guidelines for onboarding and email contributors@expensify.com to request to join our Slack channel!

---

Action Performed:

1. Launch the app -> Login in account
2. Navigate to Avatar > Profile > contact method
3. Add a new contact email including capital letters i.e DERP@DERP.COM
4. Delete the contact method you just added

Expected Result:

You should be able to delete the contact method

Actual Result:

Attempting to delete the contact method results in this error: Auth DeleteLogin returned an error

Workaround:

Can the user still use Expensify without this being fixed? Have you informed them of the workaround?

Platforms:

Which of our officially supported platforms is this issue occurring on?

• Android / native
• Android / Chrome
• iOS / native
• iOS / Safari
• MacOS / Chrome / Safari
• MacOS / Desktop

Version Number: v1.3.14-14
Reproducible in staging?: Y
Reproducible in production?: Y
If this was caught during regression testing, add the test name, ID and link from TestRail:
Email or phone of affected tester (no customers):
Logs: https://stackoverflow.com/c/expensify/questions/4856
Notes/Photos/Videos: Any additional supporting documentation

Screen_Recording_20230509_000311_New.Expensify.mp4

Expensify/Expensify Issue URL:
Issue reported by: @dhairyasenjaliya
Slack conversation: #18301 (comment)

View all open jobs on GitHub

Upwork Automation - Do Not Edit

• Upwork Job URL: https://www.upwork.com/jobs/~01c866a623249c0072
• Upwork Job ID: 1658592013696098304
• Last Price Increase: 2023-05-16

[melvin-bot]

Current assignee @Beamanator is eligible for the Engineering assigner, not assigning anyone new.

[melvin-bot]

Triggered auto assignment to @kadiealexander (Bug), see https://stackoverflow.com/c/expensify/questions/14418 for more details.

[melvin-bot]

Job added to Upwork: https://www.upwork.com/jobs/~01c866a623249c0072

[melvin-bot]

Bug0 Triage Checklist (Main S/O)

• This "bug" occurs on a supported platform (ensure Platforms in OP are ✅)
• This bug is not a duplicate report (check E/App issues and #expensify-bugs)
  • If it is, comment with a link to the original report, close the issue and add any novel details to the original issue instead
• This bug is reproducible using the reproduction steps in the OP. S/O
  • If the reproduction steps are clear and you're unable to reproduce the bug, check with the reporter and QA first, then close the issue.
  • If the reproduction steps aren't clear and you determine the correct steps, please update the OP.
• This issue is filled out as thoroughly and clearly as possible
  • Pay special attention to the title, results, platforms where the bug occurs, and if the bug happens on staging/production.
• I have reviewed and subscribed to the linked Slack conversation to ensure Slack/Github stay in sync

[melvin-bot]

Triggered auto assignment to Contributor Plus for review of internal employee PR - @rushatgabhane (Internal)

[trjExpensify]

Removing C+ given that it's a backend issue.

[Beamanator]

Dropping to weekly priority b/c there's soooo many irons in the fire, but I'll def get to this soon 😅

[dhairyasenjaliya]

Hehe @Beamanator do we need to anything at front end then i can help since i found this bug during adding forms to new contact method

[Beamanator]

Gooooooood question @dhairyasenjaliya , I will do some investigation soon, most likely it's just a backend change though

[Beamanator]

Alright so specifically with DeleteLogin, we do convert the email to lowercase when searching for the login to delete :D

• https://github.com/Expensify/Auth/blob/3787d75cd752227649565e1a2e05919e661434d1/auth/lib/Account.cpp#L47

I believe this also happens when requesting a new magic code for an email with capital letters (not sure if this has been reported yet?)

So this will require some back-end & some front end changes, both should lowercase new logins when:

1. Adding new contact methods
   • OldDot already lowercases new contact methods here
2. Sending magic codes / validating magic codes
3. Deleting contact methods

(Note: I confirmed in OldDot we lowercase new contact methods, so we should do the same here - I don't see any reason why we'd keep them multi-case)

[dhairyasenjaliya]

hm @Beamanator alright so I guess from the front end we just convert all emails to lowercase while submitting/deleting on a new contact so let me know once you change from the backend and we have probably 2 ways to change

Solution - 1 -> Pass lowerCase() when requesting to create a new acc, add a new contact method, delete the contact method

Solution - 2 -> We should modify EMAIL_BASE_REGEX to limit the capital letter from expensify-common library

[Beamanator]

It could be a good idea to prevent users from entering capital letters in emails in the front end, but this will be the last step so I'm planning to worry about this later - but I'll come back to your thoughts for sure @dhairyasenjaliya - thanks for your ideas!

FYI I started an internal discussion here to think about a migration we might have to run, making existing contact methods lowercase in the database & Onyx

[Beamanator]

@trjExpensify since there is a front-end component to this issue (noted & agreed upon in this thread) should we open this up by adding the External label? There's definitely a backend component (PR already linked above this comment) but we'll need some front end change too

[trjExpensify]

Sure, I think that's reasonable. @dhairyasenjaliya you seem interested, right?

[melvin-bot]

Reviewing label has been removed, please complete the "BugZero Checklist".

[melvin-bot]

The solution for this issue has been 🚀 deployed to production 🚀 in version 1.3.19-7 and is now subject to a 7-day regression period 📆. Here is the list of pull requests that resolve this issue:

• Make new contact methods lowercase #19520

If no regressions arise, payment will be issued on 2023-06-05. 🎊

After the hold period is over and BZ checklist items are completed, please complete any of the applicable payments for this issue, and check them off once done.

• External issue reporter
• Contributor that fixed the issue
• Contributor+ that helped on the issue and/or PR

As a reminder, here are the bonuses/penalties that should be applied for any External issue:

• Merged PR within 3 business days of assignment - 50% bonus
• Merged PR more than 9 business days after assignment - 50% penalty

[melvin-bot]

BugZero Checklist: The PR fixing this issue has been merged! The following checklist (instructions) will need to be completed before the issue can be closed:

• [@Beamanator] The PR that introduced the bug has been identified. Link to the PR: New contact method #15330
• [@Beamanator] The offending PR has been commented on, pointing out the bug it caused and why, so the author and reviewers can learn from the mistake. Link to comment: https://github.com/Expensify/App/pull/15330/files#r1210663265
• [@Beamanator] A discussion in #expensify-bugs has been started about whether any other steps should be taken (e.g. updating the PR review checklist) in order to catch this type of bug sooner. Link to discussion: https://expensify.slack.com/archives/C01GTK53T8Q/p1684850011107249
• [@Beamanator] Determine if we should create a regression test for this bug.
  • Yes I think it's smart to have QA test that adding mixed-case contact methods only actually creates lowercased contact methods 👍
• [@Beamanator] If we decide to create a regression test for the bug, please propose the regression test steps to ensure the same bug will not reach production again.
• [@trjExpensify] Link the GH issue for creating/updating the regression test once above steps have been agreed upon:

[Beamanator]

@trjExpensify added notes above 👍

[Beamanator]

FYI there was no payment needed, it was resolved internally

[Beamanator]

Finally - I plan to keep this open b/c we still want to get a Web-E PR merged - https://github.com/Expensify/Web-Expensify/pull/37561

[melvin-bot]

@Beamanator @trjExpensify this issue was created 2 weeks ago. Are we close to a solution? Let's make sure we're treating this as a top priority. Don't hesitate to create a thread in #expensify-open-source to align faster in real time. Thanks!

[trjExpensify]

Yes I think it's smart to have QA test that adding mixed-case contact methods only actually creates lowercased contact methods 👍

Did you update the script somewhere for the new contact methods rollout or something?

[Beamanator]

@trjExpensify we've been doing testrail updates throughout the rollout, we don't have 1 giant script anywhere sadly

[trjExpensify]

Okay, but same same.. are you saying the regression test update or that has been accounted for?

[Beamanator]

Oh oh like do I think we should add something to the regression tests for this? I think yes! We definitely don't want to be able to add mixed-case logins (primary or secondary) anywhere at the moment 👍

[trjExpensify]

Kewl, so can yah do this step or have you somewhere else? (I see it checked off).

@Beamanator] If we decide to create a regression test for the bug, please propose the regression test steps to ensure the same bug will not reach production again.

[Beamanator]

Oh ya sure, sorry I thought the steps would be pretty obvious :D I'm thinking something like:

1. Add a new contact method with some uppercase and some lowercase letters (example: MYEMAIL@gmail.COM)
2. Verify the contact method gets added in the "Contact Methods" page, in all lowercase letters (myemail@gmail.com)
3. Try removing that newly added contact method
4. Verify everything works as intended

[trjExpensify]

Great, amended a touch and created the issue for Applause.

Presuming as well with the Web-E issue merged and on prod we can close. Reopen if I missed something!

[dhairyasenjaliya]

Hey @trjExpensify am im eligible for reporting this bug 🐛

[trjExpensify]

Ah, sorry man. @Beamanator throwing me off! 😆

FYI there was no payment needed, it was resolved internally

Sent you a contract on this job.

[Beamanator]

Oh shit that's totally my bad 🙃

[dhairyasenjaliya]

no issue 😅

[trjExpensify]

Paid!