Am 13.02.2012 09:09, schrieb Paul J Stevens: > On 02/10/2012 07:25 PM, Reindl Harald wrote: > >> how do i get these idiotic warnings mysql speaks about? > http://dev.mysql.com/doc/refman/5.0/en/show-warnings.html
thanks, even after 10 years in business each day learning new things!
>> why do i get "could not fetch reply_body" for every single lmtp-delivery
>> independent if the user has a reply defined?
> So what are the values for start_date and stop_date?
i think i have catched the bug :-)
remove the quotes around 'NOW'
mysql> SELECT reply_body FROM dbmail_auto_replies WHERE user_idnr = 15 AND
'NOW()' BETWEEN start_date AND stop_date;
Empty set, 2 warnings (0.00 sec)
mysql> SHOW WARNINGS;
+---------+------+--------------------------------------------------------------------+
| Level | Code | Message
|
+---------+------+--------------------------------------------------------------------+
| Warning | 1292 | Incorrect datetime value: 'NOW()' for column 'start_date' at
row 1 |
| Warning | 1292 | Incorrect datetime value: 'NOW()' for column 'stop_date' at
row 1 |
+---------+------+--------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql> SELECT reply_body FROM dbmail_auto_replies WHERE user_idnr = 15 AND
NOW() BETWEEN start_date AND stop_date;
+---------------------------------------+
| reply_body |
+---------------------------------------+
| Autoreply-Test
testserver.rhsoft.net |
+---------------------------------------+
1 row in set (0.00 sec)
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
