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