# AbstractMySQLDriver.php line 106

**URL:** <https://forum.mautic.org/t/abstractmysqldriver-php-line-106/20223>\
**Category:** Mautic 3 - Install/Upgrade Support\
**Created:** [July 21, 2021, 3:00am UTC](https://forum.mautic.org/t/abstractmysqldriver-php-line-106/20223 "2021-07-21T03:00:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![scott1](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/scott1/32/620_2.png) [@scott1](https://forum.mautic.org/u/scott1)\
**Post date:** [July 21, 2021, 3:00am UTC](https://forum.mautic.org/t/abstractmysqldriver-php-line-106/20223/1 "2021-07-21T03:00:17Z")

</div>

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](mailto: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