Multiple contacts with same email address

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

Is it possible to have multiple contacts with the same email address?

Whenever I try and save a contact with an email address that is already assigned to another contact, I get:

Database failure. Please refer to sugarcrm.log for details.

The log shows:

[3732][2b6ba4bc-460f-2a1e-b418-5342c44b3eb9][FATAL] Error updating table: contacts: Query Failed: UPDATE contacts
					SET date_modified='2014-04-08 11:01:35',modified_user_id='2b6ba4bc-460f-2a1e-b418-5342c44b3eb9',created_by='2b6ba4bc-460f-2a1e-b418-5342c44b3eb9',description=NULL,assigned_user_id='2b6ba4bc-460f-2a1e-b418-5342c44b3eb9',salutation='Mr.',first_name='Name',last_name='Surname',title=NULL,department=NULL,do_not_call=0,phone_home=NULL,phone_mobile=NULL,phone_work=NULL,phone_other=NULL,phone_fax=NULL,primary_address_street='Address 1\r\nAddress 2',primary_address_city='London',primary_address_state=NULL,primary_address_postalcode='EC2 3AE',primary_address_country=NULL,alt_address_street=NULL,alt_address_city=NULL,alt_address_state=NULL,alt_address_postalcode=NULL,alt_address_country=NULL,assistant=NULL,assistant_phone=NULL,lead_source=NULL,reports_to_id='',birthdate=NULL,campaign_id='',joomla_account_id=NULL,portal_account_disabled=0,portal_user_type='Single',=NULL
					 WHERE  contacts.id = '24f56998-bb30-efa3-646a-5343d672ee63' AND deleted=0: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '=NULL
					 WHERE  contacts.id = '24f56998-bb30-efa3-646a-5343d672ee63' AND dele' at line 2

If I try and save the same contact with a unique email address, it works fine. if I then update the contact with an existing email address the error occurs again.

Thanks.

#2

Hi Keith,

You can have multiple contacts with the same email address. You would normally get a “potential duplicate” warning asking if you really want to save it.

The problem you are facing is an error in the generated sql statement which, if you have run the 7.1 update, can be fixed as described here. The problem does not exist in the clean 7.1 install.

Cheers

Bruce

#3

Thanks Bruce, that worked. Although this was a clean 7.1 install, not an update so not sure what happened.

All good now, cheers.

#4

Hi Bruce,

I’ve just came across your comment that SuiteCRM 7.1 will show a “potential duplicate” warning message in case of email duplication.

This warning is not happening on my CE instance, and I need such a warning. Is this feature disabled by default? How can I enable it?

Regards,
Tawfeeq

#5

Hi Tawfeeq,

My “funny” answer would be to upgrade to SuiteCRM B)

In truth, I am not familiar with CE, having come to CRM directly to Suite 7.01.

Cheers

Bruce

#6

Sorry, Bruce, for confusing you.

I jut mentioned “CE” because I thought you are coming from a “Professional edition” backgound… What I meant is that I’m using SuiteCRM 7.0.x (which is based on SugarCRM CE 6.5)… So, we’re using the same SuiteCRM.

Can you send me a screenshot this warning message? I’m not able to see it, and need this feature.

Regards,
Tawfeeq

#7

Hi Tawfeeq,

See attached file for screen shot. It was produced using SuiteCRM 7.1 (clean install, not upgraded)

Cheers

Bruce