Bug 454 - Profile Update fails with "Duplicate entry" SQL error (500) when updating Phone number — Email unique constraint incorrectly triggered
Summary: Profile Update fails with "Duplicate entry" SQL error (500) when updating Pho...
Status: OPEN
Alias: None
Product: SPACE
Classification: Unclassified
Component: Customer (show other bugs)
Version: unspecified
Hardware: PC Windows
: High High
Assignee: Gopika (Gopika)
URL:
Depends on:
Blocks:
 
Reported: 2026-08-26 07:45 UTC by Karunakaran (Karunakaran)
Modified: 2026-08-26 07:47 UTC (History)
0 users

See Also:
Associated Test Case ID:
Triaged By: ---
Root Cause Analysis (RCA):
Resolution Summary / Fix Details:
Impact Area:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Karunakaran (Karunakaran) 2026-08-26 07:45:36 UTC
The Update API fails with a 500 error whenever a user updates their profile (e.g., just the phone number), because the backend re-checks the email for uniqueness even though it hasn't changed. Since the email already exists for that same user, the database throws a "Duplicate entry" error and blocks the update.