Came across this while testing the privacy consent plugin. The easiest way is to $query->dump()
the query in https://github.com/joomla/joomla-cms/blob/3.9-dev/plugins/system/privacyconsent/privacyconsent.php#L513
SELECT `r`.`id`,`r`.`user_id`,`u`.`email`
FROM `cxicl_privacy_consents` AS `r`
LEFT JOIN `cxicl_users` AS `u` ON u.id = r.user_id
WHERE `remind` = 0 AND DATE_ADD('2018-09-08 14:36:27', INTERVAL -323 DAY) > `created`
So the date in DATE_ADD quoted.
SELECT `r`.`id`,`r`.`user_id`,`u`.`email`
FROM `cxicl_privacy_consents` AS `r`
LEFT JOIN `cxicl_users` AS `u` ON u.id = r.user_id
WHERE `remind` = 0 AND DATE_ADD(2018-09-08 14:36:27, INTERVAL -323 DAY) > `created`
Date in DATE_ADD is not quoted.
Looks like this issue is caused by this PR #21844, that removed the quotes around the date in the string returned.
//cc @alikon
Labels |
Added:
?
|
Closed_By | franz-wohlkoenig | ⇒ | joomla-cms-bot |
Status | New | ⇒ | Closed |
Closed_Date | 0000-00-00 00:00:00 | ⇒ | 2018-09-08 15:19:10 |
Closed_By | ⇒ | franz-wohlkoenig |
Set to "closed" on behalf of @franz-wohlkoenig by The JTracker Application at issues.joomla.org/joomla-cms/22087
please test #22088