Mautic Version

4.4.x series

PHP version

7.4.33

What browsers are you seeing the problem on?

Not relevant

What happened?

Users that have unsubscribed from newsletters or marketings email still get new mails.

The reason is that many database nowadays are configured to follow ANSI standard. And there are 2 query which are not correctly escaped, thus don't fail but don't return the correct result.

PR #12892 addresses this for the 4.4 branch

This bug is also relevant for 5.x branch

How can we reproduce this issue?

Step 1: Configure your database sql_mode to use ANSI

SET GLOBAL sql_mode = 'ANSI,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,STRICT_ALL_TABLES';

Step 2: And then test sending to conacts that are set to "do not contact".

Relevant log output

No response

Code of Conduct

• I confirm that I have read and agree to follow this project's Code of Conduct