- Issue created by @hchonov
- 🇩🇪Germany hchonov 🇪🇺🇩🇪🇧🇬
Oh this seems to have been resolved with 🌱 [Meta] 3.x Feature / Concept Improvement issue Fixed
- 🇩🇪Germany hchonov 🇪🇺🇩🇪🇧🇬
Could you then please tag a new version of the 2.x branch?
The query that was introduced with #3285521: Add maximum emails per hour feature → seems to not be widely supported. We first noticed issues with it during a deployment where in the logs the following error was logged:
SQLSTATE[HY000]: General errror: 1366 Incorrect integer value: " for column 'timestamp' at row 1
Initially we were unable to identify what causes it until a test running on SQLite was more descriptive with its error at the same place:
SQLSTATE[HY000]: General error: 1 near "HOUR": syntax error: SELECT COUNT(*
) FROM "watchdog_mailer_history" WHERE timestamp BETWEEN UNIX_TIMESTAMP(DAT
E_ADD(NOW(), INTERVAL -1 HOUR)) AND UNIX_TIMESTAMP(); Array ()
From my checking it seems that DATE_ADD is not available in SQLite which causes the issue over there, but I am still unsure why the issue was triggered during a deployment where we are using MySQL 5.7.42 / Percona Server (GPL) Release 46.
Set the timestamp variables in PHP for a wide range of support of databases.
Active
2.0
Code
Oh this seems to have been resolved with 🌱 [Meta] 3.x Feature / Concept Improvement issue Fixed
Could you then please tag a new version of the 2.x branch?