Error mautic segments update

Product Support
1

Hello,



When I execute the command to update segments:



/usr/bin/php-cli -q /home/myuser/my.subdomain/app/console mautic:segments:update



The proccess stops with an error and it does not update all segments. Below you can see the result of the command. Can you help me with this issue?



myuser@server [~]# /usr/bin/php-cli -q /home/myuser/my.subdomain/app/console mautic:segments:update

Rebuilding contacts for segment 1

0 total contact(s) to be added in batches of 300

total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 21

0 total contact(s) to be added in batches of 300

total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 2

0 total contact(s) to be added in batches of 300

total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 20

0 total contact(s) to be added in batches of 300

total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 3

0 total contact(s) to be added in batches of 300

0 total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 63

0 total contact(s) to be added in batches of 300

total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 65

0 total contact(s) to be added in batches of 300

0 total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 64

0 total contact(s) to be added in batches of 300

0 total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 76

0 total contact(s) to be added in batches of 300

0 total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 75

0 total contact(s) to be added in batches of 300

0 total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 77

0 total contact(s) to be added in batches of 300

0 total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 58

0 total contact(s) to be added in batches of 300

total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 72

0 total contact(s) to be added in batches of 300

total contact(s) to be removed in batches of 300

0 contact(s) affected



Rebuilding contacts for segment 15





[DoctrineDBALExceptionSyntaxErrorException]

An exception occurred while executing ‘SELECT count(l.id) as lead_count, ma

x(l.id) as max_id FROM mautic_leads l LEFT JOIN mautic_lead_lists_leads ll

ON (ll.leadlist_id = 15) AND (ll.lead_id = l.id) AND (ll.date_added <= ‘201

7-02-15 16:27:54’) WHERE (()) AND (ll.lead_id IS NULL)’:

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i

n your SQL syntax; check the manual that corresponds to your MariaDB server

version for the right syntax to use near ‘)) AND (ll.lead_id IS NULL)’ at

line 1







[DoctrineDBALDriverPDOException]

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i

n your SQL syntax; check the manual that corresponds to your MariaDB server

version for the right syntax to use near ‘)) AND (ll.lead_id IS NULL)’ 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 MariaDB server

version for the right syntax to use near ‘)) AND (ll.lead_id IS NULL)’ at

line 1





mautic:segments:update [-b|–batch-limit [BATCH-LIMIT]] [-m|–max-contacts [MAX-CONTACTS]] [-i|–list-id [LIST-ID]] [-f|–force] [-t|–timeout TIMEOUT] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [-n|–no-interaction] [-s|–shell] [-e|–env ENV]



Kind regards,

Bruno

2

Hello,

When I execute the command to update segments:

/usr/bin/php-cli -q /home/myuser/my.subdomain/app/console mautic:segments:update

The proccess stops with an error and it does not update all segments. Below you can see the result of the command. Can you help me with this issue?

myuser@server [~]# /usr/bin/php-cli -q /home/myuser/my.subdomain/app/console mautic:segments:update
Rebuilding contacts for segment 1
0 total contact(s) to be added in batches of 300
total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 21
0 total contact(s) to be added in batches of 300
total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 2
0 total contact(s) to be added in batches of 300
total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 20
0 total contact(s) to be added in batches of 300
total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 3
0 total contact(s) to be added in batches of 300
0 total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 63
0 total contact(s) to be added in batches of 300
total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 65
0 total contact(s) to be added in batches of 300
0 total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 64
0 total contact(s) to be added in batches of 300
0 total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 76
0 total contact(s) to be added in batches of 300
0 total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 75
0 total contact(s) to be added in batches of 300
0 total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 77
0 total contact(s) to be added in batches of 300
0 total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 58
0 total contact(s) to be added in batches of 300
total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 72
0 total contact(s) to be added in batches of 300
total contact(s) to be removed in batches of 300
0 contact(s) affected

Rebuilding contacts for segment 15

[DoctrineDBALExceptionSyntaxErrorException]
An exception occurred while executing ‘SELECT count(l.id) as lead_count, ma
x(l.id) as max_id FROM mautic_leads l LEFT JOIN mautic_lead_lists_leads ll
ON (ll.leadlist_id = 15) AND (ll.lead_id = l.id) AND (ll.date_added <= ‘201
7-02-15 16:27:54’) WHERE (()) AND (ll.lead_id IS NULL)’:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near ‘)) AND (ll.lead_id IS NULL)’ at
line 1

[DoctrineDBALDriverPDOException]
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error i
n your SQL syntax; check the manual that corresponds to your MariaDB server
version for the right syntax to use near ‘)) AND (ll.lead_id IS NULL)’ 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 MariaDB server
version for the right syntax to use near ‘)) AND (ll.lead_id IS NULL)’ at
line 1

mautic:segments:update [-b|–batch-limit [BATCH-LIMIT]] [-m|–max-contacts [MAX-CONTACTS]] [-i|–list-id [LIST-ID]] [-f|–force] [-t|–timeout TIMEOUT] [-h|–help] [-q|–quiet] [-v|vv|vvv|–verbose] [-V|–version] [–ansi] [–no-ansi] [-n|–no-interaction] [-s|–shell] [–process-isolation] [-e|–env ENV] [–no-debug] [–]

Kind regards,
Bruno

3

Does anyone know anything about this error?
Thanks!

4

Thanks! And do you know how can I locate this invalid character and fix the problem?

5

Thank you for your help. I checked the segment looking for invalid characters but couldn’t find anything. So I filled a bug on Mautic Github page. Hope they can help me solve this issue.

Kind regards,
Bruno

6

Hello, is there any solution for this issue @MxyzptlkFishStix ?

Aprecciate your help

7

@MxyzptlkFishStix Didn’t we handle the error with the WHERE (()) some weeks ago? I cannot find it in the forum.