Deleted email addresses show when exporting contacts

**iliane** · 2008-03-03, 11:53 PM

Hi,

I am trying to export all my contacts. When the csv file opens i see email addresses, that I deleted.

Checking in Sugar, the email address is not in the contact anymore, but selecting the contact and clicking export the email shoes in the csv file.

I read somewhere about a similar issue and clearing the chach helped. I tried it in firefox and IE and it didnt help.

Any ideas are appreciated!!!

Iliane

**dpatech** · 2008-03-04, 09:40 AM

This is a bug in the Sugar code. You can fix by editing the file modules/Contacts/Contacts.php and editing function create_export_query.

For Sugar 5.0b change this line:

PHP Code:

 $query .=  ' LEFT JOIN  email_addr_bean_rel on contacts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module=\'Contacts\' and email_addr_bean_rel.primary_address=1 ';

PHP Code:

 $query .=  ' LEFT JOIN  email_addr_bean_rel on contacts.id = email_addr_bean_rel.bean_id and email_addr_bean_rel.bean_module=\'Contacts\' and email_addr_bean_rel.primary_address=1 and email_addr_bean_rel.deleted=0 ';