amitrana
27-04-04, 05:46 PM
Hi,
I am having problem with client followup emails if the mails have HTML. In these cases gateway.pl is unable to extract body of the email which causes insert query to fail.
problem: After client replies to acknowledgement of the original request, client recieves acknowledgement for a new ticket #0
email report goes correctly.
there is no ticket#0 in the system
gaeway.pl can update the original ticket but the insert for new ticket was failing. I printed the sql error it was "Column 'body' cannot be null "
In order to avoid this and make it run I put $body = ""; as first line of "sub get_body", after this addition insert query was not failing.
I also tried to print $attachement_info variable it has value Content-Type: multipart/alternative;boundary="----=_NextPart_000_010B_01C42C72.EC21F9C0
Please advice what should I do to get this to work?
thanks,
amit.
I am having problem with client followup emails if the mails have HTML. In these cases gateway.pl is unable to extract body of the email which causes insert query to fail.
problem: After client replies to acknowledgement of the original request, client recieves acknowledgement for a new ticket #0
email report goes correctly.
there is no ticket#0 in the system
gaeway.pl can update the original ticket but the insert for new ticket was failing. I printed the sql error it was "Column 'body' cannot be null "
In order to avoid this and make it run I put $body = ""; as first line of "sub get_body", after this addition insert query was not failing.
I also tried to print $attachement_info variable it has value Content-Type: multipart/alternative;boundary="----=_NextPart_000_010B_01C42C72.EC21F9C0
Please advice what should I do to get this to work?
thanks,
amit.