strange whmcs email pipe behaviour

[LAZer414]

hi , i have 2 departments in my whmcs , sales and support@domain...

 

when someone sends email to support@domain... whmcs sends an empty email from support@domain with this title :

Invoice Payment Reminder

 

[TABLE=class: datatable, width: 100%]

[TR]

[TD=bgcolor: #EFF2F9]2014-07-03 20:56[/TD]

[TD=bgcolor: #EFF2F9]

Email Sent to <customername> (Invoice Payment Reminder) - User ID: 732

[/TD]

[TD=bgcolor: #EFF2F9]System[/TD]

[/TR]

[/TABLE]

 

this issue is happening after I was upgrading my mysql server from 5.1 to 5.5 in cpanel, and cronjob ran in the middle of that upgrade process . after the upgrade every email that is piped , an empty invoice reminder email is being sent to that customer !

 

i have killed the open cronjob processes of that user in my server when they didn't complete/continue after that upgrade.

but the rest of the days i still having this issue.

the new cronjobs start and complete with no issue but this email pipping happens everytime a customer sends a directemail to the site instead of sending a ticket from site.

 

how should i troubleshoot this issue ?

Edited July 3, 2014 by LAZer414

[LAZer414]

this is the log of the mail pipe systemmailimportlog.php , for the day that cronjob ran in the middle of mysql server upgrade :

[TABLE=class: datatable, width: 100%]

[TR]

[TD]2014-06-23 10:00[/TD]

[TD]support@[/TD]

[TD]Support Ticket Not Opened

From: «support@»[/TD]

[TD]Blocked Potential Email Loop[/TD]

[/TR]

[TR]

[TD]2014-06-23 10:00[/TD]

[TD]sales@[/TD]

[TD]From: «support@»[/TD]

[TD]Unregistered Email Address[/TD]

[/TR]

[/TABLE]

 

cronjob runs at 10:00 everyday.

 

 

this is today log :

[TABLE=class: datatable, width: 100%]

[TR]

[TD]2014-07-03 20:56[/TD]

[TD]support@[/TD]

[TD]New Email from @gmail.com

From: @gmail.com «@gmail.com»[/TD]

[TD]Ticket Imported Successfully[/TD]

[/TR]

[TR]

[TD]2014-07-01 10:49[/TD]

[TD]support@[/TD]

[TD]New Email from @yahoo.com

From: @yahoo.com «@yahoo.com»[/TD]

[TD]Ticket Imported Successfully[/TD]

[/TR]

[TR]

[TD]2014-06-30 10:00[/TD]

[TD]support@[/TD]

[TD]Invoice Payment Reminder

From: «support@»[/TD]

[TD]Blocked Potential Email Loop[/TD]

[/TR]

[TR]

[TD]2014-06-30 10:00[/TD]

[TD]sales@[/TD]

[TD]

From: «support@»[/TD]

[TD]Unregistered Email Address[/TD]

[/TR]

[TR]

[TD]2014-06-30 08:58[/TD]

[TD]sales@[/TD]

[TD]From: Shingpop-Online «noreply@tarad.com»[/TD]

[TD]Unregistered Email Address[/TD]

[/TR]

[/TABLE]

 

and the customer @ 20:56 used our site chat offline contact form and send email to supprt@... and he recieved an empty invoice reminder , I Posted in the first of this topic.

 

also i have changed the emails of the site chat program to chat@domain , and whmcs system emails to billing@domain .

and the issue still exists.

 

any suggestions ?

[LAZer414]

i still have this problem

when ever whmcs imports an email with pipe ( email forwarder in cpanel )

whmcs sends an empty invoice payment reminder !

 

 

here is ticket mail import log for test :

[TABLE=class: datatable, width: 100%]

[TR]

[TD]2014-07-12 17:54[/TD]

[TD]support@domain[/TD]

[TD]test import

From: @gmail.com»[/TD]

[TD]Ticket Imported Successfully[/TD]

[/TR]

[TR]

[TD]2014-07-12 17:46[/TD]

[TD]sales@domain[/TD]

[TD]test email to sales

From: @gmail.com»[/TD]

[TD]Ticket Imported Successfully[/TD]

[/TR]

[/TABLE]

 

 

here is systemactivitylog.php

 

[TABLE=class: datatable, width: 100%]

[TR]

[/TR]

[TR]

[TD]2014-07-12 17:54[/TD]

[TD]

Email Sent to ... (Invoice Payment Reminder) - User ID: 1

[/TD]

[TD]System[/TD]

[TD][/TD]

[/TR]

[TR]

[TD=bgcolor: #EFF2F9]2014-07-12 17:46[/TD]

[TD=bgcolor: #EFF2F9]

Email Sent to ... (Invoice Payment Reminder) - User ID: 1

[/TD]

[TD=bgcolor: #EFF2F9]System[/TD]

[/TR]

[/TABLE]

Edited July 12, 2014 by LAZer414

[WHMCS John]

Hi,

This is strange behaviour indeed and not something I've ever seen before. Please chekc your ticket escalation rules (Setup > Support).

 

Also try removing any custom action hooks /modules you may have (/includes/hooks and /modules/addons) as they may cause strange behaviour.

[LAZer414]

I have checked escalation rules , i didn't have any rules defined.

then i have checked my whmcs hooks , and there wasn't anything newly added.

 

anyway i have upgraded my whmcs to 5.3.8

then moved files inside includes\hooks dir to hooks123

and moved files inside modules\addons dir too addons123

to prevent them from executing .

 

then tested again and the issue still existed with pipe forwarder : /pipe/pipe.php .