Mautic Community Forums

SQL error when running mautic:leadlists:update

Hi!



We need urgent help and support.



Because the leadlist update and the point update in our campaigns (f.e. DOI) doesn´t work, our developper checked it on the server and he got the follwoing error:

[DoctrineDBALDBALException]

An exception occurred while executing ‘SELECT count(l.id) as lead_count, max(l.id) as max_id FROM leads l WHERE ()’:

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 ‘)’ at l

ine 1

All debugging couldn´t solve the problem.



More detailled here:



https://github.com/mautic/mautic/issues/1575



All cron jobs are set as in the manula described.



The DOI campaign was set up like described here: https://www.mautic.org/blog/integrator/creating-a-double-opt-in-email-campaign/



Thanks in advance for your support!!!



Matt

Hi!

We need urgent help and support.

Because the leadlist update and the point update in our campaigns (f.e. DOI) doesn´t work, our developper checked it on the server and he got the follwoing error:
[DoctrineDBALDBALException]
An exception occurred while executing ‘SELECT count(l.id) as lead_count, max(l.id) as max_id FROM leads l WHERE ()’:
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 ‘)’ at l
ine 1
All debugging couldn´t solve the problem.

More detailled here:

https://github.com/mautic/mautic/issues/1575

All cron jobs are set as in the manula described.

The DOI campaign was set up like described here: https://www.mautic.org/blog/integrator/creating-a-double-opt-in-email-campaign/

Thanks in advance for your support!!!

Matt