# Campaigns Emails not being sent out?

**URL:** <https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427>\
**Category:** Product Support\
**Tags:** community\
**Created:** [October 4, 2020, 7:41pm UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427 "2020-10-04T19:41:44Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![cchevez](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cchevez/32/3539_2.png) [@cchevez](https://forum.mautic.org/u/cchevez)\
**Post date:** [October 4, 2020, 7:41pm UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/1 "2020-10-04T19:41:44Z")

</div>

**Your software**  
My Mautic version is: v3.0.2  
My PHP version is: 7.2.33

**Your problem**  
My problem is: So I am able to send out test emails and I know that I can send out manual emails, but it seems that my Bulk emails and Campaigns are not being sent out. I use Elastic email but seem to be the only one that can’t send out…

> **[How to configure SMTP & API](https://help.elasticemail.com/en/articles/2288319-how-to-configure-smtp-api)**
>
> Your Elastic Email SMTP & API Settings.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/3/36c1ed684a8c8a81cc66bac8bab5cdd2d436d30b.png)

This is my Crons Job and wanted to know if there is somthing wrong. I have Turned Off MOD and am not sure what else I can try… If anyone could guide I would be grateful…

Any Suggestion … ?

---

<div class="post-metadata">

**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\
**Post date:** [October 4, 2020, 8:46pm UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/2 "2020-10-04T20:46:24Z")

</div>

can you post your logs? Located in **mautic-install-directory/var/logs**

---

<div class="post-metadata">

**Author:** ![cchevez](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cchevez/32/3539_2.png) [@cchevez](https://forum.mautic.org/u/cchevez)\
**Post date:** [October 5, 2020, 12:59am UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/3 "2020-10-05T00:59:08Z")

</div>

I sent the details in your inbox, ty

---

<div class="post-metadata">

**Author:** ![mikew](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/mikew/32/5156_2.png) [@mikew](https://forum.mautic.org/u/mikew)\
**Post date:** [October 5, 2020, 5:12am UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/4 "2020-10-05T05:12:34Z")

</div>

would be quicker if you posted your logs here, you could get more replies :-).

---

<div class="post-metadata">

**Author:** ![joeyk](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/joeyk/32/11164_2.png) [@joeyk](https://forum.mautic.org/u/joeyk)\
**Post date:** [October 5, 2020, 10:41am UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/5 "2020-10-05T10:41:34Z")

</div>

Could you plz go to ssh and check what is the answer when you manually try to process your emails by simply running the cron command?

So go to ssh and type in the command you would add to your cron tab.

---

<div class="post-metadata">

**Author:** ![cchevez](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cchevez/32/3539_2.png) [@cchevez](https://forum.mautic.org/u/cchevez)\
**Post date:** [October 5, 2020, 1:17pm UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/6 "2020-10-05T13:17:13Z")

</div>

This is the log

[2020-10-03 01:51:13] mautic.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\NotNullConstraintViolationException: “An exception occurred while executing ‘INSERT INTO imports (is\_published, date\_added, created\_by, created\_by\_user, date\_modified, modified\_by, modified\_by\_user, checked\_out, checked\_out\_by, checked\_out\_by\_user, dir, file, original\_file, line\_count, inserted\_count, updated\_count, ignored\_count, priority, status, date\_started, date\_ended, object, properties) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-10-03 07:51:13”, 1, “Team TienditaSv”, null, null, null, null, null, null, null, “import.csv”, null, 0, 0, 0, 0, 512, 1, null, null, “lead”, “”]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘dir’ cannot be null” at /home/tiencxkz/website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103 {“exception”:"[object] (Doctrine\DBAL\Exception\NotNullConstraintViolationException(code: 0): An exception occurred while executing ‘INSERT INTO imports (is\_published, date\_added, created\_by, created\_by\_user, date\_modified, modified\_by, modified\_by\_user, checked\_out, checked\_out\_by, checked\_out\_by\_user, dir, file, original\_file, line\_count, inserted\_count, updated\_count, ignored\_count, priority, status, date\_started, date\_ended, object, properties) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [1, “2020-10-03 07:51:13”, 1, “Team TienditaSv”, null, null, null, null, null, null, null, “import.csv”, null, 0, 0, 0, 0, 512, 1, null, null, “lead”, “”]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘dir’ cannot be null at /home/tiencxkz/website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:103, Doctrine\DBAL\Driver\PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘dir’ cannot be null at /home/tiencxkz/website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:123, PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘dir’ cannot be null at /home/tiencxkz/website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:121)"}  
[2020-10-03 11:50:02] mautic.WARNING: PHP Warning - “continue 2” targeting switch is equivalent to “break 2”. Did you mean to use “continue 3”? - in file /home/tiencxkz/App.website.com/app/bundles/ReportBundle/Builder/MauticReportBuilder.php - at line 444 {“file”:"/home/tiencxkz/App.website.com/vendor/composer/…/…/app/bundles/ReportBundle/Builder/MauticReportBuilder.php"}  
[2020-10-03 15:16:54] mautic.WARNING: PHP Warning - “continue 2” targeting switch is equivalent to “break 2”. Did you mean to use “continue 3”? - in file /home/tiencxkz/App.website.com/app/bundles/ReportBundle/Builder/MauticReportBuilder.php - at line 444 {“file”:"/home/tiencxkz/App.website.com/vendor/composer/…/…/app/bundles/ReportBundle/Builder/MauticReportBuilder.php"}  
[2020-10-03 16:12:28] mautic.WARNING: PHP Warning - “continue 2” targeting switch is equivalent to “break 2”. Did you mean to use “continue 3”? - in file /home/tiencxkz/App.website.com/app/bundles/ReportBundle/Builder/MauticReportBuilder.php - at line 444 {“file”:"/home/tiencxkz/App.website.com/vendor/composer/…/…/app/bundles/ReportBundle/Builder/MauticReportBuilder.php"}  
[2020-10-03 16:47:36] mautic.WARNING: PHP Warning - “continue 2” targeting switch is equivalent to “break 2”. Did you mean to use “continue 3”? - in file /home/tiencxkz/App.website.com/app/bundles/ReportBundle/Builder/MauticReportBuilder.php - at line 444 {“file”:"/home/tiencxkz/App.website.com/vendor/composer/…/…/app/bundles/ReportBundle/Builder/MauticReportBuilder.php"}  
[2020-10-03 16:47:42] mautic.WARNING: PHP Warning - “continue 2” targeting switch is equivalent to “break 2”. Did you mean to use “continue 3”? - in file /home/tiencxkz/App.website.com/app/bundles/ReportBundle/Builder/MauticReportBuilder.php - at line 444 {“file”:"/home/tiencxkz/App.website.com/vendor/composer/…/…/app/bundles/ReportBundle/Builder/MauticReportBuilder.php"}  
[2020-10-03 16:48:01] mautic.WARNING: PHP Warning - “continue 2” targeting switch is equivalent to “break 2”. Did you mean to use “continue 3”? - in file /home/tiencxkz/App.website.com/app/bundles/ReportBundle/Builder/MauticReportBuilder.php - at line 444 {“file”:"/home/tiencxkz/App.website.com/vendor/composer/…/…/app/bundles/ReportBundle/Builder/MauticReportBuilder.php"}  
[2020-10-03 16:49:37] mautic.WARNING: PHP Warning - “continue 2” targeting switch is equivalent to “break 2”. Did you mean to use “continue 3”? - in file /home/tiencxkz/App.website.com/app/bundles/ReportBundle/Builder/MauticReportBuilder.php - at line 444 {“file”:"/home/tiencxkz/App.website.com/vendor/composer/…/…/app/bundles/ReportBundle/Builder/MauticReportBuilder.php"}  
[2020-10-03 16:49:43] mautic.WARNING: PHP Warning - “continue 2” targeting switch is equivalent to “break 2”. Did you mean to use “continue 3”? - in file /home/tiencxkz/App.website.com/app/bundles/ReportBundle/Builder/MauticReportBuilder.php - at line 444 {“file”:"/home/tiencxkz/App.website.com/vendor/composer/…/…/app/bundles/ReportBundle/Builder/MauticReportBuilder.php"}

---

<div class="post-metadata">

**Author:** ![EJL](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ejl/32/12155_2.png) [@EJL](https://forum.mautic.org/u/EJL)\
**Post date:** [October 5, 2020, 1:27pm UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/7 "2020-10-05T13:27:44Z")

</div>

> [@cchevez](#):
>
> SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘dir’ cannot be null” at /home/tiencxkz/website/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 103

Most of the log contents seem irrelevant to email processing. The above quote needs a look. Perhaps check your app/config/local.php file to make sure the proper db\_driver is set. pdo\_mysql on line 3.

can you change to Php 7.3 and retry? Post the logs after that test?

As @joeyk suggested: letting us know what is the result of running the cron command manually via SSH will give some good info. Screenshot it if you can and post it.

---

<div class="post-metadata">

**Author:** ![cchevez](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cchevez/32/3539_2.png) [@cchevez](https://forum.mautic.org/u/cchevez)\
**Post date:** [October 5, 2020, 1:55pm UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/8 "2020-10-05T13:55:21Z")

</div>

Yes, its seem that there is no information being processed when these action are being requested. I will do and give an update later… Ty for the Support from all.

---

<div class="post-metadata">

**Author:** ![cchevez](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/cchevez/32/3539_2.png) [@cchevez](https://forum.mautic.org/u/cchevez)\
**Post date:** [October 7, 2020, 6:02am UTC](https://forum.mautic.org/t/campaigns-emails-not-being-sent-out/16427/9 "2020-10-07T06:02:36Z")

</div>

> [@EJL](#):
>
> pdo\_mysql

So I did check and switched to 7.3 but still the same issue. Also I am not able to create Forms. I can workaround by adding it to the address bar. But there are not save and close buttons. Therefore, let see what happens. I am able to send via segments.

 ![PHP datata](https://us1.discourse-cdn.com/flex020/uploads/mautic/original/2X/3/3641d316cef84295002051afd41196846bd7a48f.png)
