Had a error in the mailwatch_sendmail_relay.php script and was unable to get it working. When checking the status of the service it responded with that there was an mysql exception.
In our case the xdelay field was formatted in our mail log as HH:MM:SS therefor the function dbquery failed in the mtalogprocessor.inc.php because the sql function SEC_TO_TIME was not formatted in seconds but in HH:MM:SS.
For us removing the SEC_TO_TIME function in the dbquery of mtalogprocessor.inc.php and just use the delay as is the dbquery was enough to get it back working.
Issue summary
Had a error in the
mailwatch_sendmail_relay.phpscript and was unable to get it working. When checking the status of the service it responded with that there was an mysql exception.In our case the
xdelayfield was formatted in our mail log asHH:MM:SStherefor the functiondbqueryfailed in themtalogprocessor.inc.phpbecause the sql functionSEC_TO_TIMEwas not formatted in seconds but inHH:MM:SS.For us removing the
SEC_TO_TIMEfunction in thedbqueryofmtalogprocessor.inc.phpand just use the delay as is thedbquerywas enough to get it back working.Installation
Version and method
Server configuration