<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<!DOCTYPE bugzilla SYSTEM "https://bugzilla.cupent.com/page.cgi?id=bugzilla.dtd">

<bugzilla version="5.3.3+"
          urlbase="https://bugzilla.cupent.com/"
          
          maintainer="Prem@cupent.com"
>

    <bug>
          <bug_id>454</bug_id>
          
          <creation_ts>2026-08-26 07:45:36 +0000</creation_ts>
          <short_desc>Profile Update fails with &quot;Duplicate entry&quot; SQL error (500) when updating Phone number — Email unique constraint incorrectly triggered</short_desc>
          <delta_ts>2026-08-26 07:47:55 +0000</delta_ts>
          <reporter_accessible>1</reporter_accessible>
          <cclist_accessible>1</cclist_accessible>
          <classification_id>1</classification_id>
          <classification>Unclassified</classification>
          <product>SPACE</product>
          <component>Customer</component>
          <version>unspecified</version>
          <rep_platform>PC</rep_platform>
          <op_sys>Windows</op_sys>
          <bug_status>OPEN</bug_status>
          <resolution></resolution>
          
          
          <bug_file_loc></bug_file_loc>
          <status_whiteboard></status_whiteboard>
          <keywords></keywords>
          <priority>High</priority>
          <bug_severity>High</bug_severity>
          <target_milestone>---</target_milestone>
          
          
          <everconfirmed>1</everconfirmed>
          <reporter name="Karunakaran">Karunakaran</reporter>
          <assigned_to name="Gopika">Gopika</assigned_to>
          
          
          <cf_testcase_id></cf_testcase_id>
          <cf_triaged_by>---</cf_triaged_by>
          <cf_rca></cf_rca>
          <cf_resolution_details></cf_resolution_details>
          <cf_impact_area></cf_impact_area>

      

      

      

          <comment_sort_order>oldest_to_newest</comment_sort_order>  
          <long_desc isprivate="0" >
    <commentid>1001</commentid>
    <comment_count>0</comment_count>
    <who name="Karunakaran">Karunakaran</who>
    <bug_when>2026-08-26 07:45:36 +0000</bug_when>
    <thetext>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&apos;t changed. Since the email already exists for that same user, the database throws a &quot;Duplicate entry&quot; error and blocks the update.</thetext>
  </long_desc><long_desc isprivate="0" >
    <commentid>1002</commentid>
    <comment_count>1</comment_count>
    <who name="Karunakaran">Karunakaran</who>
    <bug_when>2026-08-26 07:47:55 +0000</bug_when>
    <thetext>https://grhombustechnologies710.sharepoint.com/:v:/s/Cupent-SPCACE/IQDlgkgqSkD8TJB9qSNFVHXYAbhdIPKDtteTr6wTeocapDM?e=BqVbwe</thetext>
  </long_desc>
      
      

    </bug>

</bugzilla>