Mautic Community Forums

AbstractMySQLDriver.php line 106

Mauti 3.2.4
My PHP version is : 7.2.34
My MySQL/MariaDB version is (delete as applicable): MySQL 8.0.2

Updating/Installing Errors
I am (delete as applicable): Installing
Upgrading/installing via (delete as applicable) : Command Line

These errors are showing in the Mautic log :

In AbstractMySQLDriver.php line 106:
An exception occurred while executing 'An exception occurred while executing ‘SELECT count(leadIdPrimary) count, max(leadIdPrimary) maxId, min
(leadIdPrimary) minId FROM (SELECT DISTINCT l.id as leadIdPrimary, tcuYGjFK.id as tcuYGjFK_id, WXgoZExC
.lead_id AS WXgoZExC_lead_id FROM leads l LEFT JOIN (SELECT l.id FROM leads l LEFT JOIN lead_lists_lead
s TZVjPpCr ON l.id = TZVjPpCr.lead_id and TZVjPpCr.leadlist_id = 82 and (TZVjPpCr.manually_removed = 1)
WHERE (((l.never_contact_again IS NOT NULL) AND (l.never_contact_again <> ‘’)) AND (l.email = ?) AND (
TZVjPpCr.lead_id IS NULL)) OR (l.id IN (SELECT IEBZKlPH.lead_id FROM lead_lists_leads IEBZKlPH WHERE (I
EBZKlPH.leadlist_id = 82) AND ((IEBZKlPH.manually_added = 1) OR (IEBZKlPH.manually_removed = ‘’))))) t
cuYGjFK ON tcuYGjFK.id = l.id LEFT JOIN lead_lists_leads WXgoZExC ON WXgoZExC.lead_id = l.id and (WXgoZ
ExC.leadlist_id = 731) WHERE (l.zoomer_book_club_subscrib = ?) AND ((l.email IS NOT NULL) AND (l.email
<> ‘’)) AND (l.mailing_state = ?) AND (tcuYGjFK.id IS NULL) AND (WXgoZExC.lead_id IS NULL)) sss’ with p
arams [“change.c.email@gmail.com”, 1, “MB”]:

SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: ‘’

Your problem
My problem is : I cannot run mautic:segement:update I get the above error
In AbstractMySQLDriver.php line 106:
An exception occurred while executing 'SELECT count(leadIdPrimary)…
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: ‘’
In PDOStatement.php line 123:
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: ‘’

Steps I have tried to fix the problem :
ensure proper permissions ran all other cron jobs. can send mail manually.
ALLOW_INVALID_DATES sql mode