diff options
| author | Toufik Ben Jaa <tbe@odoo.com> | 2018-11-14 18:54:12 +0000 |
|---|---|---|
| committer | Toufik Ben Jaa <tbe@odoo.com> | 2018-11-14 18:54:12 +0000 |
| commit | 774991946e491ee1c7fdf772405bc0e2c111fdaa (patch) | |
| tree | bc198caddff1f006aaa0fc5f17eec1b4529fcd87 | |
| parent | ce616fff6c3d4e8b74bdd55fd200ff238bd741cc (diff) | |
[FIX] mail: no mail sent to followers
- If the `internal` field/column on the message subtypes (table: `mail_message_subtype`) is set to null instead of false in the
database, the notifications to the followers are not sent by mail.
closes odoo/odoo#28699
| -rw-r--r-- | addons/mail/models/mail_followers.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/addons/mail/models/mail_followers.py b/addons/mail/models/mail_followers.py index ccb245e18d3..6392a60466b 100644 --- a/addons/mail/models/mail_followers.py +++ b/addons/mail/models/mail_followers.py @@ -121,7 +121,7 @@ SELECT partner.id as pid, NULL AS cid, SELECT partner_id FROM sub_followers WHERE sub_followers.channel_id IS NULL AND sub_followers.partner_id = partner.id - AND (sub_followers.internal <> TRUE OR partner.partner_share <> TRUE) + AND (coalesce(sub_followers.internal, false) <> TRUE OR coalesce(partner.partner_share, false) <> TRUE) ) %s GROUP BY partner.id, users.notification_type UNION |