# Help Campanha mautic

**URL:** <https://forum.mautic.org/t/help-campanha-mautic/3138>\
**Category:** General Discussion\
**Created:** [January 5, 2016, 10:29am UTC](https://forum.mautic.org/t/help-campanha-mautic/3138 "2016-01-05T10:29:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![celio](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/celio/32/50_2.png) [@celio](https://forum.mautic.org/u/celio)\
**Post date:** [January 5, 2016, 10:29am UTC](https://forum.mautic.org/t/help-campanha-mautic/3138/1 "2016-01-05T10:29:50Z")

</div>

Good day!  
  
I would like to clarify some doubts , installed in a mautic Vps Digital Ocean , with the Amazon SES  
  
doing some testing of a campaign , one a particular email eg [celiopadilha@gmail.com](mailto:celiopadilha@gmail.com) , I get all camapanha straight , but when I joined another email eg telexvip@yahoo.com.br , Nao get nothing or the spam, so does another [celiopbarreto@gmail.com](mailto:celiopbarreto@gmail.com) email.  
  
what intrigues is that mautic system , shows that the first email was sent to everyone, but only get in one.  
  
I need some Help.

---

<div class="post-metadata">

**Author:** ![celio](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/celio/32/50_2.png) [@celio](https://forum.mautic.org/u/celio)\
**Post date:** [January 5, 2016, 10:29am UTC](https://forum.mautic.org/t/help-campanha-mautic/3138/2 "2016-01-05T10:29:50Z")

</div>

Good day!  
I would like to clarify some doubts , installed in a mautic Vps Digital Ocean , with the Amazon SES  
doing some testing of a campaign , one a particular email eg [celiopadilha@gmail.com](mailto:celiopadilha@gmail.com) , I get all camapanha straight , but when I joined another email eg telexvip@yahoo.com.br , Nao get nothing or the spam, so does another [celiopbarreto@gmail.com](mailto:celiopbarreto@gmail.com) email.  
what intrigues is that mautic system , shows that the first email was sent to everyone, but only get in one.  
I need some Help.

---

<div class="post-metadata">

**Author:** ![ninjoan](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/ninjoan/32/1005_2.png) [@ninjoan](https://forum.mautic.org/u/ninjoan)\
**Post date:** [January 5, 2016, 9:28pm UTC](https://forum.mautic.org/t/help-campanha-mautic/3138/3 "2016-01-05T21:28:42Z")

</div>

check cron job

---

<div class="post-metadata">

**Author:** ![celio](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/celio/32/50_2.png) [@celio](https://forum.mautic.org/u/celio)\
**Post date:** [January 10, 2016, 6:36pm UTC](https://forum.mautic.org/t/help-campanha-mautic/3138/4 "2016-01-10T18:36:30Z")

</div>

Help !!!  
Good afternoon I’m getting this error when running the command  
php /srv/users/serverpilot/apps/mautic/public/app/console mautic:campaigns:update -f --env=prod

[DoctrineDBALDBALException]  
An exception occurred while executing ‘SELECT max(list\_leads.lead\_id) as ma  
x\_id, count(distinct(list\_leads.lead\_id)) as lead\_count FROM mautic\_lead\_li  
sts\_leads list\_leads WHERE (list\_leads.manually\_removed = ?) AND (list\_lead  
s.leadlist\_id IN ()) AND (list\_leads.date\_added \<= ‘2016-01-10 18:09:26’) A  
ND (NOT EXISTS (SELECT null FROM mautic\_campaign\_leads campaign\_leads WHERE  
(campaign\_leads.lead\_id = list\_leads.lead\_id) AND (campaign\_leads.manually  
\_removed = ?) AND (campaign\_leads.campaign\_id = 4)))’ with params [0, 0]:  
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i  
n your SQL syntax; check the manual that corresponds to your MySQL server v  
ersion for the right syntax to use near ‘)) AND (list\_leads.date\_added \<= ’  
2016-01-10 18:09:26’) AND (NOT EXISTS (SELECT ’ at line 1

[PDOException]  
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i  
n your SQL syntax; check the manual that corresponds to your MySQL server v  
ersion for the right syntax to use near ‘)) AND (list\_leads.date\_added \<= ’  
2016-01-10 18:09:26’) AND (NOT EXISTS (SELECT ’ at line 1

---

<div class="post-metadata">

**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\
**Post date:** [January 11, 2016, 10:34am UTC](https://forum.mautic.org/t/help-campanha-mautic/3138/5 "2016-01-11T10:34:50Z")

</div>

It seems to me like the error described in this fix:

[https://github.com/mautic/mautic/pull/1286](https://github.com/mautic/mautic/pull/1286)
