When we are deleting a lead then in all tables deleted status is getting changed to 1, except one table email_address.
Why this is happening?
How to delete email address once we removed from SugarCRM?
email_address is shared among leads/contacts/accounts and users. If the email address exists in any of those modules it will not mark it as deleted. there is a relationship between email_addr_bean_rel and email_addresses
So if johndoe@sugarcrm exists in a lead and in an account module
you will have 2 records in email_addr_bean_rel table
1 row bean_module 'lead'
1 row bean_module 'acccount'
1 row johndoe@sugarcrm
Thanks for reply.
I checked with create new lead and delete it, still the same issue.
Also, new issue i found when creating a new lead then in "email_addr_bean_rel" table has 2 entry for a lead. One entry with deleted status is 1 and other is 0. why?
anyone can reply please?
Which version of Sugar are you using? If you have professional or more maybe you can open a ticket with Sugar.
Are you are you are looking at the same records? Make sure that the email is unique and not same among any other modules (target,leads,contacts,accounts and user).
Create yourself and unique email and then recheck again.
Retrieving data ...