Email opt-out not reflecting in table

[incusdata]

I have a contact on Sugar where the opt-out option has been selected (on screen the email address has clearly been struck out). When I run an SQL query directly against the database, however, the field email_opt_out for that contact still has the value "off". This has caused considerable embarrassment, as it means I have included this contact in an email run that takes place outside of Sugar.

I have also found another contact where the opt-out option has NOT been selected, but the raw data has the value "on" for the email_opt_out field in the contacts table.

I am running SugarCRM Community 5 on a MySQL database.

Jacqui
Incus Data

[kuske]

The opt_out field in contacts/accounts/leads is a relict from the previous version 4.5.1.

It is not used anymore since 5.0.0.

To get the email-settings in version >= 5.0.0 you can use the sql-statement

select c.*,cc.*,
ea.email_address, ea.invalid_email,ea.opt_out
from contacts_cstm cc,
contacts c
left join email_addr_bean_rel eabr
on eabr.bean_id = c.id and eabr.bean_module='contacts' and eabr.deleted=0
left join email_addresses ea
on eabr.email_address_id = ea.id and ea.deleted = 0
where c.id = cc.id_c;