Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value

[henryhayes]

Caused by the change in MySQL 8.0.16 documented here on StackOverflow, DATETIME column values can no longer be compared to an empty string.

Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1525 Incorrect DATETIME value: '', query was:

SELECT `joins`.`entity_id`, `joins`.`publish_date_store` AS `store_id`, IF (joins.publish_date IS NULL OR joins.publish_date = '', joins.publish_date_default, joins.publish_date ) AS publish_date FROM ( SELECT `e`.`entity_id`, `publish_date_default`.`value` AS `publish_date_default`, `evozon_blog_post_publish_date`.`value` AS `publish_date`, `evozon_blog_post_publish_date`.`store_id` AS `publish_date_store` FROM `evozon_blog_post_entity` AS `e` -> INNER JOIN `evozon_blog_post_entity_datetime` AS `publish_date_default` ON publish_date_default.entity_id = e.entity_id AND publish_date_default.attribute_id = '322' AND publish_date_default.store_id = 0 -> LEFT JOIN `evozon_blog_post_entity_datetime` AS `evozon_blog_post_publish_date` ON evozon_blog_post_publish_date.entity_id = e.entity_id AND evozon_blog_post_publish_date.attribute_id = '322' WHERE ( e.entity_id IN ('3'))) AS `joins`;

Evozon_Blog_Model_Resource_Indexer_UrlRewrite_Data_Source::getAttributesValue()

Investigation continues...

[henryhayes]

Fix:

if (stristr($attrCode, 'date')) { $expr = new Zend_Db_Expr("IF (joins.{$attrCode} IS NULL, joins.{$attrCode}_default, joins.{$attrCode} ) AS {$attrCode}"); } else { $expr = new Zend_Db_Expr("IF (joins.{$attrCode} IS NULL OR joins.{$attrCode} = '', joins.{$attrCode}_default, joins.{$attrCode} ) AS {$attrCode}"); }

        $selectSql = $adapter->select()
            ->from(
                array('joins' => $select),
                array(
                    'entity_id' => 'joins.entity_id',
                    'store_id' => "joins.{$attrCode}_store",
                    $expr
                )
            );

[henryhayes]

Fixed on pull request #6