Mautic Community Forums

Help !!! please

Help !!! please

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

Help !!! please
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

Duplicate of https://www.mautic.org/community/index.php/1460-help-campanha-mautic/0#p6092 and answered there as well. Please, do not ask the same question in multiple places.