Refresh Contacts retrieved by SOAP call?

[MateoLeFou]

I had inadvertently allowed a duplicate contact to get in, and have since fixed this by deleting the offending database record (SOAP admin interface wasn't working correctly for me at the time);

However, soap calls on the email (which is now unique, and for which there is only one match) are still returning an entry_list with 2 matches. Is there something else I have to do?

[kuske]

email adresses are related by table email_addr_bean_rel to email_addresses, so there must be a reference to the deleted contact in email_addr_bean_rel.

[MateoLeFou]

that sounded great, but no love
select * from email_addr_bean_rel where bean_id='55d657c4-96a6-f1bf-bfbe-4963d43f16ab' or id='55d657c4-96a6-f1bf-bfbe-4963d43f16ab' or email_address_id='55d657c4-96a6-f1bf-bfbe-4963d43f16ab' limit 6;

Empty set (0.01 sec)

Unless I'm misunderstanding that table, that means this isn't the problem.

Maybe this helps: the email in question is a custom field ("contacts_cstm.username_c"). So sugar might not be treating this as an email. Is there another bean_rel lookup table for other kinds of fields?

[kuske]

perhaps
select * from contacts_cstm where id_c='55d657c4-96a6-f1bf-bfbe-4963d43f16ab' ;
would be better

or perhaps
select * from contacts_cstm where id_c not in (select id from contacts);
would help to find dead custom fragments