Mautic Community Forums

"Rebuilding leads for campaign 1" Cron Error

Hey all, love the product so far. Excited to really make use of it.



Everything seems to be working, EXCEPT I’m getting this error from one of my cron jobs. This is the full text of the cron notification email I’m getting:

Code:
Rebuilding leads for campaign 1

[DoctrineDBALDBALException]
An exception occurred while executing ‘SELECT max(list_leads.lead_id) as max_id, count(distinct(list_leads.lead_id)) as lead_count FROM lead_lists_leads list_leads WHERE (list_leads.manually_removed = ?) AND (list_leads.leadlist_id IN ()) AND (list_leads.date_added <= ‘2016-01-30 03:45:03’) AND (NOT EXISTS (SELECT null FROM campaign_leads campaign_leads WHERE (campaign_leads.lead_id = list_leads.lead_id) AND (campaign_leads.manually_removed = ?) AND (campaign_leads.campaign_id = 1)))’ with params [0, 0]:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (list_leads.date_added <= ‘2016-01-30 03:45:03’) AND (NOT EXISTS (SELECT ’ at line 1

[PDOException]
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (list_leads.date_added <= ‘2016-01-30 03:45:03’) AND (NOT EXISTS (SELECT ’ at line 1

mautic:campaigns:update [-l|–batch-limit[="…"]] [-m|–max-leads[="…"]] [-i|–campaign-id[="…"]] [-f|–force]

Content-type: text/html


All other crons seem to be working.

Is this a known issue? I wasn't able to find anything related, here or on github.
Any solution?
How will this effect my installation until it's fixed?

Hey all, love the product so far. Excited to really make use of it.

Everything seems to be working, EXCEPT I’m getting this error from one of my cron jobs. This is the full text of the cron notification email I’m getting:

Rebuilding leads for campaign 1



  [DoctrineDBALDBALException]
  An exception occurred while executing 'SELECT max(list_leads.lead_id) as max_id, count(distinct(list_leads.lead_id)) as lead_count FROM lead_lists_leads list_leads WHERE (list_leads.manually_removed = ?) AND (list_leads.leadlist_id IN ()) AND (list_leads.date_added <= '2016-01-30 03:45:03') AND (NOT EXISTS (SELECT null FROM campaign_leads campaign_leads WHERE (campaign_leads.lead_id = list_leads.lead_id) AND (campaign_leads.manually_removed = ?) AND (campaign_leads.campaign_id = 1)))' with params [0, 0]:
  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (list_leads.date_added <= '2016-01-30 03:45:03') AND (NOT EXISTS (SELECT ' at line 1






  [PDOException]
  SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')) AND (list_leads.date_added <= '2016-01-30 03:45:03') AND (NOT EXISTS (SELECT ' at line 1





mautic:campaigns:update [-l|--batch-limit[="..."]] [-m|--max-leads[="..."]] [-i|--campaign-id[="..."]] [-f|--force]


Content-type: text/html

All other crons seem to be working.

Is this a known issue? I wasn’t able to find anything related, here or on github.
Any solution?
How will this effect my installation until it’s fixed?

What Mautic version do you run? I think that this was fixed in 1.2.4.

That appears to have fixed it, thanks!